This tag is specifically for the 2000 version of Microsoft SQL Server
1
vote
1answer
216 views
Consistency errors in SQL Server 2000
I have SQL Server 2000 and ever since upgrading from SP2 to SP4 random errors began happening. Mostly overflow errors, sometimes in SqlDateTime and sometimes in data type numeric.
For example, ...
1
vote
1answer
195 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 ...
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 ...
1
vote
1answer
487 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 ...
1
vote
0answers
123 views
SQL pre-login handshake connection failure
I'm having an intermittent problem with one of my old SQL 2000 servers. Every once in a while it stops accepting logins. I fix the problem by bouncing sqlservr.exe and then it starts working properly ...
1
vote
0answers
79 views
Pull replication stuck on Microsoft SQL Server 2000. What is the safest way to get it running again?
I believe the steps necessary would be:
Generate scripts to "create or enable" (including replication jobs) by right clicking the subscription in question in "local subscriptions" and saving the ...
1
vote
1answer
178 views
SQL Server Database Corruption Problem [closed]
I have developed a simple App in Microsoft VB.Net 2008 in which I have implemented database connectivity with SQL Server 2000.
After 4 to 5 executions of the program I often find my database goes ...
1
vote
0answers
128 views
Is there a way to use a SQL Server 2000 database in SSIS 2012?
I just got my first chance to install SQL Server 2012 on a test machine. I also installed all of the management and Visual Studios components. I created a copy of one of my SSIS 2008 packages and ...
1
vote
1answer
102 views
Can't do any changes to a job in SQL 2000
I have a job in my SQL 2000 server, this job is used to execute a DTS, i want to change the schedule of this job.
but every time i try to change of delete or stop this job i get the error message
...
1
vote
1answer
449 views
How to change a user's name in SQL Server 2000?
I'm not asking how to change the user's login, which is doable with sp_change_users_login, but really the user's name (which comes under the Name column of the list of users in Enterprise Manager).
...
1
vote
1answer
137 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
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 ...
0
votes
3answers
60 views
SQL Server 2000 dateformat permanent change
I am using SQL Server 2000 for an old system web site. I've just hit an issue that is going to cause me endless hassles down the road.
When I installed the server on my local system I took all the ...
0
votes
2answers
490 views
How to upgrade a SQL 2000 Database to SQL 2005 - need confirmation?
I need to confirm the process for upgrading a standard SQL 2000 database to SQL 2005. As I understand it, there are at least 2 methods for upgrading. Back\Restore and Detach\Attach DB. In my case, I ...
0
votes
3answers
912 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?
0
votes
2answers
33 views
Can you create an unrecoverable SQL Agent back log?
I have created and am using an SQL Agent for the first time. I have searched google but either the info isnot there or I am not getting the keywords correct (SQL agent + back log/callstack overflow ...
0
votes
2answers
91 views
How can I generate call stack on error on the fly
I have an issue with an index on a Sql2k server:
Event Log shows the following errors happening:
Date 2/14/2012 9:54:19 AM
Log SQL Server (Current - 2/14/2012 10:26:00 AM)
Source ...
0
votes
1answer
17 views
Is there a system primary key associated with each row?
Does a system primary key or unique identifier for each row in a table exist? Like @@ROWID, @@IDENTIFER, or some other identifier that uniquely identifies each row regardless of how it was created? ...
0
votes
1answer
115 views
How can I create a view that spans multiple databases?
I have three databases named exayear2011, exayear2012, and exayear2013. They all have the same schema, but the data is different for each year.
I want to create a view that gets data from table1 in ...
0
votes
1answer
227 views
enable agent XPs
I am trying to run the following script on SQL 2000:
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'ave enabled' 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
...
0
votes
1answer
170 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 ...
0
votes
2answers
96 views
Linked Server to SQL Server 2000 server from SQL Server 2012
I have a new SQL Server 2012 instance, and am migrating a database from SQL Server 2000. Some of the stored procedures in the DB I am moving reference another database back on that 2000 server. What ...
0
votes
1answer
28 views
SQL Server 2000 trace file extension
Are SQL Server 2000 trace files generated in a .tdf format, the same way as SQL Server 2008 R2?
Thanks
0
votes
2answers
128 views
Is there a way to examine SQL Jobs for references to linked servers?
In preparation for migrating a server farm to the cloud, I am attempting to enumerate all the linked servers that have been defined over the years. I also need to find (and correct) the code that ...
0
votes
1answer
342 views
Who changed the job schedule on a SQL Server Agent Job (SQL 2000)
Someone (or some unknown process) changed the job schedule on
a SQL Server Agent Job on a SQL 2000 database. The original
start time was 6:00, but was changed to 4:45; that much I can determine.
Is ...
0
votes
1answer
718 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 ...
0
votes
1answer
38 views
Backup audit database
We currently have SQL Server 2000 in use. One is LIVE and one is BACKUP. We have an audit database which grows massively. What would be ideal is that at the end of each month, the data gets copied ...
0
votes
1answer
386 views
Getting “Cannot open user default database. Login failed.” for connections that don't specify a default database
I have two virtual machines. Server A is running SQL Server 2000. Server B is running SQL Server 2008R2. I am using the same domain user to log in to both boxes.
But I cannot log in to SQL Server ...
0
votes
1answer
65 views
Is there a way to display current noise words in SQL 2000 Full Text Indexing?
I know this is ancient technology, but sometimes upgrading is not always an option.
Does anyone now how to list the actual noise words that are currently in use on a SQL 2000 Full Text Index?
We ...
0
votes
1answer
252 views
Installing “SQL Server 2000 Client” and “SQL Server 2000 service pack 4” [closed]
Installing "SQL Server 2000 Client" and "SQL Server 2000 service pack 4".
I am new to SQL server and want to know if both are different and the exact steps that i need to follow for installation. ...
0
votes
2answers
642 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 ...
0
votes
1answer
104 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?
0
votes
0answers
70 views
Why upgrade SQL Server 2000? [closed]
I am responsible for a large legacy application, mostly written in classic ASP, running against SQL Server 2000. I have been considering upgrading to a newer version, but most of the information I've ...
0
votes
0answers
46 views
SQL Server 2000 Trace Template for SQL Server 2008 R2 Upgrade Advisor
My current database is SQL Server 2008 R2 with compatibility level 80 (SQL Server 2000). I need to upgrade compatibility level to 100 (SQL Server 2008/R2). I have installed SQL Server 2000 Enterprise ...
0
votes
2answers
65 views
How to make a copy from a Emergency Database?
I've a database on a very old Computer (Windows xp, SQL server 8.0). Yesterday, the database has been marked as suspected, I've put it to the emergency state. So now the database is Read-Only. The ...
0
votes
0answers
39 views
SQL Server 2000 database attach error to SQL Server 2005
I have a SQL Server 2000 database (mdf and ldf).
When I try to attach it, using SQL Server Management Studio Express 2005, I get this error:
Attach database failed for Server 'XXXXX\SQLEXPRESS'.
...
0
votes
0answers
29 views
Shrinking SQL Server 2000 database [duplicate]
Possible Duplicate:
Shrinking SQL Server 2000 database
I have become the defacto SQL Server Admin and I have been tasked with moving a production database to a new server. I am trying to ...
0
votes
0answers
70 views
Msg 15064, 15275, and 15235 when running sp_spaceused
I have a database on SQL Server 2000 (no, I can't upgrade right now) where I'm trying to run sp_spaceused on each table.
I'm getting the messages below. Any given table may have any, all, or none of ...
-1
votes
3answers
3k views
Installing SQL Server 2000 32-bit on Windows Server 2008 x64?
Am I correct in assuming there won't be any issues installing SQL Server 2000 32-bit on a Windows Server 2008 x64 system?
I understand the memory limitations, etc, but that doesn't matter at this ...
-1
votes
1answer
78 views
IO Frozen in error SQL error log
The log shows IO DBName is Frozen follow by thaw but yet my database schedule backup task which normally been running isn't since the network team are doing backs (not database backups, according to ...
-1
votes
1answer
42 views
SQL Server does not exist or access denied [closed]
Anybody can assist on how to resolve this kind of error? I have already checked the windows firewall in the server but still fails to connect. I have also tried to do TELNET and fails to connect also.
...
-3
votes
2answers
251 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 ...
