This tag is specifically for the 2000 version of Microsoft SQL Server
0
votes
1answer
13 views
In SQL Server 2000 or greater is their 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
32 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
55 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
35 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
59 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
94 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
103 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
85 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
44 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 ...
6
votes
1answer
161 views
Is there a quickish, straighforward way to measure Transactions Per Second on SQL Server 2000?
The sys.dm_os_performance_counters DMV introduced in SQL Server 2005 makes this task somewhat trivial. However, my Google-Fu has been blocked in finding a way to do this in SQL Server 2000.
How can ...
3
votes
5answers
121 views
Can SQL Server 2000 and SQL Server 2012 CoExist?
We have OLTP Databases on SQL Server 2000 on my client's Prod Server. Planning to create Data Warehouse on the same Server but use SQL Server 2012. Can I install without any issues?
3
votes
2answers
142 views
Cleaning up transaction replication del/ins/upd stored procedures?
I'm referring to the ones that start with:
dbo.sp_MSdel...
dbo.sp_MSins...
dbo.sp_MSupd...
I've noticed they are not removed when I run exec sp_dropsubscription on the Publisher then run ...
2
votes
1answer
123 views
Table Size Analysis on SQL Server 2000
Our SQL Server 2000 database .mdf file is 27Gb large which seems much larger than is plausible. Using the following query we tried to analyse table sizes:
select cast(object_name(id) as varchar(50)) ...
0
votes
0answers
37 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'.
...
2
votes
0answers
158 views
Tables not shown in SQL Server Enterprise Manager
For some reason 3 tables which are clearly in use by the application are not
listed in the Tables view in SQL Server Enterprise Manager. It's SQL Server 2000.
When generating a diagram, a popup ...
2
votes
0answers
27 views
Can I open a table twice using different recordsets and update the second without affecting the first?
Context: Windows 7, SQL Server 2000, JScript.
I have a recordset opened as follows:
var cmd = "SELECT * FROM Table1 WHERE Field1 = 9 AND Field2 = 0;";
var oRS = new ActiveXObject("ADODB.Recordset");
...
2
votes
2answers
80 views
Is there a way that I can export a list of all table triggers on a server?
I have two SQL Server instances that I manage. One is a SQL Server 2000 instance, and the other is 2005.
Some where, on these servers, I recall setting up a couple table triggers that were executed ...
4
votes
4answers
548 views
SQL Server script to delete accounts no longer in Active Directory
We have a SQL Server 2000 that will shortly be migrated to SQL Server 2005. It has years of Windows Authentication accounts created that no longer exist in Active Directory, which prevent the Copy ...
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 ...
0
votes
1answer
103 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?
3
votes
0answers
98 views
How to replicate from SQL Server 2000 to SQL Server 2008 R2?
I have SQL Server 2000 as publisher and SQL Server 20008 R2 as subscriber.
I want to replicate data from SQL Server 2000 to SQL Server 2008 R2 on a different machine.
Primary key fields are not ...
3
votes
1answer
165 views
SQL Server 2008 upgrade advisor tool
We upgraded to SQL Server 2008 from SQL Server 2000. But due to some legacy scripts/queries in our health care application, that run only in 2000, we had to run 2008 version on backwards compatibility ...
0
votes
1answer
706 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 ...
4
votes
3answers
5k views
Upgrade process from SQL Server 2000 to SQL Server 2012
I have a SQL Server 2000 database that I would like to upgrade to SQL Server 2012 (running on a different server).
I don't think there is a direct upgrade path, but if there is, what is it?
My ...
3
votes
2answers
75 views
SQL server 2000 transactions with the same time
I have a BIG problem here.
I'm creating a program that can be looping if the connection to the server is broken.
But when the program is running for a few months, I found a bug on SQL server 2000.
I ...
1
vote
1answer
88 views
How to delete and create user remotely on SQL Server 2000
My boss wants to make sure that no one runs a job accidentally so we are setting up lots of safeguards to ensure that no one sleepwalks, log into the system and run a job. We are updating the ...
1
vote
3answers
129 views
SQL Server 2000 performance
I have a SQL server with about 150 tables and the 5 tables that are used the most consist of over 10 million rows each. I'm trying to see why the performance of the server has been diminishing day by ...
0
votes
1answer
110 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 ...
1
vote
1answer
96 views
How does disabling a network protocol affect SQL server performance
The SQL server 2000 process info monitor displays about 100 processes that use a mix of Named Pipes/TCP-IP and (integrated authenticated) users. I was wondering if:
disabling Named pipes - or - ...
5
votes
2answers
112 views
Thought about this SQL Server backup plan?
I just started a new job, and I'm reviewing the database maintenance plan. I've got quite a bit of experience writing SQL, but not much experience with DB administration. My last job was at a large ...
1
vote
1answer
58 views
Monitor Sql Server 2000
I was wondering if there is a free tool to monitor state of SQL Server 2000. I would prefer a web tool.
I would like to see if some database is accessible, or are there any problems on server, etc. ...
3
votes
2answers
67 views
Finding longest matching prefix
I have two tables:
Sources:
(SName) (SId)
Apple1 100
Apple2 200
Banks 300
BanksB 400
Bankerly 500
Prefixes:
(PName) (PId)
App 1
Bank 2
Banker 3
My goal: To find the longest ...
2
votes
2answers
111 views
Shrinking SQL Server 2000 database
I apologize for the long question. I am trying to learn a lot on the fly as I have become the defacto SQL Admin. I have been tasked with moving a production database to a new server. My goal is to ...
0
votes
0answers
28 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 ...
3
votes
2answers
227 views
How group with min(date) and select an another column in the same table
I have a query who return something like it :
Name Gender Job date of hire
John M mechanic 2012-05-08
John M electrician 2010-01-01
Vicky F scientific 2012-11-11
Bob ...
2
votes
1answer
246 views
Drop constraints vs disable constraints during a data import
I am in a tough situation, and looking for advice on how to proceed. I have to import some data from one environment to another. 80% of the records have been modified, so the plan is to simply ...
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 ...
2
votes
1answer
105 views
SQL Server 2000 : List of tables ordered from by number of referenced tables
Is there any way in SQL Server 2000 to get a list of tables ordered by dependency? I need it for insert order in empty data base.
I can't turn off constraints, so I'm stuck with this solution.
...
7
votes
1answer
329 views
Transactional replication from SQL Server 2000 to 2008
I have legacy databases on two SQL Server 2000 servers that I am trying to replicate to a SQL Server 2008 R2 database using transactional replication.
The 2008 server is not in the same LAN, so I am ...
1
vote
0answers
78 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 ...
0
votes
1answer
385 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 ...
3
votes
1answer
301 views
Unable to start MSSQL and SQLSERVERAGENT in Windows Server 2003
We are using MICROSOFT SQL SERVER 2000 Enterprise Edition. Our main problem we cant start MSSQL and SQLSERVERAGENT services.
Heres the Error log :
...
2
votes
2answers
58 views
What tasks can only sysadmin's do in SQL Server 2000?
I'm cleaning up permissions on my SQL Server 2000, and I want to test that a particular account still has sysadmin priveldges. What non-destructive tasks can only sysadmins do that I can use to ...
8
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 ...
