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

Killing a cross server SELECT query has lead to an indefinite KILLED/ROLLBACK process. What's going on here?

A long running query was being run on a SQL Server 2005 database which referenced tables on a SQL Server 2000 database. Both instances of SQL Server are running on the same machine. It was only a select query, it did not alter any records. It had…
Evil Pigeon
  • 103
  • 3
0
votes
1 answer

SS 2005 SP4 install giving vsJitDebugger events

Windows Server 2003, SQL Server 2005 (9.00.3080) I installed SS2005 SP4 without a problem and immediately started getting vsJitDebugger 'unhandled win32 exception' messages in the application log every couple of minutes. I changed the DEP to only…
user49352
  • 123
  • 2
  • 4
  • 12
0
votes
1 answer

Two principals in a SQL Server 2005 Mirroring setup

We've recently changed our mirror setup to include a witness so we support automatic failovers, yesterday in our datacenter they had some planned maintenance to some of the network supplies (i believe they changed some Routers and things). Sadly,…
F.B. ten Kate
  • 123
  • 5
0
votes
2 answers

Configure SQL-SERVER without running service

Is it possible to change the location of the temp.mdf or other files without starting SQL-Server? I wanted to reactivate an old server but one of it's USB hard disk was been already used somewhere else. Now i'm unable to start the SQL-Server…
Tim Schmelter
  • 163
  • 1
  • 1
  • 6
0
votes
1 answer

SQL Server Migration

We have Windows Server 2003 R2 with SQL Server 2005 on it. We want to create a VM with Windows Server 2008 R2 with SQL Server 2008 R2. Now we want to move about 700GB worth of Data to the New Server. The biggest issue is we want to decommission the…
Fahd
  • 1
0
votes
1 answer

Upgrading 32-bit SQL Server cluster to 64-bit

Here is my situation. $WORK has a trio of three clustered database servers (64-bit Server 2003) that are currently running two SQL Server instances. Unfortunately, when the cluster was set up a couple years ago my organization did not have 64-bit…
Nathan
  • 3
  • 1
0
votes
1 answer

ms sql remote connection shows all db

I've a db called "abc" against login "cde". When i access this db remotely MSSQL Server 2005 shows me all the databases however User "cde" can only access db "abc". How can i disable view of all database?
User4283
  • 781
  • 3
  • 10
  • 27
0
votes
2 answers

Use more than 3 GB of memory on SQL Server 2005 on Windows Server 2003 R2 Enterprise x64

I am running SQL Server 2005 Standard x64 on Windows server 2003 R2 x64. I have 32GB of total server RAM. I am unable to make SQL Server use more than 3 GB of memory, even I set min and max server options as follows: sp_configure 'show advanced…
Darius
  • 111
  • 1
0
votes
3 answers

SQL Server Migration Assistant for Oracle

I've recently installed SSMA and after connecting to both the Oracle instance (which holds the database to be converted) and the SQL Server I've mapped the necessary schemas from Oracle to MSSQL. The problem is that when I click on the report…
Paul
  • 714
  • 2
  • 6
  • 19
0
votes
2 answers

get sql server 2005 to NOT use unicode in its TDS protocol?

This may be a really stupid question, but... The TDS protocol used by sql server appears to use unicode or UTF-16 character encoding. A query like select foo from bar appears like s.e.l.e.c.t. .f.o.o. .f.r.o.m. .b.a.r in the tcp stream in…
simon
  • 714
  • 1
  • 7
  • 21
0
votes
1 answer

Cannot open backup devices

I'm getting this error Msg 3201, Level 16, State 1, Server server\instance, Line 1 Cannot open backup device '\\server\share\database.bak'. Device error or device off-line. See the SQL Server error log for more details. Msg 3013, Level 16, State 1,…
amer khan
0
votes
1 answer

reporting services Unable to connect to the remote server

I've got reporting services and sql server 2005 installed on a windows server 2003 enterprise sp2 server. Reporting services was working just fine until yesterday it started saying "Error- Unable to connect to the remote server". I'm really not…
Thirster42
  • 354
  • 1
  • 2
  • 14
0
votes
1 answer

Error SQL Server 2005 Using Proxy to run Agent Job ConnGetProxyPassword

I'm using a proxy to run several SQL Server agent jobs. Essentially the jobs copy data from Excel spreadsheets into a dbs via a network shared drive. The jobs have been failing for several weeks with the following error: "Unable to start execution…
alimack
  • 943
  • 2
  • 11
  • 22
0
votes
3 answers

Copying SQL Server 2005 Databases

We currently have a single SQL server (2005, on a Windows server 2003 machine) with 3 DBs on it that I would like to just straight copy so that I can run some test on them for an upgrade. I don't think I can do this with the copy DB wizard as I am…
Tablemaker
  • 1,149
  • 1
  • 11
  • 23
0
votes
2 answers

Problems restoring large SQL Server 2005 database

I have a customer with a gigantic SQL Server 2005 database (almost 400GB including the log file) and a table has been unintentionally dropped. We are trying to restore to a temporary database then we will copy the data across from the missing…
Nick Thompson
  • 1
  • 1
1 2 3
…
71 72