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

learn more… | top users | synonyms

1
vote
2answers
4k views

How to upgrade a SQL 2000 Database to SQL 2005 - need confirmation?

I need to confirm the process for upgrading a standard SQL 2000 database to SQL 2005. As I understand it, there are at least 2 methods for upgrading. Back\Restore and Detach\Attach DB. In my case, I ...
1
vote
5answers
5k views

How do I restore a SQL Server 2000 database to a SQL Server 2008 instance?

How do I restore a SQL Server 2000 database to a SQL Server 2008 instance?
1
vote
2answers
109 views

Manipulate SQL statement before execution on server

Our databases are on SQL Server 2000. We are migrating to SQL Server 2008 R2. We want to update the compatibility level to 100. But the join operator \*= and =\* are no more supported with that ...
1
vote
3answers
1k 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
vote
2answers
198 views

Empty SQL Server 2000 LDF File

I have a 1 GB .LDF for a test database which I want to shrink right down. I am happy to delete its contents if needed. How can I do this for SQL Server 2000? I have tried the following to no huge ...
1
vote
2answers
89 views

SQL Server 2000 optimzation job hasn't run for a while

Our SQL Server 2000 used to run a Sunday morning 3am job of optimizing the database. Somehow it was turned off and hasn't run in a year. We have noticed slow access to the database. We turned it ...
1
vote
1answer
633 views

Restore SQL Server 2000 Database in use

I need to restore a SQL Server 2000 database to a backup of about 2 days ago. I have just backed it up and have tried to restore it, but it says it is in use. What is the best way to find out who is ...
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 ...
1
vote
2answers
665 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, ...
1
vote
2answers
426 views

Constant values in columns

I have a SQL Server 2000 database used by our ERP system. There are many columns that always have the same value. A table row is really huge, potentially exceeding the maximum row size in SQL Server ...
1
vote
2answers
64 views

Find dates when exactly records changed for user

I need to find the dates when exactly the status really changed. Order should be analysed from Start to end period: Start Period : 11-10-2014 End Period : 21-10-2014 Data: ID, Name, ...
1
vote
3answers
198 views

What is SQL Server 2000 spid -2?

I have a SQL Server 2000 machine that has a pretty big database on it - almost a terabyte in size. There's a particular table that has been a source of some production issues and any attempt to try ...
1
vote
1answer
365 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 - ...
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
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=" & ...
1
vote
2answers
2k 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 ...
1
vote
2answers
958 views

SQL Server 2000: Can't DROP VIEW?

I have SQL Server 2000. I want to clean it by dropping obsolete and unused objects. One of the views causes me an error. I try to give more information but I still have no clue what the cause is. ...
1
vote
1answer
301 views

Running a sql server Trace of 1 GB using sqlcmd

I am load testing two sql server instances. I have a trace file from sql server 2000 database with a file size of little less than 1 GB. I am running this using the sqlcmd utility and it is been ...
1
vote
2answers
308 views

how to generate scripts for database objects specific to an application?

There was a application which, earlier, pointed to a database. It used a specific set of tables. Those tables had triggers, constraints, etc. There were also stored procs which insert data into these ...
1
vote
1answer
636 views

Subqueries are not allowed in this context. Only scalar expressions are allowed

My customer is running MS SQL Server 2000. I completed a project, but I failed to realize that MS SQL Server 2000 will not allow a select inside insert into values thus giving the error: Subqueries ...
1
vote
2answers
891 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 ...
1
vote
2answers
422 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, ...
1
vote
3answers
301 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 ...
1
vote
1answer
76 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 ...
1
vote
1answer
102 views

Should I Avoid Repeated References to Aggregate Columns in a View?

So I'm wanting to summarize the balance of the accounts in my business application. My (simplified for our purposes) data model looks like: --Main account table that holds the single accounts create ...
1
vote
1answer
154 views

SQL Server : database recovery from snapshot files

We have completely lost our SQL Server 2000 database in an accident. The only thing left is a snapshot folder which contains bunch of .sch, .idx and .bcp files. The sch and idx files have a clear ...
1
vote
2answers
96 views

What permission do I need for viewing… all current user permissions?

