This tag is specifically for the 2000 version of Microsoft SQL Server
1
vote
1answer
141 views
Can't find location of undo *.tuf file
I run SQL Server 2000. Database is in standby mode. I have multiple files with MyDb.tuf name on a different drives. How may I know which one is in use?
1
vote
1answer
66 views
SQL Server 2000 query error
When I attempt to run on the SQL Server 2000 to a query which was developed for SQL Server 2008,I receive the following the error.
ambiguous column name SucNo
Here is my query:
SELECT ...
7
votes
2answers
6k views
Could not continue scan with NOLOCK due to data movement
We run SQL Server 2000 and we get a few of these errors every night.
Could not continue scan with NOLOCK due to data movement
The query that throws this error is a large complex query that joins ...
3
votes
1answer
411 views
Using (NOLOCK) in a READ COMMITTED transaction block
We're using SQL Server 2000.
I'm wondering what the risks are if we use a NOLOCK hint within a READ COMMITTED transaction block, for example:
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
GO
BEGIN ...
0
votes
2answers
663 views
DBCC CHECKDB errors migrating from SQL Server 2000 to SQL Server 2008R2
I'm getting integrity issues after I migrate a DB from SQL Server 2000 to SQL Server 2008 R2.
I ran a DBCC CHECKDB on the old db, and it returned no issues. Then I FTP-ed the backup file to the new ...
9
votes
6answers
2k views
Suddenly Slow Execution Plan for Stored Proc
I'm trying to understand an issue we're having with SQL Server 2000. We are a moderately transactional website and we have a stored proc called sp_GetCurrentTransactions which accepts a customerID, ...
4
votes
1answer
95 views
Possible pitfalls of condensing 2 SQL Server instances into 1
I currently have 2 SQL Server 2000 database instances (each running on a different physical server), each containing around 12 databases (not all are active). We are planning an upgrade to SQL Server ...
4
votes
3answers
156 views
How to monitor how much data is transfered in a linked server?
I have a linked server to a remote computer and doing some insert, update and delete operations between local and remote databases.
I want to know how much data is transfered when operation is doing. ...
1
vote
1answer
198 views
SQL 2000: change collation of model database only- not master
One of our production SQL 2000 server has windows collation for master and msdb but SQl collation for model and tempdb.
We are trying to have the same setup on a test environment which at the moment ...
2
votes
1answer
955 views
SQL Server 2000 to SQL Server 2008 linked server issue
Here's my scenario: I've got a linked server going from a SQL Server 2000 machine to a SQL Server 2008 machine. To aid in moving databases with a minimum of config changes, most of our connections ...
1
vote
1answer
474 views
SQL Server 2000: Can't DROP VIEW?
I have SQL Server 2000. I want to clean it by dropping obsolete and unused objects. One of the views causes me an error. I try to give more information but I still have no clue what the cause is.
...
0
votes
1answer
179 views
Running a sql server Trace of 1 GB using sqlcmd
I am load testing two sql server instances. I have a trace file from sql server 2000 database with a file size of little less than 1 GB. I am running this using the sqlcmd utility and it is been ...
3
votes
1answer
485 views
SQL 2000 Maintenance Scripts
Hi I've stumbled into the administration of a Legacy SQL 2000 server that has had next to no maintenance for the past 8 years (and is very slow). As I have only been doing DBA / PT for the past 2 ...
2
votes
1answer
470 views
Table Variables - Scope Error - Must declare the variable 'X'
This is my first post and not sure how to fix this auto format draft?
Using SQL Server 2000.
The table variable that is giving me this one error is '@SBLH'
The following is the multi-select function ...
0
votes
1answer
107 views
sql 2000 trace : sp_releaseschemalock
For a SQL 2000 server, is it bad to see too many
exec sp_releaseschemalock 1
events in a SQL trace file?
4
votes
2answers
200 views
What is an advantage or disadvantage for not upgreading database server?
I have a legacy database server. The person who wrote it is long gone. There is no documentation at all just some comments in the code. Luckily, it is not that complicate but if I want to fix it ...
1
vote
1answer
94 views
Should I Avoid Repeated References to Aggregate Columns in a View?
So I'm wanting to summarize the balance of the accounts in my business application. My (simplified for our purposes) data model looks like:
--Main account table that holds the single accounts
create ...
0
votes
3answers
960 views
Figuring out database timezone
Does anybody know of a way to alter a time zone on a SQL database? Is there any tool that could find the objects using the date and time?
-3
votes
2answers
258 views
Restore single page of a database - syntax error
I'm trying to run this query
RESTORE DATABASE dbname
PAGE = '1:442'
FROM DISK = 'C:\dbname.bak'
WITH NORECOVERY
but getting the error:
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near ...
8
votes
3answers
1k views
How to delay SQL Server startup
When we boot SQL Server, SAN drives might not be availiable yet. Is there a way to delay SQL Server start by 1 minute? Right now we have to restart SQL Server after we boot the server.
3
votes
2answers
638 views
xp_sendmail: failed with mail error 0x80004005
when I run xp_sendmail
exec master.dbo.xp_sendmail @recipients='me@hotmail.com',
@subject='terrrible thing happened',
@message='test'`
I am getting an error
Msg 18025, Level 16, State 1, ...
9
votes
2answers
2k views
How do you reset the sa password?
I lost the sa password on a machine, and when I log in to the machine directly using an account in the admin group, SQL Server Management Studio will not allow me to log in using Windows ...
4
votes
2answers
1k views
SQL 2000 - tsql to find out failed jobs in last 24 hours
I want to find out which sql agent jobs failed in last 24 hours...
How can I find it using TSQL for SQL 2000?
Regards
Manjot
3
votes
2answers
3k views
How to migrate from SQL Server 2000 to SQL Server 2008 R2 Express Edition
I have been trying to migrate a database from SQL Server 2000 (part of SBS 2003) to SQL Server 2008 R2 Express Edition
I naively tried using the SQL Server Export and Import wizard. This has worked ...
3
votes
4answers
775 views
tempdb in sql server
Using SQL Server 2000, I am getting the following error.
The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space."
How to solve it? I ...
1
vote
2answers
251 views
how to generate scripts for database objects specific to an application?
There was a application which, earlier, pointed to a database. It used a specific set of tables. Those tables had triggers, constraints, etc. There were also stored procs which insert data into these ...
2
votes
1answer
343 views
Changing SQL Server 2000 usernames
We're running a SQL Server 2000 instance with users tied to Windows accounts. Many of the usernames have spaces in them and that is causing us some problems now. We would like to be able to rename ...
6
votes
4answers
436 views
How can I tell if my SQL Server DB performance is hardware-limited?
Testing an app currently under single-user load - as the test data has increased to production sizes (400k-2M rows per table), some SELECT sp's are not quite fast enough anymore (with limited test ...
5
votes
1answer
692 views
Migrate DTS Jobs to 2008 Server
We have been running SQL Server 2000 for years.
Finally, at long last, we have an SQL 2008 Server being shipped in.
We have many DTS jobs on our SQL 2000 Server that need to be migrated to the SQL ...
2
votes
1answer
84 views
Forums about getting SQL Server 2000 Administration help?
What I'm trying to accomplish is that I need to migrate the SQL Server 2000 installation into a SQL Server 2008 installation, and I would like to say that I am afraid that after this operation I will ...
2
votes
4answers
626 views
How do you change the location of the data files in SQL Server 2000?
I have an old SQL Server 2000 machine in a clustered environment. The data files are on Disk S: which is running out of space. I have another Disk B: in the same disk array which has lot of space. I ...
2
votes
1answer
515 views
Sql 2000 attach Error 5172
When I attach a database file from SQL Server 2000 Standard Edition to SQL Server 2000 Database on another machine ,
I am receive the following error.
"Error 5172: The heather for file 'D:...' is ...
1
vote
0answers
513 views
DBCC CheckDB Consistency error on an empty table [duplicate]
I restored a DB from SQL Server 2000.
I ran DBCC CHECKDB on SQL Server 2000, and it did not report any errors.
What could be the reason behind a DBCC CHECKDB reporting a consistency error on a empty ...
1
vote
1answer
1k views
“Request to run job dbxxxxx refused” error in merge replication
I'm doing merge replication whole of my database but when I create the subscription I encounter this error:
SQLServerAgent Error: Request to run job DBXX-XX--bazresiostani2-2 (from User sa) refused ...
2
votes
1answer
301 views
How to determine the name of a process that caused a trigger to fire
Short Version:
Does anyone know of a way --inside a SQL 2000 trigger-- of detecting which process modified the data, and exiting the trigger if a particular process is detected?
Long Version
I have a ...
1
vote
1answer
492 views
ActiveX script throwing runtime error inside DTS package
I am a DBA. We have migrated SQL 2000 databases + DTS packages to SQL 2008. One of the DTS packages runs an ActiveX script to open an Excel file (which has runs macros when you open it). Coding ...
2
votes
1answer
474 views
SQL Server 2000 Enterprise Manager - “Navigation to the webpage was canceled” error when trying to design a table
While working in SQL Server 2000 Enterprise Manager on a remote server today, I wanted to look at a table's columns, so I found the table, right-clicked on it and selected "Design Table".
Instead ...
3
votes
1answer
340 views
Error moving SQL Server 2000 to SQL Server 2005 NOLOCK Error
I need to move a database from the SQL Server 2000 (32 bit) to SQL Server 2005.But,When I attacted my database to SQL Server 2005,it's gives me error.(NOLOCK error)
Also , After I running dbcc check ...
6
votes
1answer
2k views
SQL Server 2000 : List and Disable all triggers
I have to do a database cleanup for one of our databases on a sql server 2000 environment. The cleanup basically includes the disabling of all triggers, deletion of all old data, enabling of the ...
13
votes
4answers
2k views
How can I tell WHY an insert on a certain table is slow?
I know that an INSERT on a SQL table can be slow for any number of reasons:
Existence of INSERT TRIGGERs on the table
Lots of enforced constraints that have to be checked (usually foreign keys)
Page ...
1
vote
4answers
340 views
How do I restore a SQL Server 2000 database to a SQL Server 2008 instance?
How do I restore a SQL Server 2000 database to a SQL Server 2008 instance?
0
votes
1answer
746 views
Repair a SQL Server 2000 MDF file
I had a SQL Server 2000 MDF on a SQL Server 2005 server (moved from prior version), there was a hardware failure.
After sending harddisk, it was supposed the mdf / ldf files were recovered, but i am ...
1
vote
1answer
31 views
tsql to know when a database was last shrunk
In SQL 2000, 2005 and 2008, how can I know when databases were last shrunk on a MS SQL server?
I want to do this using TSQL.
Regards
Manjot
2
votes
1answer
535 views
SQL Server Migration restore backup vs copy data and log files
Hey guys, I'm tasked with doing a SQL Server 2000 to 2005 migration. I will be doing a side-by-side migration. I've read from a few different sources that I can either:
perform a backup of the ...
4
votes
5answers
342 views
Improving SQL Server performance on VMware under Linux
I have a Linux server in a small company (3 users) acting as a domain server and running two VMs under VMware: one has SQL Server 2000 on it and one has SQL Server 2005, in each case running on ...
