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

Benchmark tests for MSSQL 2000 VS MSSQL 2008.. (thinking for upgrade)

How much of a difference will there be (for speed and other benchmark results) for a database about 5 and even 10 GB to move from MSSQL 2000 to MSSQL 2008? It's running on a Windows 2003 VMWare guest on a CentOS host. Also, if someone can give more…
user52706
2
votes
1 answer

Move clustered SQL from one network to another

We have a clustered SQL server (2k5 Std) that's currently being hosted on 1 of 2 subnets on the server. We'd like to retire the subnet the SQL cluster is on as we're experiencing default gateway issues with the servers being multi-homed. My question…
I.T. Support
  • 601
  • 2
  • 11
  • 27
2
votes
3 answers

64K Cluster size for SQL Server Log Files

I was wondering if we put the SQL Server Database Log file and tempdb on RAID 1, should be format it with 64K cluster for better performance? Currently the database and log file are on RAID5 which I think is the worse for database log if you are…
RPS
2
votes
2 answers

How do I connect to a specific instance of SQL Server?

I believe I have MS SQL Server version 2005, and version 2008 (x64), on my computer. When I connect to localhost in SQL Server Management Studio 2008, the tree on the left says "localhost (SQL Server 9.0.4053)". Also, running: SELECT…
Lachlan
  • 123
  • 3
2
votes
4 answers

Rebuild master in SQL Express 2008

.ldf file is corrupted so I need to completely rebuild master database on a SQL Express 2008 installation. Is there anything short of destroying the instance completely and starting over?
Jon Masters
2
votes
2 answers

where can I find php_mssql.dll?

I'm trying to get PHP set up to connect to a SQL Server database. I'm looking for the php_mssql.dll file to put in my extensions directory but for the life of me can't locate it online. Can anyone help?
iamjonesy
  • 249
  • 1
  • 5
  • 16
2
votes
3 answers

Can SQL server and WSUS co-exist on same server?

Pardon me if this is a stupid question, but after reading responses from my previous question I'm looking into implementing WSUS on my network. The box I would likely implement it on runs a relatively small SQL server, and I understand that WSUS…
DKNUCKLES
  • 4,028
  • 9
  • 47
  • 60
2
votes
2 answers

Control FTP access from SQL table

I'm trying to set up my first FTP site. I would like to be able to take advantage of IIS6 isolation mode, but I can not figure out how to control the user accounts without manually adding each one (there are currently just over 1100 accounts). All…
wham12
  • 43
  • 2
  • 6
2
votes
3 answers

MS SQL 2005 -- backing up to a shared directory

I have a SQL 2005 virtual machine running Windows 2003 on a 2008 server under hyper-v and I need to start backing up my databases to a shared folder. I have created similar backup jobs in other environments with no problems. The difference is that…
gillonba
  • 343
  • 1
  • 4
  • 16
2
votes
3 answers

Backing up a SQL Server vm by doing a complete vm backup as opposed to individual dbs?

Is backing up a SQL Server via doing a complete backup of the VM image rather than backing up individual databases a bad practise? I can imagine that backing up the entire image looses the granularity of having several tlogs of each db for each day.…
GurdeepS
  • 1,646
  • 5
  • 26
  • 33
2
votes
2 answers

Migrate SQL Server

Can I migrate 32bit SQL Server 2005 database to 64bit SQL Server 2008 database without too much hassle or is there somethign I need to think about first?
Makach
  • 251
  • 1
  • 10
2
votes
0 answers

Can encryption be disabled for the login handshake in SQL Server 2005 or 2008

When a client Application connects to SQL Server the login credentials are sent over the network in a TLS Encrypted Handshake Message. For testing purposes I would like to have the login credentials sent in clear text. The password would still be…
KiwiNige
  • 153
  • 1
  • 6
2
votes
3 answers

xp_logininfo returns collation error

I have a production SQL Server that is set with system databases as Latin1_General_CI_AS but not all user databases are the same, some have been created with SQL_Latin1_General_CP1_CI_AS, and several others - they have been created as part of 3rd…
Fatherjack
  • 419
  • 3
  • 12
2
votes
1 answer

SCOM 2007 - SQL Server Monitoring

I've been tasked with comparing the monitoring capabilities in SCOM 2007 with the established SQL products such as Spotlight, SQLSentry, etc. I'm pretty sure that SCOM can't do some of the more in-depth stuff that those products do, but can it be…
Gary Hines
2
votes
2 answers

Equivalent of SQL 2005's SQLAgentOperatorRole (msdb ) in SQL 2000?

Can anyone tell me what is the Equivalent of SQL 2005's SQLAgentOperatorRole (msdb ) in SQL 2000? I want to grant a login ability to disable a job in SQL 2000. Thanks in advance....
Manjot
  • 333
  • 1
  • 3
  • 17
1 2 3
…
99 100