I'm maintaining an application that runs with SQL Server 8.0.760 SP3. When I try to "see" the permissions of the current user I'm logged with, I do this: SELECT * FROM fn_my_permissions(NULL, ...
1
vote
1answer
75 views

DBCC sqlperf(waitstats) contains signal wait time longer than last time waitstats was cleared

I'm trying to troubleshoot some performance problems on our SQL2000 production server. I ran DBCC SQLPERF(waitstats) and noticed the stats hasn't been cleared in a long time. So I cleared them and ...
1
vote
1answer
434 views

Backup Database (SQL 2000 Compatibility) on SQL Server 2005 with CHECKSUM, but Page Verification TORN_PAGES Detection

I am trying to backup a 250GB database on SQL Server 2005 running in SQL 2000 compatibility mode. The page verification is set to TORN_PAGES detection. So, far the backup has been corrupted when we ...
1
vote
1answer
118 views

Number of times a table is read, written to and updated

Is there a way I can find out the number of times a table is read, updated, added to or has had rows deleted during a trace? I am creating the trace in SQL using sp_trace_setstatus, not using the Sql ...
1
vote
1answer
397 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
264 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 ...
1
vote
1answer
102 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. ...
1
vote
2answers
331 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
2k views

Heterogeneous queries error using stored procedure

Stored procedure ALTER PROCEDURE Proc_DayShift AS insert into #Punching_History SELECT * FROM SERVER2.MARS.DBO.TABLE1 GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO SET ANSI_WARNINGS OFF ...
1
vote
1answer
66 views

tsql to know when a database was last shrunk

In SQL 2000, 2005 and 2008, how can I know when databases were last shrunk on a MS SQL server? I want to do this using TSQL. Regards Manjot
1
vote
1answer
388 views

Consistency errors in SQL Server 2000

I have SQL Server 2000 and ever since upgrading from SP2 to SP4 random errors began happening. Mostly overflow errors, sometimes in SqlDateTime and sometimes in data type numeric. For example, ...
1
vote
1answer
243 views

SQL 2000: change collation of model database only- not master

One of our production SQL 2000 server has windows collation for master and msdb but SQl collation for model and tempdb. We are trying to have the same setup on a test environment which at the moment ...
1
vote
1answer
1k views

“Request to run job dbxxxxx refused” error in merge replication

I'm doing merge replication whole of my database but when I create the subscription I encounter this error: SQLServerAgent Error: Request to run job DBXX-XX--bazresiostani2-2 (from User sa) refused ...
1
vote
1answer
697 views

ActiveX script throwing runtime error inside DTS package

I am a DBA. We have migrated SQL 2000 databases + DTS packages to SQL 2008. One of the DTS packages runs an ActiveX script to open an Excel file (which has runs macros when you open it). Coding ...
1
vote
0answers
27 views

How to find the number of transactions per day or per hour in a SQL 2000 database

I am trying to find a query that I can run in order to find the number of transactions per day or per hour in a SQL 2000 database. The purpose is to get the number of hits on the database. I have ...
1
vote
0answers
43 views

Sql agent job step to Rename a file in SQL Server 2000 fails with error “ file being used by another process”

We have a SQL agent job configured on Sql Server 2000, which has an initial step of renaming a backupfile coming from a another server (SQl Server 2000) Say coming from \A\B\X.dat to X_back.dat. till ...
1
vote
0answers
39 views

Alter column text to varchar SQL Server 2000

How can I alter a column of type text in a SQL Server 2000 table, and change it to varchar? I tried with ALTER TABLE myTable ALTER COLUMN myColumn varchar(8000) NULL GO and the error is No se ...
1
vote
0answers
496 views

Unable to insert into or update table

A have the following table in a SQL Server 2000 database (service pack 2), with about 600,000 rows: Id [int, primary key] Form [int] Element [int] Data [char(8000)] MoreData [varchar(8000)] ...
1
vote
0answers
986 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 ...
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 ...
1
vote
1answer
657 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 ...
1
vote
1answer
215 views

Can't find location of undo *.tuf file

I run SQL Server 2000. Database is in standby mode. I have multiple files with MyDb.tuf name on a different drives. How may I know which one is in use?
1
vote
0answers
513 views

DBCC CheckDB Consistency error on an empty table [duplicate]

I restored a DB from SQL Server 2000. I ran DBCC CHECKDB on SQL Server 2000, and it did not report any errors. What could be the reason behind a DBCC CHECKDB reporting a consistency error on a empty ...
0
votes
2answers
146 views

Backup and truncate LDF with xp_sqlmaint

A job is backing up an LDF with the following command: EXECUTE master.dbo.xp_sqlmaint N'-PlanID <the id> -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog "\\server\sqlbak$" -DelBkUps 6HOURS ...