For questions about SQL Server 2012 Express Edition (build 11.0.xxxx)

learn more… | top users | synonyms

3
votes
1answer
73 views

Why does SQL authentication sometimes fail and how can I make it work reliably?

I have SQL Server Express installed locally on a machine and it works most of the time but occasionally it fails to make a connection with this error: Could not obtain information about Windows ...
0
votes
1answer
337 views

Does SQL Server require SSLv3?

We have a Windows 2008 R2 server running SQL 2012 Express RTM (11.0.2100.60). All three protocols (shared memory, named pipes, TCP/IP) are enabled for the server and both 32-bit and 64-bit clients. ...
2
votes
2answers
139 views

Is SQL Server Thread Safe?

If I need to update same row with two concurrent thread then is it possible in SQL Server? Suppose I have one table that contains Id and Name columns and now I want to update the third number Id with ...
1
vote
0answers
252 views

Querying LDAP multi-value attributes using Openquery

I'm using SQL Server 2012 Express to query an LDAP linked server like this: SELECT * FROM OPENQUERY (MYLINKEDSERVER, 'SELECT * FROM ''LDAP://myserver:389/o=root'' where telephonenumber = ...
0
votes
0answers
36 views

Can't execute CreateAll.tt template in SQL Server Express

I have a CreateAll.tt template in a Visual Studio project. All the scripts I try to execute are correct - the template is tested on a different machine with SQL Server 2012 Developer Edition and it ...
0
votes
1answer
71 views

SQL Server 2012 Express SP1 install still not 11.1

I run the SQL Server 2012 Express SP1 install and it succeeds. After I have rebooted my computer, I do a select @@version But still I only have version 11.0.21600.64. I have tried this on two ...
0
votes
2answers
70 views

migrate from sql server 2012 to sql server 2008 R2 [duplicate]

I have been looking for the information since yesterday and could not find anything... I have sharepoint 2012 fundation and my SQL Server 2010 Evaluation is short of space (we already used 10GB), ...
0
votes
2answers
67 views

Inserting data into a second table with some time lag

I am new to SQL Server. I am using Management studio 2012 Express edition. What I want to do is that suppose I have table1 and table2 and suppose someone enters some data into table1, then after some ...
6
votes
2answers
12k views

Installing SQL Server 2012 Express fails with error “ Could not find the Database Engine startup handle.”

I'm attempting to install SQL Server Express 2012 w/ SP1 x64 on Windows 7 SP1 x64. This machine has previously had SQL Server Express 2012 installed. This instance was upgraded to SQL Server 2012 ...
0
votes
2answers
170 views

Recommendations for a SQL Server 2014 Database Administrators Course [closed]

I am after some personal recommendations for a SQL Server 2012 Database Administrators Course with exams. Exam 70-461: Querying Microsoft SQL Server 2014 Exam 70-462: Administering Microsoft SQL ...
0
votes
1answer
483 views

Installation SQL Server 2012 - “Ready to Install” page missing

I need to create config file, so I could install sql server from cmd. I need basic server installation so I've downloaded SQLEXPR32_x86_ENU I need to go through whole installation process til page ...
1
vote
3answers
294 views

Trouble with SQL Server authentication in SQL Server 2012

I am working with a SQL Server 2012 database. I am able to log into the server using Windows authentication. Although I have the SQL Server authentication username and password which is provided to me ...
4
votes
1answer
192 views

Why clustered index scan?

I just started to learn to optimize my queries and to analyze their query plans. I thought this query would generate nonclustered index seek + key lookup. SELECT ct.* FROM Person.ContactType AS ct ...
0
votes
1answer
1k views

SQL Server 2012 Express : How do you limit a database's size and retention policy?

I don't work with databases very often and I want to make sure I am going about this the right way. I want to configure a database's file size to not exceed 9 gigs. At the point the database reaches ...
0
votes
1answer
95 views

Select Into with typed alias column

I'm using SQL Server 2012 Express and I'm trying to run a command to create a new table from another I'd like to do something like this SELECT [RowID], [Account], [Broker], [AlgorithmName], ...
0
votes
1answer
327 views

Error deleting SQL Server local database

I'm doing a project in Visual Studio 2012 and it involves working with the given database. As I add the database.mdf to the project (asp.data folder) I got a connection error, but nothing out of the ...
2
votes
2answers
7k views

SQL Server 2012 Express with Reporting Services

Everywhere I search for SQL Server 2012 Express with Advanced Services, I ended up with this link, http://www.microsoft.com/en-us/download/details.aspx?id=35579, and every time I install it, I do not ...
-1
votes
0answers
4k views

Errors trying to install SQL Server 2012 on Windows 7 [closed]

