Microsoft SQL Server Express is a freely downloadable and distributable version of Microsoft's SQL Server relational database management system. It is targeted for embedded and smaller-scale applications, having a number of technical restrictions.
52
votes
17answers
170k views
How can I determine installed SQL Server instances and their versions?
I'm trying to determine what instances of sql server/sql express I have installed (either manually or programmatically) but all of the examples are telling me to run a SQL query to determine this ...
29
votes
1answer
32k views
SQL Express connection string for Entity Framework Code First
I am working in Visual Web Developer 2010 Express, and using the Entity Framework Code First CTP. I am able to do this with the new SQL CE but I am unable to find a connection string to work with SQL ...
26
votes
15answers
73k views
How can I schedule a daily backup with SQL Server Express?
I'm running a small web application with SQL server express (2005) as backend. I can create a backup with a SQL script, however, I'd like to schedule this on a daily basis. As extra option ...
23
votes
6answers
17k views
Error: Failed to generate a user instance of SQL Server
I'm trying to connect to an MDF. I've even gone to the lengths of re-installing sql server express entirely (it is now the only flavor of SQL installed on my box, where previously I had 05 dev and ...
20
votes
5answers
8k views
SQL Express for production?
Is using SQL Express in a production environment a reasonable choice?
I looked at Microsoft's comparison chart:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
I would be using ...
19
votes
2answers
11k views
Point to localhost\sqlexpress using only localhost
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 maintain ...
18
votes
3answers
31k views
Cannot connect to local SQL Server Express 2008 R2
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), SQL ...
18
votes
7answers
14k views
Is there a SQL Server Profiler for SQL Server Express?
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?
14
votes
7answers
22k views
How to run a stored procedure every day in SQL Server Express Edition?
How is it possible to run a stored procedure at a particular time every day in SQL Server Express Edition?
Notes:
This is needed to truncate an audit table
An alternative would be to modify the ...
14
votes
7answers
10k views
What happens when you hit the SQL Server Express 4GB / 10GB limit?
What kind of error occurs? What do users experience? Can you access the database using tools and what if you get it back under the 4GB / 10GB limit?
14
votes
4answers
32k views
DB cannot be opened because it is version 655. This server supports version 612
I'm trying to do some excercises from exam 70-515. Unfortunately I fail while trying to attach Northwind to a grid-control. It would result in:
NORTHWND.MDF' cannot be opened because it is version ...
13
votes
10answers
33k views
Any good SQL Server Management software for Mac OS?
I am used to using SQL Management Studio Express on Windows and was wondering if there were any good ones with similar functionality and price (free) for Mac OS X.
12
votes
6answers
13k views
Can I get sql profiler for sql2008 for free?
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
12
votes
1answer
18k views
Enable tcp\ip remote connections to sql server express already installed database with code or script(query)
I am deploying sql express with my application. I will like that database engine to accept remote connections. I know how to configure that manual by launching the sql server configuration manager, ...
12
votes
1answer
246 views
connect to sql “server group” with php to run query over mutiple databases
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 ...
