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

learn more… | top users | synonyms

0
votes
2answers
158 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 ...
0
votes
3answers
18k 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

Figuring out database timezone

Does anybody know of a way to alter a time zone on a SQL database? Is there any tool that could find the objects using the date and time?
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
3answers
2k views

SQL Server Database grew too much too fast

I have an issue with one database. The issue is as follows: The database is being running on SQL Server 2000 Standard for the last 6 years in Full Recovery mode. In the beginning of this summer the ...
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
43 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
150 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
69 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
149 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
644 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
2answers
331 views

Does a SQL Server job run on the server or the local machine?

Does a SQL Server job always run on the server, or will it run in the context of the local machine, similar to a DTS package run from Enterprise Manager on the user's machine? The job in question ...
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
600 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
413 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
113 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
75 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
31 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
167 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
82 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
261 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
420 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
60 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
591 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
72 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
351 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
118 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
245 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
106 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
95 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
364 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
162 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
7 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
22 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
23 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
55 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
45 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
60 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
73 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
130 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
49 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 ...
0
votes
0answers
25 views

SPExecuteSQL;1 keeps executing internally

Having a major issues with this procedure called SP_ExecuteSQL;1. It keeps executing internally in SQL Server 2000 with high utilization of CPU. When I pass its SPID in DBCC inputbuffer it shows as ...
0
votes
0answers
41 views

Facing Error while calling DB2 stored procedure from SQL Server 2000

I am trying to execute the following to call a DB2 stored procedure from SQL Server 2000. DECLARE @ICVR_CLAIM_NBR VARCHAR(19) SET @ICVR_CLAIM_NBR= 'XXXXXXXXXXX' EXEC('call PPSPCOL.X2COVSEL (?)', ...
0
votes
0answers
36 views

SQL Server 2000 - Revert trigger template to original default

In SQL Server Enterprise Manager, in the table list for a database, you can right click on a table, choose 'All Tasks' and then 'Manage Triggers ...' which will open up the following window I had to ...
0
votes
0answers
310 views

SQL Server 2000 Named Instance cannot connect remotely

To facilitate a migration I installed SQL Server 2000 Standard Edition and Service Pack 4 as a named instance on server with an existing instance of SQL Server 2008R2 RTM. The issue I have is ...