I am getting the above error message when i try to run the setup file. Microsoft SQL Server 2012 Service Pack 1 Setup The operating system on this computer does not meet the minimum ...
0
votes
0answers
740 views

SQL Server 2012 - The application has failed to start because its side-biy-side configuration is incorrect

When opening Sql Server Management Studio I'm getting the following error message: Then when I have a look at the Event Viewer the following message is displayed related to this: Activation ...
8
votes
5answers
5k views

Freeing Unused Space SQL Server Table

I have a table in SQL Server Express with a lot of unused space. I need to free up space in the database. | NAME | ROWS | RESERVED | DATA | INDEX_SIZE | UNUSED | ...
0
votes
2answers
168 views

Lot of log files in $FSLOG generating. How to stop?

I'm using SQL Server 2012 Express Edition and I have a problem with huge amount of files generated in: C:\Program Files\Microsoft SQL ...
0
votes
3answers
4k views

Cant see SQL Server Agent in SSMS [duplicate]

I have SSMS 2012 installed on my laptop, and SQL Server 2012 on my hosting, but when i try to schedule a sql job i didn't find "SQL Server Agent" in the left side list!!?
3
votes
2answers
4k views

Restore of database failed [duplicate]

I wanna restore my database and i use sql server 2012 express edition but when i restore my backup file in sql server management studio, i take this error: System.Data.SqlClient.SqlError: There is ...
1
vote
1answer
3k views

SQL Server 2012 Express fails at repair install, produces error 5178

My SQL Server Express Service will not start up. To produce this problem, I basically cloned my old hard drive (Which had SQL Server Express 2012 installed) to a new hard drive (Seagate Momentus XT ...
1
vote
0answers
422 views

Configured values different to Running values, even after full restart

I am trying to change the FILESTREAM Access Level property on a SQL Server Express database. The Configured values section of the Advanced tab of my Server Properties dialogue box looks like so: ...
1
vote
1answer
117 views

How can I achieve a unique constraint with two fields? [duplicate]

I have a table with e.g. Name and IsDeleted fields. I want to add a row constraint so that only one Name value can have IsDeleted as 'false'. There can be many duplicate Name values, but they must all ...
4
votes
0answers
1k views

SQL Server Browser uses NT AUTHORITY\SYSTEM account and logon failure error in SQL Log [closed]

Using SQL Server 2012 on Windows 2008 R2 I have been getting errors in SQL Logs for failed login for NT AUTHORITY\SYSTEM. All of SQL Server's services are running under their own Domain accounts, ...
1
vote
3answers
3k views

SQLCMD command is not able to insert accents

I am trying to run sqlcmd.exe in order to setup a new database from command line. I am using SQL SERVER Express 2012 on Windows 7 64 bits. Here's the command I use: SQLCMD -S .\MSSQLSERVER08 -V 17 ...
2
votes
1answer
3k views

SQL Server uses only 1 CPU of 4 available

I've two machines with SQL Server 2012 Express SP1 with default configuration settings for CPU usage. I'm using this query on my work machine: SELECT cpu_count FROM sys.dm_os_sys_info It returns ...
0
votes
1answer
283 views

SQL Server Express on Windows 8 isn't locking MDF database files

Historically, if I go to rename a database that is currently being used by SQL Server, I get an exception. On this Windows 8 desktop I'm in.. my primary desktop.. I'm able to MOVE SQL Server ...
12
votes
1answer
7k views

Why does SQL Server 2012 Express use 9.5GB of RAM on my server?

I am building an application in which I plan to embed SQL Server 2012 Express as the primary datastore. When testing on my development machine (Win7-32 with 3GB RAM), I never observed the ...
0
votes
1answer
171 views

Unable to open .sps.bak database backup file with SQL Server 2012 Express edition

I am using SQL Server 2012 Express edition. Client sent me the SQL Server backup file with the extension .sps.bak. I am not able to open it with SSMS. Please somebody help me here. I get the ...
3
votes
4answers
21k views

SQL Server CREATE FILE encountered operating system error 5 (Access is denied.)

I'm trying to execute the following script in SQL Server Management Studio but I'm getting the error: Msg 5123, Level 16, State 1, Line 2 CREATE FILE encountered operating system error 5 ...
4
votes
3answers
6k views

SQL Server Management Studio Express 2012 “ONLY”

I have installed SQL Server Express(SSMS) 2012 with management tools. After a few months, the Management studio has stopped working. The error is: «« Evaluation period has expired. For more on how ...
2
votes
1answer
2k views

How does performance of SQL Server CE and SQL Server Express compare?

We have an application that runs on netbooks. It currently uses a SQL Server CE 3.5 database, and we are thinking of upgrading to SQL Server Express. Just wonder if there are any benchmarks to ...