Top "Sql-server-2014" questions

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

SQL Server Error 5120 - failed to attach .mdf file

While attaching my .mdf file on my SQL Server database I am getting below error message: Msg 5120, Level 16, State 101, Line 1 …

sql-server sql-server-2014
How to store longitude & latitude as a geography in sql server 2014?

I have locations in longitude and latitude coordinates. My goal is eventually to be able to select all rows from …

sql sql-server-2014
Why is running a query on SQL Azure so much slower?

I created a trial account on Azure, and I deployed my database from SmarterAsp. When I run a pivot query …

sql azure ssms azure-sql-database sql-server-2014
SQL Server Management Studio can not connect

I have installed SQL Server Management Studio 2014. In "connect to server" window, I selected server type as "Database engine", server …

c# sql sql-server sql-server-2014
How to make JSON from SQL query in MS SQL 2014

Question: What is best solution to generate JSON from a SQL query in MS SQL 2014? I created a procedure, but …

sql json xml tsql sql-server-2014
SSIS: script task (vs15) not work when deploy on sql server 2014

The error: There was an exception while loading Script Task from XML: System.Exception: The Script Task uses version 14.0 script …

ssis visual-studio-2015 sql-server-2014 vsta
SQL Server service doesn't start anymore automatically if I make a Windows restart

I have Windows 10 build 1511, where I have installed SQL Server 2014. After installation everything is OK. I've made several times shutdown …

sql-server-2014
Azure SQL Database vs. MS SQL Server on Dedicated Machine

I'm currently running an instance of MS SQL Server 2014 (12.1.4100.1) on a dedicated machine I rent for $270/month with the following …

sql azure azure-sql-database sql-server-2014
Rounding dates to first day of the month

I am using SQL Server 2014 and I am working with a column from one of my tables, which list arrival …

sql sql-server tsql date sql-server-2014
Database project deploy fails in Visual Studio 2013

I have a database project in a solution which will not deploy from Visual Studio 2013. It fails with an error …

visual-studio-2013 sql-server-data-tools sql-server-2014