This tag is specifically for the 2000 version of Microsoft SQL Server
0
votes
1answer
11 views
Query mail logs for xp_sendmail
Using SQL Server 2008, I can query sysmail_log and other tables to see the results of sql emails.
Is anything remotely similar available for querying email logs in SQL Server 2000?
2
votes
3answers
89 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 verify that a particular account still has sysadmin privileges.
What non-destructive tasks can only sysadmins do that I can use to ...
0
votes
0answers
64 views
Query should yield result but doesn't
I need to get data from a remote SQL 2000 server and store it in a new MySQL server. I am using the FreeTSD module for php 5.3 to connect to the SQL 2000 server. I can connect without problems.
...
0
votes
0answers
24 views
SQL Server 2012 linked server to SQL Server 2000
I am trying to select through an linked server from SQL Server 2012 to SQL Server 2000.
The linked server has been setup and I can browser the target database through the linked server which ...
0
votes
2answers
64 views
Does a SQL Server job run on the server or the local machine?
Does a SQL Server job always run on the server, or will it run in the context of the local machine, similar to a DTS package run from Enterprise Manager on the user's machine?
The job in question ...
3
votes
4answers
599 views
Query without having to specify table's schema
I imported a bunch of tables from SQL Server 2000 to my 2008 database. All the imported tables are prefixed with my username eg: erpadmin.tablename.
In the table properties it lists 'erpadmin' as the ...
0
votes
2answers
78 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
2answers
173 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 ...
4
votes
2answers
128 views
Why do linked servers have a limitation of 10 branches in a CASE expression?
Why does this CASE expression:
SELECT CASE column
WHEN 'a' THEN '1'
WHEN 'b' THEN '2'
... c -> i
WHEN 'j' THEN '10'
WHEN 'k' THEN '11'
END [col]
...
0
votes
1answer
23 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
34 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
87 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 ...
2
votes
1answer
71 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
58 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 ...
1
vote
0answers
234 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
148 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
30 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
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 ...
0
votes
0answers
74 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
90 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
53 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
166 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
137 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
152 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
209 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
46 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
183 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
31 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
101 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
674 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
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?
3
votes
0answers
111 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
184 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
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 ...
5
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
104 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
130 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
108 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
116 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
63 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
75 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
155 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
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 ...
3
votes
2answers
321 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
256 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
42 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
112 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.
...
