Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2005]

Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This tag is for questions on the 2005 version

1072 questions
5
votes
2 answers

Clustered indexes versus non-clustered indexes?

I am in charge of a smaller DB 300+ hundred megs 100'ish tables about 45 users hit it throughout the work day. Mostly reads, but a fair number of updates and inserts. I have been slowing learning the structure of the DB in order to get some…
RateControl
  • 1,207
  • 9
  • 20
5
votes
5 answers

What can cause long query durations without high resource usage?

In advance: sorry for the length of the question... unable to get the right balance between detail and brevity. We are having issues with the DB Server for our web application where queries that should (and usually do) run in a very short time (<…
JMusgrove
  • 1,223
  • 1
  • 8
  • 8
5
votes
5 answers

SQL2005 Stuck in Single Mode User

Hey currently have a database stuck in single mode after setting it to single mode to attempt to try take if offline which I wish I never did.... I tried ALTER DATABASE DB SET MULTI_USER but get Msg 5064, Level 16, State 1, Line 1 Changes to the…
StevieB
  • 153
  • 1
  • 4
5
votes
2 answers

How can I safely kill a long running MSSQL query?

Recently we had a SQL job inserting into a database. The query had been running for a few days unecessarily so it was killed using KILL SPID. The process then began to roll back for several days and just seemed to hang there. Running KILL SPID WITH…
Anonymous
  • 193
  • 1
  • 1
  • 7
5
votes
2 answers

SQL Server Column Level Encryption - Rotating Keys

We are thinking about using SQL Server Column (cell) Level Encryption for sensitive data. There should be no problem when we initially encryption the column, but we have requirements that every year the Encryption Key needs to change. It seems that…
Mike Barlow - BarDev
  • 516
  • 5
  • 8
5
votes
6 answers

SQL Server 2005 Service Pack 3 won’t install

I am trying to install SQL Server 2005 Service Pack 3 and it keeps failing. Comes back with the following: Microsoft SQL Server 2005 - Update 'Service Pack 3 for SQL Server Database Services 2005 ENU (KB955706)' could not be installed. Error code…
AngryHacker
  • 2,877
  • 6
  • 32
  • 33
5
votes
2 answers

How to create aliases without installing SQL Server 2005 Client Tools

I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client…
Arnold Zokas
  • 308
  • 1
  • 4
  • 18
5
votes
3 answers

Do I need to split a database to filegroups? It's 30gb now

I'm in the process of changing a database server at my company from Windows 2000/Sql Server 2000 to a Windows 2003 R2/Sql Server 2005 now. It holds 30 databases, each of the databases is about 7gb in size, but one of the is 30gb. And now I'm…
Svein Erik
  • 205
  • 3
  • 8
4
votes
3 answers

How to execute msdb.dbo.sp_start_job from a stored procedure in user database in sql server 2005

I am trying to execute a msdb.dbo.sp_start_Job from MyDB.dbo.MyStoredProc in order to execute MyJob 1) I Know that if i give the user a SqlAgentUser role he will be able to run the jobs that he owns (BUT THIS IS WHAT I OBSERVED : THE USER WAS ABLE…
Ram
4
votes
2 answers

Virtualisation and SQL server

The sysadmins where I work are looking to re-organise our servers and they have suggested that we put the main production SQL DB on a virtualised server. Is there anything they need to consider when doing this? Should we expect a drop in…
Johnno Nolan
  • 266
  • 3
  • 9
4
votes
5 answers

locked out of my own SQL server

I have a server at a branch location that is running SQL 2005 and I can't seem to log in. The users are able to use the application that depends on the database just fine, but I cannot access the SQL server with the admin account. We only had one…
gillonba
  • 343
  • 1
  • 4
  • 16
4
votes
8 answers

SQLServer - need to access an ACT! database for data migration

I'm looking for a way to access data in an ACT! database for a data migration to a custom application. The ACT! software uses SQLServer 2005. The data conversion script and new application will be written on a Linux system using Python and…
JeffG
  • 41
  • 1
  • 2
  • 4
4
votes
3 answers

Create an SQL trace without using SQL Profiler

I've read before that its possible to create a SQL profiler trace that records directly to a table without neeing to use the SQL profiler - apparently this is better than having the SQL profiler itself running as the SQL profiler captures all…
Justin
  • 379
  • 6
  • 13
4
votes
4 answers

Creating a SQL server Maintenance Plan without the wizard

Is there a way to generate a SQL server maintenance plan that will be the same as the one generated by the wizard, but without going through the wizard dialog. I need something that can be created automatically as part as an install process. Also,…
Ron Harlev
  • 243
  • 1
  • 8
4
votes
4 answers

Best way to replicate / mirror 100s of databases in SQL 2005

I currently host around 400-500 SQL 2005 databases of varying sizes (1-10 gig) each. I am aware of most of the different methods available and the general pros/cons of mirroring, log shipping, replication and clustering, but i am not aware of how…
mrwayne
1 2 3
…
71 72