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

SQL Server 2005 random login failures for windows forms application

One of our VS .NET 2008 windows forms applications runs from multiple client machines. The application randomly has login failures from random machines and from random places in the code. The login works almost every time but about once every…
Mindy
  • 117
  • 2
  • 2
  • 8
2
votes
1 answer

peer-to-peer replication in SQL server 2008 R2

http://www.databasejournal.com/features/mssql/article.php/3814591/Peer-to-Peer-Replication-in-SQL-Server-2008--Configure-a-two-node-topology.htm here i can see peer-to-peer replication option but this options are not in my SQL 2008 r2 standard…
senzacionale
  • 328
  • 1
  • 6
  • 16
2
votes
2 answers

Connecting to MSSQL on EC2 from local

Has anyone ever managed to connect to Microsoft SQL Server (preferably 2008) hosted on Amazon EC2 from Management Studio on your development machine? I have set up the security group to allow port 1433, opened port 1433 outbound from Windows…
Adrian Godong
  • 577
  • 4
  • 9
  • 20
2
votes
1 answer

How to backup a specific SQL Server Schema's table?

In my SQL Server database, I have multiple schemas. I would like to backup only a specific schema's tables to a format that can easily be restored. Example: [dbo].[Trucks] [dbo].[Cars] [unknown].[Trucks] [unknown].[Cars] How can I backup only the…
Omar
  • 195
  • 3
  • 14
2
votes
3 answers

What SQL Server Query will set perfmon counter "Longest Transaction Running Time" > 0

I'm trying to decide whether this performance counter is worthwhile monitoring: \\SERVER\MSSQL:Transactions\Longest Transaction Running Time. So during testing I tried to create some long running transactions but I can't seem to get this counter to…
Michael J Swart
  • 185
  • 1
  • 7
2
votes
3 answers

Large insert/update in table causes timeout while SQL Server re-arrange indexes

We insert/delete about 1 million rows of a two million rows table with SSIS. We have 20 indexes on this table. Right after the SSIS finished, we're experiencing timeouts in the frontend. The timeouts eventually go away. I'm suspecting the indexes…
Mike Gleason jr Couturier
  • 140
  • 1
  • 1
  • 7
2
votes
3 answers

What issues are there installing a SQL 2008 on Win 2008 cluster?

As we all know, the cluster setup, maintenance, and underlying mechanisms have been changed extensively for SQL 2008 compared to 2005/2000. Although this fell under the Storage Engine group I was responsible for at Microsoft in 2005-2008, I wasn't…
Paul Randal
  • 7,194
  • 1
  • 36
  • 45
2
votes
1 answer

Citrix server running 3rd party app experiencing SQL timeouts

We are running an app that was not developed in house on several Citrix servers. The users of this application are experiencing intermittent SQL timeouts. The error message: "System.Data.SqlClient.SqlException: Timeout expired. The timeout period…
Graham Powell
  • 410
  • 2
  • 8
2
votes
1 answer

How to migrate SCCM and SCOM's databases from SQL Server 2005 to SQL Server 2008?

I need to migrate databases (including reporting services) applications System Center Operations Manager and System Center Configuration Manager to a single SQL Server 2008. Currently each of the servers has a dedicated SQL 2005 Instance. I'm…
MotoRazr
2
votes
3 answers

Error when trying to open SQL Maintenance Plan - SSMS 2008

If I open SSMS on my client machine, connect to our SQL server, and try and open a maintenance plan on there, I get this error: TITLE: Microsoft SQL Server Management Studio Could not load file or assembly 'msddsp, Version=9.0.0.0, …
alex
  • 1,720
  • 15
  • 43
  • 63
2
votes
4 answers

How to reserve system resources to specific SQL Server 2005 databases?

Is it possible to specify a min/max amount of system resources (Disk IO, Memory, CPU cycles/s) available to each database instance inside a SQL Server 2005 server? This would be the analogue of QoS settings for SQL Servers.
Ricardo Cabral
  • 121
  • 3
2
votes
1 answer

Will SQL 2008 Express still have a 10Gb limit if I use it to open a 2005 MDF file?

I have the following situation: I have a production site running on SQL 2005 Express (only because it's free), and it's a reasonably big DB, and i'm always incredibly close to the 4 Gb limit. Every now and then I actually hit it and it's a big…
Daniel Magliola
  • 1,432
  • 9
  • 20
  • 33
2
votes
2 answers

MS SQL differential backup strategies

We recently had a failure on one of our servers. The server was not accessible and we could get any data from it. We had a backup plan that took a full backup every second day and then then a diff backup every 6 hour or something. I use Jungle Disk…
Olaj
  • 183
  • 1
  • 2
  • 8
2
votes
3 answers

Mysterious timeouts in MSSQL 2000

I have a query that has been working fine for ages (2+ years). All of a sudden it went from taking 3 secs to 30+ to execute. The table indexes have minimal fragmentation, but rebuilding the indexes "fixes" it for about a day. When I go to check the…
KellCOMnet
  • 245
  • 2
  • 11
2
votes
5 answers

What can be done to protect a exposed SQL 2005 Server without additional hardware?

I'm helping a customer with an exposed MSSQL 2005 server. They will not budge on a firewall or VPN solution... and there logs are full of signs of attacks. What can be done to protect a exposed SQL 2005 Server without additional hardware? By exposed…
NitroxDM
  • 635
  • 1
  • 15
  • 29
1 2 3
…
99
100