This tag is specifically for the 2000 version of Microsoft SQL Server
0
votes
1answer
16 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
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
3answers
58 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 ...
-1
votes
1answer
38 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.
...
2
votes
1answer
61 views
excessive CPU utilization by SQL server
I have an issue with SQL server 2000. Its CPU utilization is high from 9.00 AM to 5.00 PM. Three applications use this server through three different instances but when the CPU utilization is high one ...
3
votes
1answer
51 views
Is there a behavior change between SQL Server 2000 and SQL Server 2008 R2 OPTION (FAST 1)?
This is question 2 of 2 related to the FAST query hint. Background Information (as an aside, I'm not trying to garner more rep, I'm trying to be true to only asking one question per question).
Our ...
0
votes
2answers
62 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 ...
1
vote
0answers
97 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 ...
3
votes
2answers
105 views
SQL Server how to detect unused views and/or get usage stats
Is there a way to determine in SQL Server if a view is no longer being used? (without removing it)
Ideally i would like to know usage for SQL Server 2000 as well as 2012 if that is possible.
I am ...
0
votes
1answer
86 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
4
votes
5answers
340 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 ...
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 ...
-1
votes
1answer
77 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 ...
0
votes
0answers
45 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 ...
