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.
Questions tagged [sql-server-express]
1718 questions
29
votes
12 answers
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 express). I've verified that the paths are all…
Joel Martinez
- 46,929
- 26
- 130
- 185
29
votes
2 answers
how to auto increment primary key in visual studio built in sql server?
I am using Visual Studio 2010 premium, and I created a database by using Visual Studio database tool. I set a field as primary key and I want to make it auto incremented.
But when I look at the properties it is not active. I mean I cannot set using…
modest and cute girl
- 785
- 4
- 13
- 24
28
votes
3 answers
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 common configuration and build scripts we're…
Chris Missal
- 5,987
- 3
- 28
- 46
27
votes
10 answers
SQL Server after update trigger
I have a problem with this trigger. I would like it to update the requested information
only to the row in question (the one I just updated) and not the entire table.
CREATE TRIGGER [dbo].[after_update]
ON [dbo].[MYTABLE]
AFTER UPDATE
…
user3927897
- 611
- 3
- 10
- 20
27
votes
2 answers
Create a table without columns
Can I create a table without any columns in SQL Server by t-sql?
loviji
- 12,620
- 17
- 63
- 94
27
votes
5 answers
Why can't I connect to a SQL Server 2012 LocalDB shared instance?
I'm trying to set up a SQL Server 2012 LocalDB (RTM, x64) shared instance on my Windows 7 x64 machine and I can't seem to connect to the shared instance. I'm using an Administrator command prompt for all of the setup. Here's how I'm creating the…
Cory McCarty
- 1,375
- 4
- 15
- 23
26
votes
7 answers
Backup failed for Server, The media is formatted to support 2 media families Error
Can any body tel me how to overcome this error when taking a backup in SQL Server 2008 Express?
Backup failed for Server '\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)
For help, click:…
CAD
- 4,112
- 6
- 29
- 47
26
votes
1 answer
Express with Advanced Services, can't create Full Text Index
I have installed SQL Server 2012 Express Edition Advanced Services which states that it includes Full-text indexing. Here is a link that states this:
http://msdn.microsoft.com/en-us/library/cc645993.aspx
I have confirmed that Full-text service is…
TreK
- 1,144
- 2
- 13
- 25
25
votes
11 answers
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 insert query but this is probably less efficient
SQL…
Thomas Bratt
- 48,038
- 36
- 121
- 139
25
votes
9 answers
How do I connect to a SQL database from C#?
I am trying to write a local program management and install system for my home network, and I think I've got the technologies nailed down:
C#/.NET/WPF for the client
Lua for installation scripting support (through LuaInterface)
SQL Server Express…
RCIX
- 38,647
- 50
- 150
- 207
24
votes
4 answers
Create/restore database from backup SQL Server Express
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 machine.
How can I restore this back up on a database…
Shahin
- 12,543
- 39
- 127
- 205
24
votes
7 answers
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?
hawbsl
- 15,313
- 25
- 73
- 114
24
votes
4 answers
SQL Server: enable remote connections without SSMS
I've got a SQL Server Express 2008 install on my web server, which by default does not allow remote connections (probably a good thing.) I opted not to install SQL Server Management Studio Express along with it for disk space and other reasons.
I…
James Orr
- 5,005
- 7
- 39
- 63
24
votes
5 answers
How do I connect to an older sql database using LocalDb in VS 2012?
I am trying to construct a connection string to a 2008 SQL Express database file in VS 2012. I am getting an error dialog:
This database file is not compatible with the current instance of SQL
Server. To resolve this issue, you must upgrade the…
ATL_DEV
- 9,256
- 11
- 60
- 102
23
votes
9 answers
"Cannot open user default database. Login failed." after installing SQL Server Management Studio Express
I have a database in a local file that is used by a program. The program has limited functionality and I needed to run some quick queries. I installed SQL Server Management Studio Express 2005 (SSMSE), connected to the SQL Server instance,…
Hand-E-Food
- 12,368
- 8
- 45
- 80