The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
61 views

SQL Server 2000 — Log Shipping reliability?

I've been asked to look into log shipping for SQL Server 2000 (yes, 2000): something in my memory tells me that I looked at this years ago and there were question marks over it's reliability. I'm ...
1
vote
1answer
80 views

How to migrate an SQLServer 2000 database from one machine to another

This January I'm migrating our main SQL Server 2000 based database to a beefier server. Is there any standard procedure or documentation on how to do it? I need to replicate all at the new server ...
1
vote
5answers
118 views

SQL Server connection error (a weird one) (unsolved yet)

SQL Server can be connected from local system but can not be connected from remote system in the network. The error code is 40 from Visual Studio and 1326 when I try to connect to SQL Server from ...
0
votes
1answer
48 views

SQL server 2000 trace Flags

On fixing an issue we are having with our backups I am following instructions where it is telling me to add the Trace Flag -g384. This is all good but I am not sure what this perameter actually does. ...
1
vote
1answer
38 views

Looking for a SQL Server 2000 fix to a problem fixed in 2005

I have been having fits with my application that uses SQL Server and I finally found a description of the problem as a bug fix for SQL Server 2005. http://support.microsoft.com/kb/912732 The only ...
1
vote
5answers
2k views

Best way to improve disk performance (SQL Server 2000)

I am having some disk access issues on a web application. The main load is many concurrent inserts/updates/selects on large tables. It is currently a single 2ru rackmount running SQL Server 2000 and ...
2
votes
1answer
432 views

How to create a shared lock blocking an intent exclusive lock

As I understand it, a SELECT statement will place a shared lock on the rows that it will return. While that SELECT is running, if an UPDATE statement comes along and needs to grab an intent exclusive ...
0
votes
2answers
823 views

Find last access datetime stamp for objects in SQL Server 2000 database

I'm in the planning stage/phase of migrating one of our SQL Server 2000 databases to 2008. Our database holds numerous tables (hundreds) and stored procedures (hundreds). I'm trying to figure out ...
0
votes
2answers
433 views

Connectivity with SQL Server Express 2008 r2 and SQL Server 2000 on same machine

At first glance this may same a duplicate of Installing both SQL Server 2000 and SQL Server 2008 on the same machine, but it is not. I have SQL Server 2000 and SQL Server 2008 R2 installed on the ...
0
votes
1answer
191 views

Allow existing user access to db. SQLSERVER 2000

I restored a db on my SQL 2000 server called R1. I went to add R1 to the user mapping of a user called JUNO. I get an error: User or role 'JUNO' already exists in the current database. So I ran on ...
3
votes
1answer
804 views

Impact on SQL 2000 performance of JDBC selectMethod=cursor

(Posted first on SO, but its not getting any answers there. Cross-posting to reach a larger audience, since it is cross-discipline.) In the process of trying to help out an app dev team with some ...
0
votes
2answers
149 views

Should we backup SQL 2000 with ArcServe SQL agent or backup to file and then backup the file?

We have SQL Server 2000 running on Windows Server 2003. We've recently moved to new hardware. We use ArcServe / Brightstor for backups. On the old server we used the SQL agent. We also have agents for ...
2
votes
2answers
380 views

Benchmark tests for MSSQL 2000 VS MSSQL 2008.. (thinking for upgrade)

How much of a difference will there be (for speed and other benchmark results) for a database about 5 and even 10 GB to move from MSSQL 2000 to MSSQL 2008? It's running on a Windows 2003 VMWare guest ...
1
vote
1answer
301 views

SQL server 2000, replication over WAN

I seem to have big difficulties setting up the first replication ever between two SQL2000 instances. They both run in seperate WAN's (IP with port assigned for SQL-remote) but I have been able to ...
0
votes
1answer
720 views

MSSQL 2005 > Linked Server Connection Fails > MSSQL 2000

At the company I work for, we currently are running 3xSQL 2005 servers and 1xSQL 2000 server. All of the 2005 servers can communicate with each other, however they cannot communicate with the 2000 ...
0
votes
1answer
247 views

Sysobjects issue in sql 2000

Having a problem with a particular table. Was using Kimberly Tripp's script to rebuild indexes based on fragmentation level. The job failed with this error: Msg 2501, Sev 16: Could not find a table ...
2
votes
2answers
380 views

Equivalent of SQL 2005's SQLAgentOperatorRole (msdb ) in SQL 2000?

