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

learn more… | top users | synonyms

3
votes
4answers
2k views

tempdb in sql server

Using SQL Server 2000, I am getting the following error. The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space." How to solve it? I ...
3
votes
1answer
946 views

Using (NOLOCK) in a READ COMMITTED transaction block

We're using SQL Server 2000. I'm wondering what the risks are if we use a NOLOCK hint within a READ COMMITTED transaction block, for example: SET TRANSACTION ISOLATION LEVEL READ COMMITTED GO BEGIN ...
3
votes
1answer
1k views

SQL 2000 Maintenance Scripts

Hi I've stumbled into the administration of a Legacy SQL 2000 server that has had next to no maintenance for the past 8 years (and is very slow). As I have only been doing DBA / PT for the past 2 ...
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 ...
3
votes
2answers
1k 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 ...
3
votes
2answers
709 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 ...
3
votes
1answer
860 views

Rebuild or Reorganize indexes based on fragmentation

I am using an Index Defrag Script, which provides a nice way to rebuid or reorganize indexes based on fragmentation percentages. I like to rebuild my database indexes if their fragmentation is over ...
3
votes
2answers
1k views

xp_sendmail: failed with mail error 0x80004005

when I run xp_sendmail exec master.dbo.xp_sendmail @recipients='me@hotmail.com', @subject='terrrible thing happened', @message='test'` I am getting an error Msg 18025, Level 16, State 1, ...
3
votes
1answer
3k 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)) ...
3
votes
1answer
279 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
831 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 : ...
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 ...
3
votes
1answer
1k 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). ...
3
votes
1answer
421 views

Error moving SQL Server 2000 to SQL Server 2005 NOLOCK Error

I need to move a database from the SQL Server 2000 (32 bit) to SQL Server 2005.But,When I attacted my database to SQL Server 2005,it's gives me error.(NOLOCK error) Also , After I running dbcc check ...
3
votes
0answers
63 views

Are there any outstanding critical security issues for Sql Server 2000?

Are there any outstanding (unpatched) security issues for Sql Server 2000? This isn't really for me: I moved on from Sql Server 2000 long ago. However, when answering questions here and (more likely) ...
3
votes
0answers
507 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
3answers
166 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 ...
2
votes
4answers
2k views

How do you change the location of the data files in SQL Server 2000?

I have an old SQL Server 2000 machine in a clustered environment. The data files are on Disk S: which is running out of space. I have another Disk B: in the same disk array which has lot of space. I ...
2
votes
2answers
1k 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 ...
2
votes
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
183 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 ...
2
votes
1answer
1k views

Table Variables - Scope Error - Must declare the variable 'X'

This is my first post and not sure how to fix this auto format draft? Using SQL Server 2000. The table variable that is giving me this one error is '@SBLH' The following is the multi-select function ...
2
votes
1answer
426 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 ...
2
votes
1answer
2k views

SQL Server Migration restore backup vs copy data and log files

Hey guys, I'm tasked with doing a SQL Server 2000 to 2005 migration. I will be doing a side-by-side migration. I've read from a few different sources that I can either: perform a backup of the ...
2
votes
1answer
92 views

Forums about getting SQL Server 2000 Administration help?

What I'm trying to accomplish is that I need to migrate the SQL Server 2000 installation into a SQL Server 2008 installation, and I would like to say that I am afraid that after this operation I will ...
2
votes
1answer
379 views

How to determine the name of a process that caused a trigger to fire

Short Version: Does anyone know of a way --inside a SQL 2000 trigger-- of detecting which process modified the data, and exiting the trigger if a particular process is detected? Long Version I have a ...
2
votes
1answer
230 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 ...
2
votes
2answers
486 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 ...
2
votes
1answer
81 views

SQL Server 2000 query error

When I attempt to run on the SQL Server 2000 to a query which was developed for SQL Server 2008, I receive the following the error. ambiguous column name SucNo Here is my query: SELECT ...
2
votes
1answer
2k views

SQL Server 2000 to SQL Server 2008 linked server issue

Here's my scenario: I've got a linked server going from a SQL Server 2000 machine to a SQL Server 2008 machine. To aid in moving databases with a minimum of config changes, most of our connections ...
2
votes
1answer
562 views

Changing SQL Server 2000 usernames

We're running a SQL Server 2000 instance with users tied to Windows accounts. Many of the usernames have spaces in them and that is causing us some problems now. We would like to be able to rename ...
2
votes
1answer
67 views

Migrating SQL Server 2000 to 2012, getting old versions of Views (edit: offender SQL Server 2008 R2)

I'm migrating an ancient SQL Server 2000 database to 2012 (with a quick pass through 2008 R2 since 2012 is not compatible with 2000). The DB contains hundreds of views and stored procedures, and in my ...
2
votes
2answers
383 views

Database Last Usage

Is there a way to find out when a database was last accessed on SQL Server 2000? By this I mean, had a table read, a SPROC called etc... I have a list of databases and I am trying to find out which ...
2
votes
1answer
912 views

Sql 2000 attach Error 5172

When I attach a database file from SQL Server 2000 Standard Edition to SQL Server 2000 Database on another machine , I am receive the following error. "Error 5172: The heather for file 'D:...' is ...
2
votes
2answers
303 views

Change SQL Server 2000 from Active/Active to Active/Passive

I know it's cringe-worthy to use this term, but I have a SQL Server 2000 cluster with one clusetered instance running on it with multiple resources running on one of the two servers in the cluster all ...
2
votes
1answer
393 views

SQL Server Linked Server error and Query Problem

I have two servers running SQL Server 2000 and SQL Server 2005. There is a database A,B in SQL Server 2000. Similarly I have the same in A,B in SQL Server 2005. A,B are name of the database. I have a ...
2
votes
1answer
206 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. ...
2
votes
1answer
4k 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 ...
2
votes
1answer
988 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 ...
2
votes
1answer
399 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 ...
2
votes
2answers
415 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
2answers
595 views

Table not shown up on Linked Server

I have a machine which have 2 SQLServer instances WINXP-PRO\SQLSERVER2000 (SQL Server 2000) WINXP-PRO\SQLEXPRESS (SQL Server 2005 Express Edition). In \SQLEXPRESS, I have database wavinet2 and ...
2
votes
2answers
193 views

strange behavior with Turkish language setting

I have database with Collation Arabic_CI_AS when I have windows with English settings I can do select Column from Table where Column= 'A' and can do select column from table where column= 'A' ...
2
votes
1answer
610 views

SQL Server 2000 Enterprise Manager - “Navigation to the webpage was canceled” error when trying to design a table

While working in SQL Server 2000 Enterprise Manager on a remote server today, I wanted to look at a table's columns, so I found the table, right-clicked on it and selected "Design Table". Instead ...
2
votes
1answer
39 views

Dump all Views of multiple databases in SQL Server

I need to export the views from multiple databases of an older server. (Essentially, to generate a list of views using a particular piece of SQL Server) The fastest way I've found thus far is to ...
2
votes
0answers
137 views

How do I pass a parameter in a stored procedure to call a DTS package

I have created a DTS package which fetches data from a text file into a database table. I want to pass the file name dynamically from which it fetches data. Can I pass the filename dynamically?
2
votes
0answers
128 views

Identity in a view treated as ordinary int - migrating from SQL Server 2000 to 2012

I'm migrating a very old platform from a SQL Server 2000 backend and MS Access 2003 as its frontend to SQL Server 2012 backend and MS Access 2010 as the frontend. This obviously means a bit of ...
2
votes
0answers
53 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
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 ...