Server Fault Stack Exchange
Server Fault Stack Exchange

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
2
votes
7 answers

MSSQL Server 10 runaway log growth, 100GB/week

I have started as an IT Manager and my remit covers MSSQL server. A database that I have inherited uses around 100GB of HD in the space of a week, in the LDF file. This in turn uses all available disk space on drive C: and the server falls over.…
Skeep
  • 165
  • 1
  • 6
2
votes
2 answers

SQL 2008 to 2008 R2 upgrade failed, can't install R2 now

We attempted to upgrade SQL 2008 to 2008 R2. It passed the checks with flying colors. But midway through the installation we got the dreaded "No mapping between account names and Security IDs was done" error. After much Googling, we believe we…
Boo
2
votes
1 answer

Adding comment (e.g. description) to views, tables, etc

Is it possible to add a short description to views, tables, etc. in SQL Server?
Behrang
  • 289
  • 2
  • 3
  • 10
2
votes
7 answers

Enabling xp_cmdshell in a production environment

A SQL developer on a project I am working on has asked whether it would be possible to enable xp_cmdshell on the production database as it is easier to export CSV files using xp_cmdshell than to write an SSIS package to do the same. Enabling…
Hugo Rodger-Brown
  • 3,719
  • 2
  • 18
  • 12
2
votes
2 answers

MS SQL Server: multiple databases on one or more VMs?

We are planning to deploy an eCommerce Solution using three distinct databases, all to be hosted in MS SQL Server 2008 R2. The whole stack will be hosted in a VMWare environment (two physical machines with a parallel setup of VMs). The question I…
Peter Becker
  • 180
  • 10
2
votes
2 answers

Can I Boost Priority to a Process that I Killed and is Rolling Back?

I have a job that usually runs for about 2 hours. This morning it was still running at 5 hours and I decided to kill it. It has been in a "KILLED/ROLLBACK" status for quite a while now. When I run the KILL command again to get the status of the…
Micky McQuade
  • 195
  • 9
2
votes
3 answers

Restore database with override sql server

Here's a script that attempts to take a daily backup from the previous day and restore it over a reporting database. My problem is how do I set it to override the files, so I don't have to specify the file names? When I run this I encounter a series…
user38553
  • 193
  • 1
  • 2
  • 8
2
votes
2 answers

How to configure Windows user accounts for ODBC network with NT authentication?

I'm trying to create a connection to an SQL Server database from the ODBC Data Source Administrator using "Windows NT authentication using the network login ID". Both server and client are running Windows XP. It appears that any account with…
Ian Mackinnon
  • 183
  • 2
  • 15
2
votes
3 answers

Can I use a NAS for SQL Server?

Possible Duplicate: SQL Server Files Local or NAS or SAN? Hi, I have just bought a NAS (NETGEAR Stora) for our home office - 2 Windows PCs. I want to run a small database that both machines can access. I am building a c# winform app that is…
kurasa
  • 121
  • 1
  • 1
  • 4
2
votes
1 answer

MSSql Server, "Impossible" Error

Just a few hours ago, we started getting an error that is "impossible" as far as I can tell. Error is Violation of PRIMARY KEY constraint 'PK_RntlApp'. Cannot insert duplicate key in object 'Rental_Application'. The reason I think this is…
Matt
2
votes
5 answers

SQL Server 2008 (SSMS) : Find next run date for a job

I would like to know if there is a way to get the next time a job is supposed to be running in SQL Server 2008, using a T-SQL query or even in SSMS if possible, without having to consult all the schedules for all the jobs. Thank you
MaxiWheat
  • 237
  • 5
  • 12
2
votes
2 answers

Powershell command to confirm SQL Server Smo.Server object is valid

I had the following code in a PowerShell script: $sql_instance = "SQLEXPRESS" [System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') $server = New-Object ('Microsoft.SqlServer.Management.Smo.Server') $sql_instance Write-Host…
8kb
  • 183
  • 2
  • 7
2
votes
4 answers

What is deploying a server?

I have the server.. My colleagues have talked about deploying a server. I am a new in computer world I don't understand what they mean. Could you explain me please what is deploying the server? Best regards, Ragims
user52947
  • 123
  • 1
  • 1
  • 4
2
votes
3 answers

SQL Server 2005 - SSIS Package Won't Execute

Environment: Windows Server 2003 R2 Standard x64 Service Pack 2 SQL Server 2005 SP2 (9.00.3077.00) Enterprise Edition (64-bit) Trying to install and execute an SSIS package on a development environment, getting the following error: Executed as…
Ian Nelson
  • 131
  • 2
  • 5
2
votes
1 answer

SQL 2008 SA Password Gone with the Wind

Situation: There is a SQL 2008 instance here that we would like access to. The person who setup the instance is no longer with the company and, apparently, did not set the instance up with the proper users as admins. However, the proper users are…
SQL Problem
1 2 3
…
99 100