Questions tagged [sql-server-express]
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.
sql-server-express
1,732
questions
263
votes
21
answers
727k
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 ...
- 18.9k
182
votes
19
answers
303k
views
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 ...
- 5,633
123
votes
5
answers
594k
views
SQL Server® 2016, 2017, 2019 and 2022 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 ...
- 2,178
75
votes
27
answers
173k
views
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 ...
- 73.3k
65
votes
11
answers
55k
views
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 ...
- 2,602
65
votes
6
answers
270k
views
How can I schedule a daily backup with SQL Server Express? [duplicate]
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-...
- 17.2k
58
votes
2
answers
171k
views
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 ...
- 35.2k
57
votes
13
answers
103k
views
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 ...
- 571
57
votes
9
answers
183k
views
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?
- 3,799
52
votes
2
answers
50k
views
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 ...
- 216k
50
votes
7
answers
72k
views
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 ...
- 4,192
48
votes
3
answers
152k
views
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 ...
- 1,513
47
votes
3
answers
31k
views
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. [...]
...
- 9,079
46
votes
1
answer
29k
views
SQL Server Express vs express localdb
I am having quite a few problems understanding differences between regular SQL Server Express and express Localdb.
Before you go ahead and tag a previous post about this question, I've went through ...
- 463
44
votes
5
answers
30k
views
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 ...
- 4,988
43
votes
11
answers
135k
views
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 ...
- 192k
41
votes
2
answers
121k
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, ...
- 35.5k
40
votes
17
answers
17k
views
Azure Storage Emulator fails to init with "The database 'AzureStorageEmulatorDb57' does not exist"
I am having an issue with Azure Storage Emulator. I tried to re-initialise the database and got the error below.
This was after installing Visual Studio 2019 Preview but this may just be a co-...
- 13.5k
40
votes
1
answer
80k
views
SQL Server 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 Server CE but I am unable to find a connection string to work ...
- 6,361
39
votes
8
answers
375k
views
SQL Insert Query Using C#
I'm having an issue at the moment which I am trying to fix. I just tried to access a database and insert some values with the help of C#
The things I tried (worked)
String query = "INSERT INTO dbo....
- 777
38
votes
4
answers
85k
views
SqlServer 08: Query to list all databases in an instance?
How do I list all the databases for a given sql server 08 instance using sqlcmd?
- 76.7k
35
votes
6
answers
133k
views
Default instance name of SQL Server Express
I don't have access to a SQL Server Express installation at the moment, but I know that the installer usually installs SQL Server Express with an instance name. What is the default instance name for ...
- 2,287
34
votes
4
answers
89k
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 ...
- 1,223
34
votes
3
answers
34k
views
Can SQL Server Express LocalDB be connected to remotely?
I am looking into using the new SQL Server Express LocalDB (I think it is code named "Denali") for a desktop application.
It is currently running with SQL Compact, but the user is wanting to share ...
- 6,778
33
votes
8
answers
133k
views
Connecting to SQL Server Express - What is my server name?
I was just given a laptop to perform some development from a client and I am currently in the process of setting it up. Visual Studio 2010 is installed as well as SQL Server Management Studio 2008 R2....
- 8,535
33
votes
5
answers
35k
views
Is there a SQL Server Profiler for SQL Server Express? [closed]
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?
- 21k
33
votes
16
answers
170k
views
Delete rows from multiple tables using a single query (SQL Express 2005) with a WHERE condition
This is the query I'm using:
DELETE TB1.*, TB2.*
FROM TB1
INNER JOIN TB2 ON TB1.PersonID = TB2.PersonID
WHERE (TB1.PersonID)='2'
It's working fine in MS Access but getting error (...
- 1,122
31
votes
6
answers
15k
views
SQL LocalDB vs SQL Server CE
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 ...
- 3,948
31
votes
8
answers
193k
views
How do I view executed queries within SQL Server Management Studio?
I am new to SQL Server Management Studio and am wondering: is there is a way to see which queries have been run against a database?
In the Activity monitor, there is a "Recent Expensive Queries" ...
- 3,208
30
votes
12
answers
162k
views
SQL Server Express CREATE DATABASE permission denied in database 'master'
After I change the option as UserInstance="False", then the error starts to happen.
Because I want to use full-text search, the option change is required. BUT, it stopped to work. Is there any way to ...
- 1,104
29
votes
12
answers
55k
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 ...
- 47.5k
29
votes
7
answers
87k
views
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: http://go....
- 4,222
29
votes
2
answers
99k
views
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 ...
29
votes
2
answers
32k
views
Create a table without columns
Can I create a table without any columns in SQL Server by t-sql?
- 12.9k
28
votes
10
answers
96k
views
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 ...
- 39.2k
28
votes
3
answers
17k
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 ...
- 6,075
28
votes
10
answers
276k
views
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].[...
- 621
27
votes
5
answers
32k
views
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 ...
- 1,375
26
votes
1
answer
28k
views
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....
- 1,154
25
votes
9
answers
90k
views
"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 (...
- 12.7k
25
votes
4
answers
33k
views
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 ...
- 5,055
25
votes
11
answers
100k
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 ...
- 50.3k
24
votes
5
answers
29k
views
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
...
- 9,485
24
votes
4
answers
92k
views
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 ...
- 12.7k
24
votes
7
answers
51k
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?
- 15.8k
23
votes
3
answers
25k
views
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 ...
- 26.9k
22
votes
4
answers
56k
views
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 ...
- 9,146
22
votes
1
answer
27k
views
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 ...
- 4,045
21
votes
6
answers
52k
views
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 ...
- 12.5k
21
votes
3
answers
64k
views
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?
- 211