This tag is specifically for the 2000 version of Microsoft SQL Server

learn more… | top users | synonyms

2
votes
1answer
189 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. ...
0
votes
1answer
974 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
97 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 ...
3
votes
1answer
778 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
3answers
158 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
2answers
479 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
0answers
105 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 ...
0
votes
3answers
16k 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 ...
9
votes
3answers
6k views

Can I connect to a SQL Server 2000 instance from SQL Server Management Studio 2012?

I would like to update my development machine to SQL Server 2012 but I still manage some (very old) SQL Server 2000 machines. Wil my 2012 SSMS be able to connect to those SQL Server 2000 machines? ...
2
votes
0answers
80 views

Optimizations for new SQL Server 2000 database that will act as email queue AND API database

Due to limitations put on me I've got to put my outgoing Email Queue in the same database as my customer information. What are some optimizations I can make, specifically to the Email portion that ...
1
vote
1answer
1k views

How to truncate all tables with a specific name in all databases

I want to delete all tables named error_log in all of my databases that have such a table. truncate table error_log I am using SQL Server 2000.
1
vote
1answer
202 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 ...
3
votes
1answer
338 views

Can sql server 2000 and 2012 coexist on the same server?

I see that 2005/2008/2012 can all coexist but can't find anything on 2000 with 2012.
2
votes
0answers
406 views

DTS error when a parameter is added to an Execute SQL Task

I have an Execute SQL Task that is (hopefully) going to receive a global variable called startDate, which is set to a Date type. A shortened version of the code looks like this: DECLARE @startDate ...
3
votes
0answers
333 views

How unsafe is it to change the data source of repl_distributor on a publisher

I have a long story that I will condense to a few bullet points that leads up to my question Reporting Server (SQL 2008) is distributor/subscriber cluster for a SQL 2000 Transactional Publication ...
5
votes
2answers
974 views

Log Reader replication agents are constantly restarting

I am recreating (push) transactional replication from a SQL 2000 instance to a SQL 2008 instance which I had to break in order to do a db migration. The 2008 instance is both the distributor and a ...
2
votes
1answer
3k views

Do you set an index on JOIN clauses or where clauses, or both?

Say my query looks like: SELECT t1, t2 FROM t1 LEFT JOIN t2 ON (t1.id = t2.id AND t2.userid = @userid) WHERE t1.enabled = 1 AND t1.startDate <= ??? AND (t1.counter = -1 OR ...
13
votes
1answer
923 views

Are there reasons why I should not set my db owner to [sa]?

Yesterday I asked this question regarding changing the dbo of multiple databases that I have. The change makes sense, but I want to be clear. Is there any, good reason or circumstance why I should ...
2
votes
1answer
220 views

Active Directory domain being shutdown— Do I have to update my DBO accounts?

I manage a SQL Server machine (with SQL Server 2000 and 2005 installed) that was first created on an Active Directory domain that we are transitioning away from and are about to shut down. All of my ...
4
votes
1answer
439 views

hostname incorrect in sysprocesses

I'm running SQL Server 2000. While doing some profiling to trace activity, I noticed some hostnames showing up that were mysterious -- names that shouldn't exist on the network anymore. I got the MAC ...
4
votes
1answer
899 views

Where is this mystery trace going (SQL Server 2000)?

We had a sudden disk usage explosion this morning and the SQL monitor has no useful query information. I decided to check on any potential traces that could have captured something. SELECT * FROM :: ...
3
votes
1answer
1k views

Script to Restore/Create SQL Server 2000 Database from Another Database's Backup

I'm trying to create a database, NewClientDB, by restoring another database's, OldClientDB, backup, d:...oldclientdb.bak. I've always done this via SQL 2000 Enterprise Manager, but the GUI keeps ...
2
votes
1answer
809 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 ...
7
votes
1answer
728 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 ...
0
votes
1answer
92 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 ...
1
vote
2answers
325 views

Explicitly update a table after sp_tableoption “text in row” advices wanted

I have an extremely slow sql server 2000 DB with 8GB, and the cause of this is the 3 ntext columns which are in the more queried table. Table has indexes set and also the full-text ssearch index set ...
1
vote
1answer
620 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 ...
13
votes
3answers
3k views

Should I migrate data using detach/copy/attach or through backup-restore-replay?

I am about to embark on migrating database files to a new SAN (from an old SAN) abd I have a couple of options to implement this. (1) It was suggested that I look into the level of effort of restoring ...
5
votes
2answers
139 views

querying a table of events for reporting

The background (masking a real-world problem behind a word problem) Farmer Brown has a peach orchard in California and ships hundreds of thousands of peaches all across the country. When a shipment ...
1
vote
2answers
1k views

Trouble with Alerts and Notifications on SQL Server 2000

I'm trying to set up alerts and notifications in SQL Server 2000, but they are not working. I'm testing them for Agent scheduled jobs, and I get a note saying: NOTE: Failed to notify ...
2
votes
1answer
384 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 ...
2
votes
1answer
104 views

Point in time database restore

I am trying to restore my database using point in time using .bak file. I selected the back from using the from device option. File is shown its type is full as i give the some back data and time. The ...
1
vote
2answers
630 views

Way to update many (>3000) records with unique data, using a character limited web form

Okay, as you can probably tell from the last part of the title, this is a non-ideal situation. I'm using a piece of industry-specific web-interface software that I guarantee no one has ever heard of, ...
6
votes
1answer
338 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 ...
5
votes
1answer
409 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 ...
8
votes
3answers
12k 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
1answer
649 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
405 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
365 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
512 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
982 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
410 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
1k 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
289 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
146 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
425 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
1k 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
1k 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 ...
0
votes
1answer
2k 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
398 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 ...