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
253
votes
21 answers
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 which assumes I'm already connected to a particular…
Luke
- 18,585
- 24
- 87
- 110
182
votes
19 answers
ASP.NET 4.5 has not been registered on the Web server
In my Win 7 development machine, and in order to use SQL Express instance instead of the localDB installed by default. I unchecked "Use IIS Express" in my MVC 4 project properties page (Web tab), then I got the following error:
ASP.NET 4.5 has not…
Sami-L
- 5,553
- 18
- 59
- 87
121
votes
6 answers
SQL Server® 2016, 2017 and 2019 Express full download
All previous version of SQL Server Express were available in both web and full downloads. But I cannot find full download of SQL Server® 2016 Express. Does it exist?
Asked the same question on MSDN forums, not much luck:…
Alex I
- 2,078
- 3
- 18
- 24
73
votes
27 answers
CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105)
I have a database file .mdf from MS SQL EXPRESS in folder:
C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA
I would like to attach it to MS 2008 R2 (MSSQL10_50.MSSQLSERVER) but using Server Management Studio I receive the…
GibboK
- 71,848
- 143
- 435
- 658
64
votes
6 answers
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 (should-have) I'd like to keep only the last X backups (for…
edosoft
- 17,121
- 25
- 77
- 111
61
votes
11 answers
LocalDB: How do you delete it?
Setup: Entity framework code first to new database.
Scenario: I'm playing around with EF and I add a bunch of elements to my database. I then change the entity model, and while I know that I could do migrations, I just want to start from scratch and…
Gabriel G. Roy
- 2,552
- 2
- 27
- 39
56
votes
2 answers
pyodbc insert into sql
I use a MS SQL express db. I can connect and fetch data. But inserting data does not work:
cursor.execute("insert into [mydb].[dbo].[ConvertToolLog] ([Message]) values('test')")
I get no error but nothing is inserted into the table.
Directly after…
daniel
- 34,281
- 39
- 104
- 158
55
votes
9 answers
How can I do a BEFORE UPDATED trigger with sql server?
I'm using Sqlserver express and I can't do before updated trigger. There's a other way to do that?
Bigballs
- 3,729
- 10
- 30
- 27
55
votes
13 answers
copy a database within SQL Server Express?
I would like to make a copy of a database I have but keep it on the same server as a test database. However, everything I have found is to use the copy database wizard (I am using MS SQL Server Express).
The instructions always say: In SQL Server…
Jenn
- 551
- 1
- 4
- 3
52
votes
2 answers
LocalDB deployment on client PC
I am very intrigued by this new version of SQL Server Express.
It's not clear (to me) what a setup program should do to deploy an application that use a LocalDB.
Is it required to install SQL Server Express on the client PC and then attach the…
Steve
- 213,761
- 22
- 232
- 286
50
votes
7 answers
SQL Express connection string: mdf file location relative to application location
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.config rather than having my connection string defined…
Adam Jenkin
- 4,142
- 6
- 25
- 31
46
votes
3 answers
Making a DateTime field in a database automatic?
I'm putting together a simple test database to learn MVC with. I want to add a DateTime field to show when the record was CREATED.
ID = int
Name = Char
DateCreated = (dateTime, DateTime2..?)
I have a feeling that this type of DateTime capture can…
RocketGoal
- 1,485
- 8
- 28
- 34
45
votes
3 answers
ASP.NET Web Api: Project requires SQL Server Express
I created a Web API project under VS 2010.
After I switched to VS 2012, I always get a warning:
The Web project 'xxx' requires SQL Server Express, whcih is not
installed on this computer. [...]
I do not want to install this SQL Server Express. I…
user437899
- 8,879
- 13
- 51
- 71
44
votes
5 answers
SQL Express for production?
Is using SQL Express in a production environment a reasonable choice?
I looked at Microsoft's comparison chart:
https://www.microsoft.com/en-us/sql-server/sql-server-2019-comparison
I would be using SQL Express with a small to mid-sized web site. I…
Gabe Sumner
- 4,978
- 6
- 33
- 43
43
votes
11 answers
How do I fix a "Performance counter registry hive consistency" when installing SQL Server R2 Express?
I'm trying to install SQL Server 2008 R2 Express from this site:
http://www.microsoft.com/express/database/
I have a 64-bit, Windows 7 machine.
I have tried both the 32-bit and 64-bit versions but each fail on "Performance counter registry hive…
Edward Tanguay
- 189,012
- 314
- 712
- 1,047