Top "Sql-server-2014" questions

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

SQL RESTORE WITH RECOVERY; Hangs at 100%

I have done a lot of research about this. I am attempting to recover a database with SQL Server 2014 and …

sql-server restore sql-server-2014
Publish DACPAC to SQL Server 2014 using SqlPackage.exe?

I've been successfully publishing DACPACs to SQL Server 2008-2012 instances using SqlPackage.exe, as installed by SQL Server Data Tools (…

sql-server-2014 sql-server-data-tools sqlpackage
SQL Server - Remove all non-printable ASCII characters

We recently migrated from SQL Server 2012 to SQL Server 2014 and all our FOR XML code started throwing errors about non-printable …

sql-server sql-server-2014
Sql Server 2014 - Update to windows 10 and can't connect to the Local Server

Recently I updated my Windows from 8 to 10 and suddenly my SQL Server 2014 stopped working. When I open the Management Studio …

sql-server server sql-server-2014
cannot drop the view 'XXX' because it does not exist or you do not have permission

We migrated our servers from 2005 to 2014, User is able to delete it in the 2005 server But in 2014 we are getting …

sql-server sql-server-2005 sql-server-2014 user-permissions
An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown."

I have one table(Sql server 2014) with 60 million data. while fetching the data i am getting "An error occurred while …

sql-server sql-server-2014
LocalDB SQL Server 2014 Express creates 2 instances (localdb)\ProjectsV12 & (localdb)\MSSQLLocalDB?

I'm using SQL Server 2014 Express and the LocalDB option, and I have the following in my SQL Server object explorer …

visual-studio-2013 localdb sql-server-2014
SSRS Not sorting correctly

I'm tapping into a SQL Server 2014 database using SSRS 2014. I've used SSRS from its initial release but have never experienced …

sql-server sorting reporting-services sql-server-2014
SQL Server 2008 R2 Upgrade / Server Move to SQL Server 2014

I have a new server and want to install SQL Server 2014 Standard and migrate my database across from my old …

sql-server sql-server-2008 sql-server-2014 sql-server-administration
Update and Insert When Condition is Matched in TSQL-Merge

I have been trying to Write a Stored Procedure where i can perform UpSert using Merge with the Following Condition …

sql-server stored-procedures sql-server-2014 sql-merge