The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
187 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
1k 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 ...
0
votes
2answers
71 views

SQL 2000 and group names

I have a SQL 2000 server which has databases, under user section of the database object, I have some NT 4.0 groups. These groups were migrated over to Active Directory some time ago using ADMT with ...
2
votes
3answers
951 views

Migrating SQL server 2000 database to SQL server 2005

Can any one suggest variou ways of migrating a database from SQL server 2000 to 2005. How do I make sure all constraints, primary keys and indexes are preserved. Is there any migration tool that ...
0
votes
1answer
66 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)" ??
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 ...
0
votes
2answers
240 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 ...
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 ...
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 ...
2
votes
2answers
1k views

Re-assigning / changing the Primary Log File - SQL 2000

I've got a large db (called Navision4) which currently has 2 log files: Navision4_Log Navision4_Log3 There was a log called Navision4_Log2, but i managed to remove this. Navision4_Log is located on ...
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 ...
1
vote
8answers
3k views

Need a resource that lists WMI perfmon classes

Does anyone have links to resources that list perfmon classes that are called by the WMI Query Language? I have some monitoring software that can pull data via WMI but I have to enter a query in WMI ...
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 ...
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 ...
2
votes
2answers
183 views

SQL Server 2000 Encryption Certificates

I am trying to import a new certificate because our old one is going to expire very soon. The certificate is ok and valid and works for IIS. Unfortunately SQL Server won't startup with Encryption ...
1
vote
6answers
251 views

SQL Server 2000 High Availability

How do you implement high availability on SQL Server 2000? Are there any 3rd party tools out there or any other ideas?
0
votes
2answers
444 views

SQL 2000 DB problem : I/O error (torn page) detected during read at offset

I got this error : I/O error (torn page) detected during read at offset 0x0000024afe4000 in file for a user database. Using the first googled method, i set the database from master..sysdatabases ...
0
votes
1answer
89 views

SQL Server 2000 Backups Not Writing to Local Disk

I have several databases on a server. This is the only database backup that fails. It fails from maintenance plans (full backup and transaction log backups) It fails from T-SQL BACKUP commands. ...
0
votes
5answers
569 views

Improvement (not new) Features Between SQL Server 2005 and 2008

Here are the givens: you are going to want to scream about this question this is an Oracle shop and will continue to be all current environments are MSSQL 2000 Standard Edition the answer(s) will ...
0
votes
1answer
169 views

Object definition in MS SQL 2000

I was looking for a way to generate object definition (in my case stored procedure defintion) in SQL 2000 like I can get in SQL 2005 : select definition from sys.all_sql_modules.
0
votes
1answer
72 views

Altering a SQL 2000 table that is replicated

I have a database that is published, and a seperate server subscribes to this publication. We are using Transactional Replication (as far as I can tell) I need to alter a column on ServerA (the ...
0
votes
2answers
156 views

Sql 2000 and AWE

I have a weird problem. I enabled AWE on a Sql 2000 sitting on a Windows 2003 server. The server has 20 gigs of memory but when i enable AWE sql process is showing as having only 128 MB. From perfmon ...
0
votes
3answers
67 views

SSQL Server 2000 Processes Peak

our SQL Server 2000 sometimes gets more than 600 processes opened (not all active though). When we search with sp_who, and we have noticed that when the server peaks over 800 processes, it starts to ...
0
votes
3answers
831 views

Could not find database ID 18

I'm setting up a program called celcat timetabler www.celcat.com which is a timetabling application that needs a new database for each year (I know don't ask). I have done this in the past, ...
4
votes
2answers
132 views

Virtualisation and SQL server

The sysadmins where I work are looking to re-organise our servers and they have suggested that we put the main production SQL DB on a virtualised server. Is there anything they need to consider when ...
1
vote
3answers
464 views

SQL Server Disk Write Performance

This question is from a developer, so it might be a simpleminded. We have a dev and prod sqlservers (2000) and I suspect the disk write times on the Prod server are quite slow. I've done the ...
9
votes
14answers
848 views

What Are The Reasons to Still Use SQL Server 2000?

From the questions on StackOverflow and elsewhere, I notice that there are still people using SQL Server 2000. To be honest, the greatest effect on me is that I have to remember how we used to do ...
1
vote
2answers
355 views

Why can't I access stored procedures on a linked MSDE 8.x server?

I am trying to execute a stored procedure on a linked MSDE 8.x server by running the following SQL against the parent SQL Server 2000 instance... DECLARE @RC int EXECUTE @RC = ...
0
votes
2answers
158 views

