Top "Sql-server-2012" questions

Use this tag for questions specific to the 2012 version of Microsoft's SQL Server.

The server principal is not able to access the database under the current security context in SQL Server MS 2012

I am trying to access my hosting server’s database through SQL Server Management Studio, everything till login is fine …

sql-server sql-server-2012
No process is on the other end of the pipe (SQL Server 2012)

I've got this error: A connection was successfully established with the server, but then an error occurred during the login …

sql-server sql-server-2012
Last executed queries for a specific database

I know how to get the last executed queries using the following SQL in SSMS - SELECT deqs.last_execution_…

sql-server sql-server-2012
Sql server - log is full due to ACTIVE_TRANSACTION

I have a very large database (50+ GB). In order to free space in my hard drive, I tried deleting old …

sql sql-server sql-server-2012
Conversion failed when converting from a character string to uniqueidentifier - Two GUIDs

I don't understand why I can't insert this. I can't spot the problem. The error message is Conversion failed when …

sql-server sql-server-2012
How to subtract 30 days from the current date using SQL Server

I am unable subtract 30 days from the current date and I am a newbie to SQL Server. This is the …

sql sql-server sql-server-2008 sql-server-2012
What is the connection string for localdb for version 11

I'm trying to do the Code First Walkthrough of the entity framework ( http://blogs.msdn.com/b/adonet/archive/2011/09/28/ef-4…

c# sql-server connection-string sql-server-2012 localdb
How to enable bulk permission in SQL Server

I am trying to insert images using "bulk" into SQL Server 2012. But, am ending up with the error message stating …

sql-server sql-server-2012
How can I tell if a VARCHAR variable contains a substring?

I thought it was CONTAINS, but that's not working for me. I'm looking to do this: IF CONTAINS(@stringVar, 'thisstring') ... …

sql string contains sql-server-2012