Questions tagged [sql-server-localdb]
SQL Server localdb is an edition of SQL Server Express without server installation. Application developers can use it to distribute a database with their applications without requiring the user to install a SQL Server engine
49
questions
10
votes
3
answers
4k
views
Should developers be allowed to use LocalDB vs a "development" instance?
Much like the vein of the question that was posted here previously around "Should developers be able to query production databases?" I wanted to get your thoughts on another particularly annoying ...
1
vote
2
answers
12k
views
How to programmatically find out where LocalDb is installed
I'm writing a plugin for Cake Build tool where I need to start a LocalDB instance. But this code will be executed on different machines and LocalDB can be installed in different folders depending on ...
0
votes
2
answers
10k
views
SQL Query to select all under certain age using only date of birth [closed]
How can I select all that are under 20 and female from a SQL database?
The table has a datetime for the dob and strings for name, surname, and sex. That is the whole table.
I am having trouble ...
6
votes
2
answers
8k
views
Access SQL Server Express LocalDB from Local Area Network
I am developing a software which requires SQL Server. But for a 50MB application it is not a good idea to tell customers to install SQL Server. So I think it's better to use SQL Server Express LocalDB....
3
votes
2
answers
2k
views
Table with only a single constant value?
I use C# entity framework code first.
My knowledge regarding databases is almost nothing. I don't know if it's common or good practice so I wanted to ask you guys how I should do it.
Say I have a ...
5
votes
2
answers
6k
views
DROP DATABASE statement cannot be used inside a user transaction
Not really sure if this question belongs here, but I hope someone could help me out.
I've made integration tests going all the way down to the database (using mssql localDB). I want each test to run ...
0
votes
1
answer
3k
views
Error importing SQL Azure Bacpac to SQL Server 2014 LocalDb
Downloaded a v12 SQL Azure bacpac, and trying to import it into a SQL Server 2014 LocalDB... I get:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Could not load schema ...
2
votes
5
answers
4k
views
Finding server and instance name
I want to know how to find the server and instance name on my computer to connect to the server.
I am using the SQLCMD utility, and I am currently able to connect to the server with the line
>...
18
votes
1
answer
21k
views
Connect to LocalDB via SQLCMD in PowerShell
I'm trying to access the "localdb\MSSQLLocalDB" server on my computer through PowerShell with the SQLCMD utility. I'm using PowerShell v5, .NET v5.0, and the server name is (localdb)\MSSQLLocalDB when ...
10
votes
1
answer
37k
views
How do I connect to localDB from SQL Server 2014 Express
I downloaded both the LocalDB and Management Studio for MS SQL Server 2014 Express so that I can practice on my local machine. However, when I open Management Studio and try to browse to localDB to ...
3
votes
1
answer
4k
views
Portable client tool to connect to SQL Server Express LocalDB and execute a query
I am running out of ideas on this little problem:
I need to execute a query on a LocalDB database directly on user's computer. I do not want to install anything there and there is only .NET (4.5.2) ...
1
vote
0
answers
63
views
Simple Unpivot - erroneous Column Conflict [duplicate]
Did I stumble across a reserved word here or something?
For, the following statement:
SELECT [Type]
FROM (SELECT 'Receive' AS [Rec], 'Transfer' AS [Trx]) [data]
UNPIVOT
(
[Orders] FOR [Type] IN ...
2
votes
0
answers
859
views
SSDT sqlpackage.exe CreateNewDatabase Parameter Not Respected
Originally asked this on SO but that question seems to be populated only by tumbleweed so wondered if this might be a better forum for it.
I have a VS2103 solution which includes a database project ...
5
votes
2
answers
18k
views
Where is SQLCMD.EXE in SQL Server 2014 LocalDB or how to install it?
On a machine with SQL Server LocalDB 2014 installed I am looking for SQLCMD.EXE file but cannot find it anywhere. Is there a way how to install it separately?
Unfortunately I am not local admin of ...
1
vote
2
answers
3k
views
Change server name for SQLLocalDB instance
Is there any way to change the instance name of LocalDB of SQL Server 2012 from (LocalDB)\xxxx to just xxxx?
I need it for an application that needs SQL Server DB instance name to be MSSQLDEFAULT.