The sql-server-2012-express tag has no wiki summary.
8
votes
1answer
842 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 ...
4
votes
3answers
1k 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 ...
3
votes
0answers
62 views
SQL Server Browser uses NT AUTHORITY\SYSTEM account and logon failure error in SQL Log
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, ...
2
votes
1answer
111 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 ...
2
votes
4answers
3k 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 ...
1
vote
2answers
135 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 ...
1
vote
1answer
699 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 ...
0
votes
1answer
165 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 ...
0
votes
1answer
106 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 ...