Can anyone tell me what is the Equivalent of SQL 2005's SQLAgentOperatorRole (msdb ) in SQL 2000? I want to grant a login ability to disable a job in SQL 2000. Thanks in advance....
1
vote
2answers
188 views

Is SQL Server Management Studio capable of managing SQL Server 2000 databases?

I know this is really basic, but I can't find the answer in Google or SF, so I thought I'd better just ask. If I run SQL Server 2008 R2 Management Studio on my PC, can I manage a SQL Server 2000 ...
2
votes
3answers
49 views

Mysterious timeouts in MSSQL 2000

I have a query that has been working fine for ages (2+ years). All of a sudden it went from taking 3 secs to 30+ to execute. The table indexes have minimal fragmentation, but rebuilding the indexes ...
2
votes
2answers
85 views

Moving SQL 2000 to new hardware and O/S. How to copy everything

We're replacing our Windows NT server running SQL 2000 with newer hardware running Windows Server 2003 but still SQL 2000. What is the easiest way to do this? We know how to copy the normal databases ...
0
votes
2answers
104 views

SQL 2000 Backup/Export Process - Can't find SQL 2000 Enterprise Manager, Can't use Mgmt Studio Express

I need to make a backup of a client's SQL 2000 database, however there are a few issues preventing me from doing so using the traditional methods. I've tried using SQL Management Studio Express, but ...
0
votes
1answer
44 views

Do I need to disable access to a publisher database when setting up SQL Server 2000 Transactional Replication?

I have a production database i.e. where there are constant updates and I've configured this to be published to another server using Transactional Replication. When I configure transactional ...
3
votes
2answers
796 views

SQL Server 2000, large transaction log, almost empty, performance issue?

For a company that I have been helping troubleshoot their database. In SQL Server 2000, database is about 120 gig. Something caused the transaction log to grow MUCH larger than normal to over 100 ...
1
vote
1answer
730 views

How do I get SQL Profiler to show statements with column names like 'password'?

I'm profiling a database just now and need to see the UPDATE and INSERT statements being executed on a particular table. However, because the table has a 'Password' column the SQL Profiler is being ...
0
votes
1answer
152 views

MS SQL dts to ssis migration error

I have migrated some DTS packages to SSIS 2005 using "Migration" wizard. When I tried to run it, it fails saying you need a higher version of SSIS even though the destination SSIS server is on ...
1
vote
3answers
689 views

Perfectly reproducable select statement default ordering issue

I've recently been chasing an issue with a client's db... solution found, but impossible to recreate. Essentially, we're doing a Select * from mytable where ArbitraryColumn = 75 Where MyTable has ...
2
votes
2answers
580 views

SQL Server 2000/2005 query list user access

is there a query to list database user access and related source IPs on SQL Server 2000 and 2005? Please note that reporting service is not installed. Thank you all for help.
1
vote
3answers
69 views

Backing Up Transaction Logs to Tape?

I'm about to put my database in Full Recovery Model and start taking transaction log backups. I am taking a full nightly backup to another server and later in the evening this file and many others are ...
1
vote
6answers
65 views

SQL Server 2000 tables

We currently have an SQL Server 2000 database with one table containing data for multiple users. The data is keyed by memberid which is an integer field. The table has a clustered index on memberid. ...
0
votes
2answers
168 views

Can SQL Server 2000 replicate system databases and/or logins?

Can SQL Replication be used to publish SQL Server 2000 system databases to another SQL Server 2000 server, i.e master, model, msdb? If this is not possible, what is the correct strategy for keeping ...
1
vote
1answer
130 views

Search for text within a DTS file

We have a large store of DTS files which I need to search through for a string of text. Is there any utility which will allow me to do this? Many thanks EDIT: Prefer free/open source as I work for ...
1
vote
1answer
188 views

How do I push my initial snapshot to a subscriber server in SQL Server 2000?

I'm configuring Transactional Replication using the Push model. The scenario is: The SQL Servers: SQL01 (publisher) and SQL02 (subscriber) - both running SQL 2000 SP4. Both servers are ...
0
votes
1answer
2k views

IIS Hangs on SQL Connections when running ASP.net applications

We have a database server running SQL 2000 and two web servers hosting ASP.net applications. All three servers are running Windows Server 2003 SP2. Our issue is repeatable after about 2 weeks, IIS ...
1
vote
3answers
5k views

MSSQL 2000 installation error: Setup failed to configure the server. Refer to the server error logs

