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

learn more… | top users | synonyms

1
vote
0answers
80 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
58 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
621 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
1k 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
0answers
203 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
734 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
223 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
4answers
19k 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 ...
0
votes
3answers
2k views

Duration Field in Profiler

I would like to monitor the script which takes more than 25 Sec. When i use filter i am not able to see the duration taken by the script. How can we get the time taken to execute the query. My ...
0
votes
2answers
1k views

Error using sp_trace_create with parameters [duplicate]

I'm running the following SQL on SQL Server 2000: exec sp_trace_create @options = 2, @tracefile = N'h:\\trace.trc', @filecount = 2 and am getting the following error and can't ...
0
votes
1answer
40 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
44 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
2answers
153 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 ...
0
votes
1answer
71 views

How vulnerable is SQL Server 2000?

I know there are still some SQL Server 2000 installs that exist out there. With Microsoft no longer supporting these versions, how can I check to see what vulnerabilities remain unpatched? This ...
0
votes
1answer
152 views

Scheduled copy of large table from SQL Server 2000 to 2008

I have a table on SQL Server 2000 with 10 million records and 20 columns. The table is rebuilt once a day and is essentially a reporting table, not a transactional table. Of the 10 million records, ...
0
votes
2answers
677 views

Syncronization with transformation

I have the following scenario: a database in SQL Server 2012 that must replicate changes in a transactional way to a SQL Server 2000 database. Since the schemas of two databases differ, a ...
0
votes
1answer
2k 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 ...
0
votes
2answers
660 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
1answer
426 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 ...
0
votes
1answer
344 views

GRANT permissions to all tables, views, procedures in SQL Server 2000

I was wondering if there was a fairly efficient way to use T-SQL with SQL Server 2000 syntax to GRANT SELECT, INSERT, UPDATE, DELETE, on all TABLES and VIEWS for a particular database while excluding ...
0
votes
1answer
82 views

Simplifying query by adding Computed Column, performance impact?

The dev team came across the following query (might be incomplete; it's retyped from a screenshot) which had caused slowness: SELECT d.catalogno, d.itemid, SUM(lineamount+taxamount) AS Amount, ...
0
votes
1answer
33 views

SQL Server 2000 Page Splits per second higher han 12 million?

I was reading about index fill factors & performance, and out on a whim I tried the query given by the webpage on the company's production SQL Server 2000 server: SELECT * FROM ...
0
votes
1answer
178 views

SQL Server 2000 : Upgrade from Personal Edition to Enterprise Edition

I've never tried this before but this is what I'm attempting to do : Backup all the databases Copy current master.mdf and master.ldf to another location (for later purpose) Uninstall SQL Server ...
0
votes
1answer
87 views

Upgrade SQL Server 2000 engine

I have SQL Server in which I need to upgrade and restore a .bak file Server 1: Microsoft SQL Server 2000 - 8.00.194 (Intel X86) And by requirements I need it to match Server 2: Microsoft ...
0
votes
1answer
285 views

databasename_indx.ndf file not referenced but can't delete

I have a SQL Server 2000 Express database for a legacy app I'm ditching soon. Until then, I'm at my 2 GB limit. According to sp_helpfile the database has one .mdf (900 MB) and one log file, but the ...
0
votes
1answer
453 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?
0
votes
1answer
61 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?
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
657 views

SQL Server improving queries waiting on PAGEIOLATCH_SH / Memory/CPU

As an 'accidental DBA' of my company, one of my tasks is to identify possible performance problems of our ERP system. For complex reasons, the database back-end has to be SQL Server 2000. From ...
0
votes
1answer
2k views

Support to SQL Server 2000 from Visual Studio 2013(SQL Server 2012)?

I can't access to a database created by SQL Server 2000 from Visual Studio 2013, I asked this before in StackOverflow, but I don't get an useful answer: ...
0
votes
1answer
77 views

how to select rows matching a condition with a default

I have a table id | title | lng | vi_id -------------------------------------------------------- 1 | 'IX#001323' | 1 | 12 2 | 'IX#001323 heb' | ...
0
votes
2answers
386 views

SQL Server 2000 - How to find unused indexes

In SQL Server 2000 - how can we find unused indexes, so that we can drop them.] I have scripts for 2008 but don't know how to do it in SQL Server 2000. Please help. Regards
0
votes
1answer
122 views

SQL Server 2000 Replication

I have a challenge with replication on SQL Server 2000. The replication has full permissions, but still I get this below error. The SQL Server 2000 is installed on the C: Drive, but the database is on ...
0
votes
2answers
260 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
1answer
110 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 ...
0
votes
1answer
1k 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
102 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 ...
0
votes
1answer
368 views

Installing “SQL Server 2000 Client” and “SQL Server 2000 service pack 4” [closed]

Installing "SQL Server 2000 Client" and "SQL Server 2000 service pack 4". I am new to SQL server and want to know if both are different and the exact steps that i need to follow for installation. ...
0
votes
2answers
1k views

DBCC CHECKDB errors migrating from SQL Server 2000 to SQL Server 2008R2

I'm getting integrity issues after I migrate a DB from SQL Server 2000 to SQL Server 2008 R2. I ran a DBCC CHECKDB on the old db, and it returned no issues. Then I FTP-ed the backup file to the new ...
0
votes
1answer
165 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?
0
votes
0answers
11 views

Replication Conflict tables in SQL Server 2000

Due to previous several replications during these years in a database I'm working with, there are several tables with names with this format : *onflict_AllData_[Tablename] which * can be a, b, ... ...
0
votes
0answers
60 views

How to quote database names with spaces when using queryout with bcp?

I'm attempting to use bcp on Microsoft SQL Server 2000 to export a couple of columns from a large database table. The database names contain spaces. Here's an example that works that contains an ...
0
votes
0answers
26 views

Pivot in SQL Server 2000

In my table record contains 'year' as a column that should pivot as table header in SQL Server 2000. Finally I tried these but I couldn't get it to update the table set @columns = @yearspan SET ...
0
votes
0answers
65 views

Instance consuming large amount of disk space

I have an environment that is Microsoft Server 2000 and Microsoft SQL Server 2000. The database has a file size of 112 GB. The total size of the disk is 122GB. For some reason in less than a few ...
0
votes
0answers
53 views

How can I run a SQL Server 2000 database on SQL Server 2005 Express with a different location for files

I am trying to help a client out after a server crash. The temporary replacement server has different drive letters and data file locations. Here are the system details as I understand them: ...
0
votes
0answers
83 views

Connecting from SQL Server 2000 client to SQL Server 2008 Express

How to connect from SQL Server 2000 client in my pc to our SQL Server 2008 express server? I'm using to connect to our SQL Server 2008 with 'servername' using sql server authentication. error: ...
0
votes
1answer
89 views

Application is hanging when database upgraded from SQL Server 2000 to SQL Server 2008 R2

Presently we are working with SQL Server 2000, the database is perfectly working with our software for retail sales counter application developed with VB 6.0. But after upgraded to SQL Server 2008 R2, ...
0
votes
0answers
152 views

can't connect to DB using MS SQL Server 2008 Upgrade Advisor

I'm trying to use MS SQL Server 2008 Upgrade Advisor Analysis Wizard, to connect to a networked MS SQL 2000 database. According to the query select @@ServerName, the instance name contains a hyphen. ...
0
votes
1answer
53 views

migrating legacy databases from SQL Server 2000 via SQL Server 2008 to SQL Server 2012: users and logins

I have some legacy SQL Server 2000 databases to migrate to SQL Server 2012. In my dry run, I have done this: I created empty databases of the same names in SQL Server 2008. Then I backed up the SQL ...