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
23
votes
3 answers
How do you backup and restore a database as a copy on the same server?
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 the restore is failing...
THE ERROR:
Msg 3234, Level…
RSolberg
- 26,821
- 23
- 116
- 160
22
votes
4 answers
SQL Server Express vs MS Access
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 and maybe under the covers they are similar, but I…
scarpacci
- 8,957
- 16
- 79
- 144
22
votes
1 answer
confusion about SQL Server Express and localdb
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 folder, do I still need to install SQL Server Express…
Costa
- 3,897
- 13
- 48
- 81
21
votes
6 answers
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed
I've attempted to add a "service based data base" (.mdf) to a project in an asp .net application. From there I've proceeded attempted to create an entity framework model file (.edmx).
When doing so I get the error:
An error occurred while…
eran otzap
- 12,293
- 20
- 84
- 139
21
votes
2 answers
How to insert into a table with just one IDENTITY column (SQL Express)
Pretty much the same as this question.
But I can't seem to get this to work with SQL Server Express in Visual Studio 2008.
Same Table layout, One column with identity and primary key.
Thomas Sandberg
- 943
- 2
- 9
- 19
20
votes
8 answers
What profiler to use with sql express?
is there a way to monitor detail of sql calls in express version?
zsharp
- 13,656
- 29
- 86
- 152
20
votes
3 answers
Need to create new database without using management studio
How to create new database with SQL Server Express 2008 without using Management Studio?
Do i need to download sp1?
remo
- 201
- 1
- 2
- 3
19
votes
2 answers
How to add users to SQL Server 2008 Management Studio
I am trying to install DotNetNuke CMS. I created a database in my Microsoft SQL Server Management Studio 2008, which I installed after installing Microsoft Visual Studio 2010. I created a login for it and a password but I am not able to log in.
It…
wandos
- 1,581
- 2
- 20
- 39
19
votes
2 answers
Bootstrapping SQL Express from WiX?
I'm working on a WPF app, and using WiX as an installer.
I'd like to start using SQL Express 2012, but want to resolve installer issues first.
I'm looking for a full-up example of detecting, bootstrapping, installing, upgrading and uninstalling SQL…
RickNZ
- 18,448
- 3
- 51
- 66
18
votes
3 answers
Connection String to Connect to .MDF
I've created a new project in VS2008, and added a .MDF file to the project. This is the first time I've tried to use the MDF files and .SQLEXPRESS databases (I've always used extenal Oracle servers in the past).
I'm trying to document everything as…
kdmurray
- 2,988
- 3
- 32
- 47
18
votes
7 answers
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 655. This server supports version 612 and earlier. A…
sl3dg3
- 5,026
- 12
- 50
- 74
18
votes
6 answers
SQL Server Management Studio - Adding/Moving Columns require drop and re-create?
Why do I get message that the table needs to dropped and re-created when I add/move columns?
I believe this happens after adding foreign key constraints.
What can I do to add new columns without dropping table?
tvr
- 4,455
- 9
- 24
- 29
18
votes
2 answers
In SQL Server Management Studio 2014, the New Trigger menu option is disabled
I want to add a new trigger to my table. As seen in the picture, New Trigger button is not active. new index, new column, new contraints, new statics is active.
I do not understand what is the problem.
pak
- 230
- 1
- 2
- 11
17
votes
2 answers
Run SQL script after start of SQL Server on docker
I have a Dockerfile with below code
FROM microsoft/mssql-server-windows-express
COPY ./create-db.sql .
ENV ACCEPT_EULA=Y
ENV sa_password=##$wo0RD!
CMD sqlcmd -i create-db.sql
and I can create image but when I run container with the image I don't…
Art Base
- 1,739
- 3
- 15
- 23
17
votes
2 answers
How can I create a user in SQL Server Express database I added to my project?
How can I create a SQL user in a SQL Server Express database that I added to my project?
I need to create a user to use in a connection string that doesn't use Integrated Security.
John Egbert
- 5,496
- 8
- 32
- 44