Monitoring replication using System Monitor

I have an MS SQL 2000 server that uses transactional replication and a request to user System Monitor and check if replication is doing ok and not affecting performance of the server. Any tips on ...
2
votes
3answers
135 views

What tools do you recommend for getting data out of SQLServer 2000 databases?

This organization has data in various places including MySQL 5 databases and SQLServer 2000 (developer edition) on Win2k Server. For the data in MySQL I have used PHPMyAdmin, mysqldump, and so on to ...
2
votes
5answers
1k views

How to install SQL Server 2000, SQL Server 2005 and SQL Server 2008 on a single machine

I'm in the process of migrating development databases from an old (soon to be decommissioned) database server to a VMWare-hosted virtual machine running Windows 2008 x64. The old server runs SQL ...
3
votes
2answers
1k views

Skip log backup if full backup is running

On some of my SQL2000 servers, I have occasional blocking and weird conflicts between our full backup and log backup jobs. Based on The answers to this SF question, I need to figure out how to prevent ...
2
votes
1answer
86 views

What causes inconsistent SQL 2K backups?

I take weekly full backups of a SQL 2000 database via vanilla Enterprise Manager. The problem happened when I tried to restore the database. I learn that it was not up-to-date as it was pointing ...
3
votes
1answer
157 views

Smarter SQL 2000 and 2005 maintenance plans?

Should SQL 2000 and 2005 maintenance plans be resilient to a database being detached or offlined? I detached / offlined a few databases, and now the maintenance plans are failing in their entirity ...
1
vote
4answers
381 views

Encrypting a column in SQL Server 2000 database

I've been tasked with encrypting several years worth of sensitive data (don't ask) stored in a SQL Server 2000 Database. I need to encrypt both historical data and come up with a process to encrypt ...
1
vote
3answers
488 views

Verify jobs running on an SQL 2000 database

I have a stored procedure that is being executed by an unknown job. So I'm trying to figure out where the data is stored in SQL 2000 that shows which jobs belong to which database. The reason is that ...
1
vote
2answers
451 views

How do I enable e-mail alerts in SQLServer?

I'm trying to enable e-mail alerts for an operator in SQL Server (2000). When I try to test the e-mail, I get the following message: Error 22022: SQLServerAgent Error: The SQLServerAgent mail ...
2
votes
2answers
827 views

SQL 2000 - WAITSTATS: CXPACKET query

Platform: SQL 2000 Enterprise with SP4, running on Windows 2003 Enterprise, 8 cores, 8GB RAM, and internal (!) storage. Databases are roughly 100GB in total. Scenario: The waitstats are heavily ...
4
votes
4answers
1k views

SQL 2000 Replication error - The subscription(s) have been marked inactive and must be reinitialized

We have a largish database (350GB) which is replicated to a subscriber which is georaphically in a different location. Unfortunateley we have a slow connection between the two sites. Today we're ...
1
vote
2answers
604 views

Security effects of granting guest access to a database

I'm doing a compare of my development server with production and find one has this: EXEC sp_grantdbaccess N'guest' How would anyone take advantage of the guest user in a connection string? It ...
1
vote
1answer
387 views

Is there an undocumented way to reinitialize a replication subscription via transact-sql in SQL Server 2000

Is there an undocumented way to reinitialize a replication subscription via transact-sql in SQL Server 2000, or do you have to use Enterprise Manager or SQL-DMO as mentioned in SQL Server Books ...
2
votes
2answers
671 views

Firehose mode in SQL Server

What is it and how can it stop it cancelling my updates from Enterprise Manager?
2
votes
3answers
144 views

Is it destructive to use SQL Server Management Studio to modify properties on an MSSQL 2000 database?

We have a few databases that are stuck in legacy mode at SQL Server 2000. I commonly use SQL Server Management Studio from SQL Server 2005 to query the data in these dbs from my desktop, but have ...
9
votes
6answers
10k views

Reclaiming memory from SQL Server

I have an SQL Server instance who's memory usage gradually grows until windows will give it no more. It seems logical that the occasional big query result would cause the instance to grow. Is there a ...
2
votes
1answer
223 views

Start SQL 2000 without loading all databases?

Is there a way to start a SQL 2000 instance without loading one specific database? We've got a database that is crashing the server at a certain point during the db recovery process, and we're going ...
3
votes
3answers
1k views

Identifying “Lock Timeout” errors on SQL Server 2000

Our ERP software uses a SQL Server 2000 database. When we run a specific task on the software that used to take few seconds, a 300 seconds delay happens and SQL Server returns the error "Lock Timeout. ...