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
41
votes
2 answers
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, enabling tcp/ip connections, specifying the ports…
Tono Nam
- 34,064
- 78
- 298
- 470
41
votes
1 answer
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 question history quite a few times.
The resources…
Dan J
- 413
- 1
- 4
- 5
39
votes
17 answers
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-incidence. I tried for an hour or so to get it running…
Murray Foxcroft
- 12,785
- 7
- 58
- 86
39
votes
1 answer
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 with SQL Server Express.
This one, using the SQL…
GilShalit
- 6,175
- 9
- 47
- 68
38
votes
8 answers
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.SMS_PW (id,username,password,email) VALUES ('abc', …
voskart
- 767
- 1
- 7
- 15
37
votes
4 answers
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?
Dane O'Connor
- 75,180
- 37
- 119
- 173
34
votes
4 answers
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 Server browser, also the DTC service)
When I try…
Alon Ashkenazi
- 1,223
- 4
- 21
- 29
34
votes
6 answers
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 SQL Server Express installations? I.e., how do you…
Dennis G.
- 2,277
- 2
- 19
- 25
33
votes
3 answers
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 the database between multiple PCs on a network.…
Mark Whitfeld
- 6,500
- 4
- 36
- 32
33
votes
5 answers
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?
Hannoun Yassir
- 20,583
- 23
- 77
- 112
33
votes
16 answers
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 (Incorrect syntax near ','.) in SQL Server Express…
Jobi
- 1,102
- 5
- 24
- 38
32
votes
8 answers
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. I'm trying to open SQL Server Management…
jdavis
- 8,255
- 14
- 54
- 62
30
votes
6 answers
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 with 2 potential database solutions for my project :…
danbord
- 3,605
- 3
- 33
- 49
30
votes
8 answers
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" report but I'm guessing that isn't all of the queries…
bsh152s
- 3,178
- 6
- 51
- 77
30
votes
12 answers
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 make it work again?
I'm running Application Pool…
San
- 1,104
- 3
- 17
- 31