sql-server-express Questions
7
Solved
I am using SQL Express databases as part of a unit test project in c#. My databases is located here:
./Databases/MyUnitTestDB.mdf
I would like to use a relative path or variable in the app.con...
Gayelord asked 17/8, 2010 at 8:57
4
Solved
A colleague I work with recently told me that SQL Express and MS Access were essentially the same thing; that does not seem to be an accurate statement. I know you can convert Access to a SQL DB an...
Devotion asked 18/4, 2011 at 14:46
3
Solved
I have a SQL2005 Express database that I would like to create a copy of on the same instance. How do you go about doing this with a script?
I already have a script for generating the backup, but t...
Argentic asked 1/9, 2009 at 4:30
7
Solved
Is it possible to get sql profiler for sql2008 for free or you have to have a license to get it?
i.e. it won't work with sql express
Useless asked 9/2, 2009 at 14:28
3
Solved
I cannot get my local computer to run SQL Server. I looked in the SQL Server configuration manager and noticed that there are no SQL Server Services listed. That can't be right. I also noticed that...
Deweese asked 28/12, 2010 at 21:38
5
Solved
I'm getting a little confused here between LocalDB and SQL Server Express. I have read from websites that LocalDB is an improved version of SQL Server Express (source). I would assume this implies ...
Tevere asked 24/4, 2014 at 14:26
6
Solved
The purpose is to handle the user's data (you can call them project, document, file, or whatever) in a brand new SQL Server 2008 Express database. The data are expected to occupy much less space th...
Nananne asked 27/2, 2010 at 20:26
8
Solved
is there a way to monitor detail of sql calls in express version?
Frustrated asked 5/3, 2009 at 20:2
3
Hi I am trying to do a database diagram in visio 2010 to existing database. I am using the reverse engineer wizard. When I push new button on datasource field. I follow the steps to add new datasou...
Bargello asked 14/4, 2011 at 4:43
3
I'm working on a project that uses a SQL Server Express database that is decently large already and I know indexing specific columns / tables can take up quite a bit of space.
What I don't know i...
Periphrastic asked 6/2, 2013 at 22:22
4
Solved
I just installed SQL Server Express 2008 R2 and I have a problem connecting to it using the SQL Server Management Studio (locally).
All SQL Server services are started (SQL Server (SQLEXPRESS), SQ...
Glair asked 14/5, 2011 at 12:58
3
Solved
Working on a common codebase, one developer is running SQL Server Express 2005 and the other 2 are running SQL Server 2005. Everything is working fine, but the connection strings differ. To maintai...
Raeraeann asked 16/1, 2009 at 5:40
2
Solved
I am writing a method in C# to query a SQL Server Express database from a WCF service. I have to use ADO.NET to do this (then rewrite it with LINQ later on).
The method takes two strings (fname, l...
Mcconaghy asked 10/10, 2013 at 15:24
4
Solved
I don't have SQL Server Management Studio on my machine.
I have a database backup (SQL Server 2008 R2). There is SQL Server Express that installed with Visual studio 2010 ultimate installed on my ...
Constrictive asked 2/6, 2011 at 17:2
6
Solved
I have a small project that will have 1 user on 1 computer. The database will be rather small (probably less than 1 mb of data). I plan to use WPF and Entity Framework for that project.
I came up ...
Themselves asked 11/3, 2012 at 13:34
2
I have a problem with a SQL database query that suddenly (but regularly about every three weeks) becomes slow.
Setup is the following:
Windows Server 2008 (not R2) 64 bit, 8 GB RAM
SQL Server Ex...
Municipality asked 10/7, 2013 at 18:14
1
Solved
I need to deploy a WCF service with a database on client machines. I am confused about SQL Server Express. I need to verify all of the following.
When attaching database files in the App_Data fol...
Christine asked 9/7, 2013 at 12:19
2
Solved
I created a brand new Web API project, created a simple Code First model (one class with an id and the dbcontext object, and that's it), and ran Enable-Migrations in the package manager console.
I...
Precaution asked 17/2, 2013 at 4:1
5
Is there a SQL Server Profiler for SQL Server Expess? Maybe an open-source one? Or maybe just a tool that helps me see what query is passed to the database?
Squarrose asked 17/4, 2009 at 13:2
1
I am trying to connect to an MSSQL Server group with PHP and action a select query over a view
. I can connect & pull results from the server
. I can connect & pull results from a DB
With ...
Deason asked 4/4, 2013 at 5:22
3
Solved
I have a simple SQL query that updates some date fields in a record, on a SQL Express instance.
I'd like to have it run automatically every month. What is the best way of accomplishing this in SQ...
Scudo asked 24/9, 2010 at 15:31
5
Solved
I am trying to use the aspnet___regsql utility to install all the membership tables in a database on my local SQL Express 2008 instance. I can connect without problems in Management Studio, but whe...
Caryncaryo asked 2/2, 2009 at 21:51
3
Solved
I have an ASP.NET v2.0 website (not web application) where the root directory is public, but the "Admin" subdirectory requires authentication. Everything about the setup is very generic - I used a ...
Transformism asked 9/9, 2009 at 22:17
2
Solved
I have a number of VMs on Windows Azure (Iaas) hosting a website. There are a number of load-balanced front-end VMs, all connecting to a single VM with SQL Express. It works well.
However!
...
Encyclopedist asked 9/5, 2013 at 8:41
3
I have a problem with installing SQL Server 2008 R2 Express.
On my computer, I have installed VC# and VWebdev 2010 express.
It included SQL Server 2008 Express inside.
After that, I did an upgrad...
Jasper asked 20/11, 2010 at 14:43
© 2022 - 2024 — McMap. All rights reserved.