Questions tagged [sql-server]

Questions related to Microsoft SQL Server. If your question is version specific please tag it specifically for that version as well. Does your SQL Server question belong here or on another site? Click the about the SQL Server tag link on the line below.

The tag is for general questions related to Microsoft SQL Server and its various technologies. SQL Server is a very broad topic, much of which is perfectly suited for serverfault. SQL Server programming questions involving code, however, will be generally be better suited for stackoverflow.

If you have a SQL Server question, ask yourself the following questions to determine the best site:

  • Is the goal of my question to solve a SQL Server system administration (DBA) function? If not, then it's a good bet you should head on over to stackoverflow https://stackoverflow.com/ or superuser https://superuser.com/

  • Who would use the code that my question relates to the most, a developer or a DBA? If a developer, stackoverflow is your place. If a DBA, ask away here.

For information on how to handle installation errors related to the system language versus the installation media language, see SQL Server setup media does not support the language.

4775 questions
25
votes
2 answers

Setting Trace Flags "Permanently" in SQL Server?

We need to use SQL Server Trace Flag 7646 to help mitigate some full text blocking, but I was dismayed to find that the trace flag "unset" itself, probably when the database server was rebooted. I've used DBCC TRACEON (7646, -1) to set the trace…
Jeff Atwood
  • 13,104
  • 20
  • 75
  • 92
25
votes
4 answers

Install SQL CLR types & Report Viewer 2012 on Sql 2008 server

I'm in the process of installing a client's ASP.net site on a Windows Server 2003 box running Sql 2008. The site uses Report Viewer 2012, but when I attempted to install it on the server, I got the message "CLR Types for Sql Server 2012" were…
Ted
  • 353
  • 1
  • 3
  • 8
25
votes
3 answers

"The wait operation timed out" when running SQL Server in Hyper-V

I'm running SQL Server (2012) on a Hyper-V instance. It has plenty of resources and 25% reserved of the total resources, the VHD is placed on a very fast SSD drive for quick response times. Every now and then when the applications that use the SQL…
Eric Herlitz
  • 588
  • 2
  • 9
  • 19
25
votes
4 answers

In SQL Server, how do I create a login for an existing user?

I restored a database from one SQL Server instance on to a different SQL Server instance. The database allready has users added to it. But they don't have Login's for the new SQL Server instance. I know how to create new logins for new users, but…
epotter
  • 767
  • 3
  • 7
  • 11
25
votes
2 answers

Windows LocalSystem vs. System

https://stackoverflow.com/questions/510170/the-difference-between-the-local-system-account-and-the-network-service-accou tells: Local System : Completely trusted account, moreso than the administrator account. There is nothing on a single …
24
votes
9 answers

SQL Server to SQL Server linked server setup

Please explain what is required to set up a SQL Server linked server. Server A is SQL 2005 Windows logins only . Server B is the same (SQL 2005 Windows logins only) . Server A runs Windows XP . Server B runs Windows Server 2003 . Both SQL Server…
ScottStonehouse
  • 979
  • 4
  • 16
  • 25
24
votes
3 answers

How to update a CLR Assembly without dropping assembly from SQL Server

How can i update a CLR function (or procedure) assembly dll without having to drop and re-create the assembly in SQL Server (2008 R2)? As it stands now if i update an assembly (e.g. to add a new function), SQL Server will not honor the updated dll…
Ian Boyd
  • 5,293
  • 14
  • 60
  • 82
24
votes
6 answers

What happens during a live SQL Server backup?

Some of my coworkers were surprised when I told them that I can back up an SQL Server database while it's still running and wondered how that's possible. I know that SQL Server is capable of backing up a database while it is still online but I'm not…
Shane
  • 1,869
  • 4
  • 20
  • 34
22
votes
4 answers

How to duplicate MSSQL database on the same or another server?

I am trying to accomplish the following: Take a snapshot of the original database, create and exact a duplicate on another server? Take a snapshot of the original database, create a duplicate on the same server under a different DB name However, I…
Alex N
  • 782
  • 3
  • 10
  • 24
22
votes
4 answers

SSMS: Where does SQL Server store its server names?

I have a number of "old" servers or server names with a typo in them that keep showing up in my dropdown list of server in the "Connect to Database" dialog of SQL Server Management Studio: Where are those names stored?? Is there any way to clean up…
marc_s
  • 1,152
  • 4
  • 21
  • 35
21
votes
6 answers

Is there a way to determine the version of SQL Server that was used to create an MDF or BAK file?

I have a local copy of a SQL Server DB stored as an MDF file. Is there a way to tell what version of SQL Server was used to create that file?
Ben McCormack
  • 705
  • 4
  • 9
  • 16
20
votes
4 answers

How to exclude indexes from backups in SQL Server 2008

Our nightly full (and periodic differential) backups are becoming quite large, due mostly to the amount of indexes on our tables; roughly half the backup size is comprised of indexes. We're using the Simple recovery model for our backups. Is there…
Jarrod Dixon
  • 685
  • 2
  • 13
  • 23
19
votes
3 answers

How do I test connection from Linux to Microsoft SQL Server?

What's the simplest way to check connectivity from a Linux server (e.g. Ubuntu 18.04) to a remote Microsoft SQL Server 2017 instance?
Chef Tony
  • 401
  • 1
  • 3
  • 8
19
votes
14 answers

SQL - an error occurred during the pre-login handshake

Until yesterday evening, I was able to connect to my server from my local machine. Now, I get the following error: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL…
Rivka
  • 353
  • 2
  • 3
  • 12
19
votes
4 answers

How to detect if full text search is installed in SQL Server

I need to find out if full text search is installed on SQL Server 2005. I don't have permission to log into the box and fire up Setup to check. However I can run SQL Server Management Studio and connect to run queries with sysadmin permissions. Does…
Alex Angas
  • 2,017
  • 2
  • 26
  • 37