Stack Overflow
Stack Overflow

Questions tagged [sql-server-2014]

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

SQL Server 2014 (codename Hekaton, version 12.00), released in April 2014, is the successor to SQL Server 2012 and the predecessor of the newer version of Microsoft's SQL Server database engine SQLServer 2016.

This tag covers questions specific to the 2014 version of the database engine. It is recommended that the tag is also used when tagging questions with this version specific tag.

Read more about SQL Server 2014 from MSDN.
Get SQL Server 2014 from here.

4735 questions
15
votes
3 answers

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 and try to connect to the Server (local) i obtain the following error: Does any of you had similar problems? Before…
Tiago Neto
  • 379
  • 1
  • 3
  • 15
15
votes
1 answer

SSIS Stored Procedure uses Temp Table 2008 and 2014

I'm currently writing an SSIS package that retrieves data from a stored procedure via an OLE DB Source. The stored procedure contains a rather nasty query that I've been able to improve with the use of temp tables. If I switch these temp tables to…
Nelson O
  • 263
  • 2
  • 8
14
votes
9 answers

Merging duplicated records together with "Merge" syntax

I am using SQL Server 2014. I am currently trying to combine millions of personnel application records in to a single personnel record. The records contain the following columns: ID, First_Name, Last_Name, DOB, Post_Code, Mobile, Email A person…
PJD
  • 743
  • 2
  • 12
  • 38
14
votes
3 answers

SQL index for date range query

For a few days, I've been struggling with improving the performance of my database and there are some issues that I'm still kind a confused about regarding indexing in a SQL Server database. I'll try to be as informative as I can. My database…
Ben
  • 793
  • 2
  • 13
  • 29
14
votes
5 answers

Cannot be opened because it is version 852. this server supports version 782 and earlier

I am using Visual Studio 2017 and SQL Server 2014. While attaching a database file to Visual Studio, I get this error: "" After upgrading the file I used this connection string
Bilal Ahmed
  • 185
  • 1
  • 3
  • 12
14
votes
4 answers

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 ASCII characters. I wrote this horrible function to remove non-printable ASCII characters as a quick fix. I want to…
Munir
  • 3,442
  • 3
  • 19
  • 29
14
votes
4 answers

Import database (SQL file) in SQL Server Management Studio

I've created the structure of my database first in PhpMyAdmin and exported it to a .sql file. Now I'm looking everywhere in SQL Server Management Studio where I can import/add the data in a new database. Does anybody where to look or what to…
Matt
  • 1,893
  • 11
  • 33
  • 57
13
votes
3 answers

The database cannot be opened because it is version 851. This server supports version 782 and earlier. A downgrade path is not supported

I am trying to attach database file in SQL Server. I am getting the below error. The same error I am getting while trying to attach database from Visual Studio. I am using Visual Studio 2013 and SQL Server 2014 Management Studio. My connection…
Musakkhir Sayyed
  • 7,012
  • 13
  • 42
  • 65
13
votes
10 answers

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 the error as do not have permission or does not exits We have given to same permissions and even he is a system admin.In our…
surya teja
  • 143
  • 1
  • 2
  • 9
13
votes
7 answers

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 on Windows 10, and after if I turn on my PC everything is OK. But if I restart the system, after the restart,…
alex
  • 694
  • 3
  • 15
  • 35
13
votes
4 answers

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 Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA' Operating…
Jason Clark
  • 1,307
  • 6
  • 26
  • 51
13
votes
3 answers

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 this problem so I don't know if its a bug in SSRS 2014. I have a stored procedure that returns some data, something as…
JonH
  • 32,732
  • 12
  • 87
  • 145
13
votes
4 answers

Convert SQL Server Date to mm-yyyy

I'm trying to convert my Date which is (eg. 2012-04-20 05:54:59) format in into mm-yyyy. I came across some solutions that says you would need to convert into varchar . Is there any way using the Convert function ? Thanks :)
Prateek Daniels
  • 451
  • 1
  • 4
  • 19
12
votes
3 answers

Incorrect syntax near OFFSET command

Why this doesn't work and gives me a "Incorrect syntax near offset command" error SELECT o.orderdate, o.orderid, o.empid, o.custid FROM Sales.Orders o ORDER BY o.orderdate, o.orderid OFFSET 50 ROWS FETCH NEXT 25 ROWS ONLY; I am using SQL Server…
Bohn
  • 26,091
  • 61
  • 167
  • 254
12
votes
9 answers

SQL Server Data Tools 2015 installation error

I'm trying to install SQL Server Data Tools - Visual Studio 2015, but I keep getting an "Unspecified error". The log file is at https://drive.google.com/open?id=0B3CEKzS2Sw8OODNJOXZJVGRWQlU. I already have Visual Studio Professional 2015…
J. McCarthy
  • 121
  • 1
  • 2
  • 5
1 2
3
…
99 100