The sql-server-2000 tag has no wiki summary.
5
votes
1answer
40 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 ...
4
votes
1answer
57 views
Copy a SQL Server 2000 database to another box without interrupting the backup chain
I have a small-but-important MS SQL Server 2000 database that I'd like to copy to a development box. I understand that the usual way to do this is to make a copy of a full backup file, and restore ...
1
vote
2answers
258 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 ...
1
vote
1answer
41 views
Can I Set The Value of App_Name() AFTER Login?
I've got an older application that is connecting via ODBC to my database server. I want to discover what the Application Name is inside a stored procedure. I'm not able to set the Application Name ...
2
votes
2answers
58 views
SQL Server 2000 DTS package, filter rows using stored procedure returned date
I know very little about DTS packages in the first place (I'm a programmer not a dba) and have been stuck with the task of filtering rows based on the results of a stored procedure call that returns a ...
2
votes
1answer
58 views
IDENTITY_INSERT seems stuck
I might be forgetting something, but essentially, I'm struggling with IDENTITY_INSERT.
I'm trying to move data between tables, both of which have an identity column (similar schema).
SET ...
5
votes
2answers
79 views
Optimizing IP Range Search?
I have a simple query and table, and I would like to know which indexing is efficient on this kind of table and query.
In my table I have 3 columns
CREATE TABLE mYTable(ipFrom BIGINT, ipto BIGINT, ...
1
vote
1answer
46 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
2answers
49 views
Get the most recently completed step for each SQL job
I'm trying to get a list of jobs and their most recently completed step from the MSDB database. For a single job, this is pretty straight forward, something like:
SELECT TOP 1 j.job_id, j.name, ...
3
votes
2answers
72 views
Installed SQL Server 2000 with wrong collation.. how to correct for entire server instance?
I installed SQL 2000 Developer (yes, old, don't ask) on my laptop ... with the wrong collation. Oops!
It's showing Latin1_General_CI_AS, but it turns out I need to use SQL_Latin1_General_CP1_CI_AS ...
1
vote
3answers
38 views
What is this error about in sql server?
Trying to restore database, getting a dialog in SQL Server Management Studio
You cannot select
backup sets from different databases"
Any idea why I am getting this error?
BTW backup is from ...
0
votes
2answers
31 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 ...
2
votes
2answers
57 views
Is it possible to view the maintenance plans created in SQL Server 2000 in SSMS 2005?
Is it possible to view the maintenance plans created in SQL Server 2000 (also running on the same SQL server 2000) in SQL 2005 Server Manangement Studio? I have the server added in my SSMS, but when I ...
1
vote
2answers
76 views
How to add ansi null and ansi warning in connection string
Using RDO Connection
Connection String
Set RdoVisPay = rdoVISENV.OpenConnection("VISA", 1, False, "DSN=VISA;UID=sa;PWD=sa;APP=Visual Basic;WSID=" & ServerName & ";DATABASE=" & ...
3
votes
1answer
194 views
recover broken msde 2000 8.0 database
i have a msde (mssql) 2000 / v8.0 database that has one corrupted table. Microsoft SQL Server Management Studio Express can see the database STRUCTURE, but not the data. i can see the DATA of the ...
