Top "Sql-server-2012" questions

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

how do I fix SqlException Time-out occurred while waiting for buffer latch type 2 for page (1:37660679), database ID 10

I was running an application for a few hours and then suddenly: SqlException was unhandled by user code: Time-out occurred …

c# asp.net sql-server-2012 sqlexception
Using OPENQUERY (exec stored procedure) to create new temporary table fails with error 11526

I have SQL Server 2012 full version installed on my development PC. I am trying to follow the examples here, which …

metadata sql-server-2012 openquery
Can't create stored procedure with table output parameter

I have this code: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetProfitDeals]') AND …

sql sql-server sql-server-2012 sql-server-2012-express
SQL Server 2012 DataTools + Visual Studio 2012 = An incompatible DacFx version is installed

I'm going crazy, trying to use SSDT in Visual Studio 2012. I created a database but I can't add tables etc. …

visual-studio-2012 sql-server-2012 sql-server-2012-datatools
Count Number of Consecutive Occurrence of values in Table

I have below table create table #t (Id int, Name char) insert into #t values (1, 'A'), (2, 'A'), (3, 'B'), (4, 'B'), (5, 'B'), (6, …

sql sql-server tsql sql-server-2012 aggregation
Why is "close existing connections to destination database" grayed out on SQL Server 2012 Management Studio?

I am normally using SQL Server 2012 Management Studio to restore a SQL Server database from a "bak" file. I do …

sql-server database sql-server-2012 ssms database-restore
cannot show Visual Studio Tools for Application editor in SSIS 2012

When I click on EDIT SCRIPT button for Script Task in SSIS 2012 package, It does not open the Script editor …

ssis sql-server-2012 vsta
SQL Server 2012 PIVOT without aggregate

I have the following sample data: Id Name Category ----------------------- 1 Joe A 2 Joe B 3 Joe D 4 Mary A 5 Mary C 6 …

sql-server tsql pivot sql-server-2012
Pass List as Sql Table Type Parameter

I'm trying to pass the list of my class as DbParameter. Probably the table type is defined in my stored …

c# wpf sql-server-2012 generic-list