Stack Overflow
Stack Overflow

Questions tagged [sql-server-2012-express]

Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

The Microsoft® SQL Server® Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications. Designed for easy deployment and rapid prototyping, this download includes support for Sysprep, Microsoft's System Preparation Utility for Microsoft Windows operating system deployment.

Source: Microsoft (SQL Server 2012 Express)

401 questions
409
votes
17 answers

Enable remote connections for SQL Server Express 2012

I just installed SQL Server Express 2012 on my home server. I'm trying to connect to it from Visual Studio 2012 from my desktop PC, and repeatedly getting the well-known error: A network-related or instance-specific error occurred while…
Ryan Lundy
  • 204,559
  • 37
  • 180
  • 211
140
votes
2 answers

What is the difference between SQL Server 2012 Express versions?

I've come across this page http://www.microsoft.com/en-us/download/details.aspx?id=29062 and I am a bit confused about the different versions here. So I would like to know what is the difference between…
Rushino
  • 9,415
  • 16
  • 53
  • 93
120
votes
14 answers

Can't connect to localhost on SQL Server Express 2012 / 2016

I just downloaded the latest version of SQL Express 2012 but I cannot connect to localhost. I tried localhost\SQLExpress and Windows authentication but it gives me an error message saying cannot connect. Am I missing something here? I've used SQL…
dido
  • 3,347
  • 11
  • 34
  • 42
67
votes
3 answers

sql server restoring back up error

I have backed up a database I had created on an other machine running SQL server 2012 express edition and I wanted to restore it on my machine, which is running the same. I have ticked the checkbox overwriting existing one, and got this…
danarj
  • 1,798
  • 7
  • 26
  • 54
36
votes
3 answers

Get .sql file from SQL Server 2012 database

I need to get .sql files from an existing database with SQL Server 2012. Is this possible because all I see in the export option is delimited files. Ex.) I have table1 with 30 records. I need a file that would be something like what is below. (I…
Andrew
  • 2,013
  • 1
  • 23
  • 38
27
votes
6 answers

How do I change "Database default locations" for LocalDB in SQL Server Management Studio?

Connect to LocalDB in SSMS Open Server Properties -> Database Settings Change Data/Log/Backup locations -> click OK When I click OK I get this error: Found some blogpost and changed this in regedit but it didn't help. Anyone got any other ideas…
PussInBoots
  • 11,028
  • 9
  • 52
  • 84
27
votes
5 answers

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 all of the setup. Here's how I'm creating the…
Cory McCarty
  • 1,375
  • 4
  • 15
  • 23
19
votes
1 answer

CONTAINMENT is marked as incorrect syntax on auto-generated database script

I'm using Windows 7 (x64) and I have an auto generated script for creating a SQL Server Express 2012 database. The script starts as follows: USE [master] GO CREATE DATABASE [Example] CONTAINMENT = NONE ON PRIMARY ( NAME = N'Example', FILENAME…
Pimenta
  • 1,029
  • 2
  • 13
  • 32
18
votes
2 answers

Wait on the Database Engine recovery handle failed!! SQL Server 2012 installation

Can someone please guide me on how to overcome the following error. I am trying to install SQL Server 2012 Express on my win7 32bit system. I had SQL Server 2008 R2 32 bit installed in this system, which was removed by the previous user (this is an…
Youbaraj Sharma
  • 1,295
  • 3
  • 17
  • 34
18
votes
3 answers

Full text search does not work if stop word is included even though stop word list is empty

I would like to be able to search every word so I have cleared the stop word list. Than I have rebuilt the index. But unfortunately if I type in a search expression with stop word in it it still returns no row. If I leave out just the stop word I do…
apolka
  • 1,711
  • 4
  • 16
  • 23
16
votes
1 answer

How to prevent 'query timeout expired'? (SQLNCLI11 error '80040e31')

I have a connection to a MS SQL Server 2012 database in classic ASP (VBScript). This is my connection string: Provider=SQL Server Native Client 11.0;Server=localhost; Database=databank;Uid=myuser;Pwd=mypassword; When I execute this SQL…
user3435078
  • 329
  • 1
  • 2
  • 10
14
votes
4 answers

Deleting a large number of records takes a VERY long time

I have a database table (running on SQL Server 2012 Express) that contains ~ 60,000 rows. I am using the following code to purge old rows: //Deleting CPU measurements older than (oldestAllowedTime) var allCpuMeasurementsQuery = from curr in…
OSH
  • 2,847
  • 3
  • 25
  • 46
13
votes
3 answers

sql server 2012: cannot alter the login sa

I'm trying to create a database on my local machine using SSMS version 11.0.2100.60. I've run the application as administrator, logged in using Windows authentication, and I've added MYDOMAIN\my-username to the Logins. However if I try to create a…
tdc
  • 8,219
  • 11
  • 41
  • 63
13
votes
1 answer

"Invalid column name" error when calling insert after table created

I'm developing SQL script, using SSMS, which makes some changes in database: USE MyDatabase; BEGIN TRANSACTION; -- some statements PRINT(N'#1'); IF (EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = N'dbo' AND TABLE_NAME =…
Dennis
  • 37,026
  • 10
  • 82
  • 150
13
votes
3 answers

SQL Server 2012 sequence

I create a table and sequence in order to replace identity in the table I use SQL Server 2012 Express but I get this error while I tried to insert data to the table Msg 11719, Level 15, State 1, Line 2 NEXT VALUE FOR function is not allowed in…
danarj
  • 1,798
  • 7
  • 26
  • 54
1
2 3
…
26 27