I'm trying to install MSSQL 2000 on a virtual Windows 2003 instance. However, every time I run the install program, it fails to start the service. This is the error log: 21:46:50 C:\Program ...
2
votes
3answers
664 views

Retrieve MS SQL database or table structure in XML

Is there a way to export the database schema in well formed XML of a MS 2000 SQL Server. I'm looking for just the structure not the data and the more detailed the better. The XML may be used in a ...
3
votes
4answers
1k views

SQL Server Agent Job - Schedule daily except 1 day per month

We need to run a daily job using SQL Server Agent (SQL 2000) but we don't want it to run on the 22nd of each month as there are other processes which only run on that day which will clash. The ...
0
votes
1answer
67 views

Can I run a pull DTS package on SQL 2000 to copy data from SQL 2005 (compatibility level 90) to SQL 2000?

Can we still run our DTS package on SQL 2000 to pull data from a SQL 2005 database with compatibility level set to "SQL Server 2005 (90)" ??
0
votes
2answers
75 views

why does my sql2000 database perform worse in sql2005

We have a sql 2000 database thats about 1.2 gb big and a website pointing at said database. We are looking to upgrade to sql 2005 and are in the process of testing this transition. we took the mdf and ...
5
votes
1answer
3k views

Recover deleted rows from SQL Server transaction log file

I need to recover deleted data from an SQL Server 2000 transaction log file. The Log file is 3.3GB. I tried the usual SQL Log Rescue but it keeps crashing with outOfMemory exception. I also tried it ...
0
votes
1answer
77 views

SQL Server 2000 Client won’t connect

One day instead of connecting to the database my SQL Server Management gave me the following error: "Data Source name not found & no default driver found" Note it had been working for several ...
8
votes
2answers
320 views

Repairing inconsistent pages in database

We have a SQL 2000 DB. The server crashed due to Raid array failure. Now when we run DBCC CHECKDB, we get an error that there are 27 consistency errors in 9 pages. When we run DBCC PAGE on these ...
0
votes
2answers
241 views

Sql server 2000 replication error

Good morning, I have a sql server 2000 machine, with SP4. I have a transactional replication. A keep receving this error message: The process could not execute 'sp_replcmds' on 'servername' the ...
0
votes
2answers
33 views

SQL 2000 Logs disk drive bust

We;ve had a disk go on our SQL server (2000) that contained all the log files, so we replaced the drive (no raid config so data lost) and now when trying to connect to Enterprise manager we cant, just ...
3
votes
1answer
100 views

What replication options exist between SQL Server 2000 and 2005?

We have a business partner that is still on SQL Server 2000, and we would like to replicate a couple databases to one of our SQL Server 2005 instances. The business partner databases that we need to ...
1
vote
4answers
3k views

Problem with MS DTC on SQL2008 win server 2k8 with linked server from sql2000 win server 2k

We have migrated our db from sql2000 win server 2k to sql2008 win server 2k8. We have linked server from sql2000 win server 2k. By our opinion the problem is with DTC and we have made a lot of setting ...
0
votes
2answers
708 views

SQL Server 2000 Transaction Log DelBkUps 3DAYS not working

We have a maintenance plan to do a full backup every night at midnight and a transaction backup every hour. Both have "Delete backups older than 3 days" checked in the wizard Here's the SQL from the ...
0
votes
1answer
3k views

Replication between SQL 2008 & SQL 2000 - Across network (DMZ) - process could not connect to Subscriber

I have 2 servers... OTTO is located on site, and connected to domain It is running SQL 2008. I have created the database, in SQL 2000 compatability mode. WEBDB3 is located in datacenter, not ...
0
votes
2answers
5k views

How to change the default instance of SQL Server?

we have a dev server. First we had SQL 2000 (default instance), when SQL 2005 came out, we installed it as a named instance. Nowadays we barely use the SQL2000 instance, but this is the default. We ...
1
vote
2answers
3k views

SQL Backup - Restoring to different data / log files - Changing file structure…?

I'm trying to restore a BAK of a database we have, onto new, better hardware. Here is a screenshot of the UI in Management Studio http://twitpic.com/wmtr8/full The existing db has an mdf, and ndf ...
1
vote
0answers
2k views

SQL Server 2008 database - Running in 2000 Compatibility mode…?

I have an application that currently runs on SQL 2000, on a server with Windows 2000. The hardware has just about run out of useful life - HD's are almost full, more users than 2gb ram can cope with ...