The tag has no wiki summary.

learn more… | top users | synonyms

23
votes
5answers
46k views

Get a list of SQL Server Agent Jobs

I've got an extensive selection of these to add to a spreadsheet and don't want to go through by hand. What it the T-SQL command(s) to generate a list of SQL Server Agent Jobs?
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 ...
9
votes
14answers
817 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 ...
8
votes
8answers
29k views

SQL Server restore a backup results in an error

I have a database in dev (SQL Server 2005 on Windows Server 2008) that I need to move to prod (SQL Server 2000 on Windows Server 2003). My process is as follows: Login to dev, open SQL Server ...
8
votes
2answers
297 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 ...
7
votes
7answers
4k views

Is there anyway to determine who dropped a table?

A table in the production database has 'mysteriously' disappeared. Does anybody know of any way to diagnose what the heck happened to it? And who did it? Edit 1: This is an internal app, with weak ...
6
votes
4answers
17k views

SQL Server 2Kx: How to move a database to a different partition in the local file system?

SQL Server creates its databases in the system program files directory structure. I want to separate the database files away from the system partition. Assuming the database is already created and ...
5
votes
1answer
2k 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 ...
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 ...
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 ...
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 ...
3
votes
1answer
1k views

SQL Server 2000 - Restoring .MDF Using sp_attach_single_file_db fails with error

Because more than one person was meddling with the database, we have lost our transaction log files and consequently lost the database. Luckily, we have the MDF file still perfectly intact, and we're ...
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 ...
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 ...
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. ...
3
votes
2answers
769 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 ...
3
votes
1answer
269 views

Getting data out of a Suspect database

We had a power outage and one of our SQL 2000 databases is marked as suspect. We have a backup, but it's more than a day old (power outage happened just before the backup was scheduled) and we'd ...
3
votes
1answer
728 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 ...
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 ...
2
votes
5answers
1k views

Portable SQL Server

I need to install SQL Server, however I have a BIG problem with it. I remember when I tried to install it I got error with MSXML and it was not installed because of MSXML and some other component. Is ...
2
votes
2answers
941 views

Does MSSQL 2000 run in VMWare ESX?

Does MSSQL 2000 run in VMware ESX? We are planning on going into a virtualized environment and are wondering if main production database will run in VMware ESX. We cannot upgrade the SQL version.
2
votes
3answers
133 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
1answer
217 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 ...
2
votes
1answer
1k views

How to disable Ad Hoc Distributed Queries on SQL Server 2000

We juste had a security audit that found that, if you get access to our database (SQLInjection for example), you can easily send all the content of the database to a remote SQL Server. The ...
2
votes
2answers
83 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 ...
2
votes
3answers
143 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 ...
2
votes
1answer
136 views

Restore sql server 2000 database to 2008

I am not a DBA. I will be doing this for the first time. So I am not sure what all I am supposed to do? I will be restoring sql server 2000 database to sql server 2008. Are there anywhere step by ...
2
votes
3answers
48 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
564 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.
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 ...
2
votes
3answers
212 views

Backup MS SQL 2000 db from SQL Management Studio 2005 on another server?

The situation: I have an instance of MS SQL 2000 running on one server. On another server I've installed SQL Management Studio Express 2005. I can access the SQL 2000 server from Management Studio. I ...
2
votes
2answers
99 views

Backwards-compatible (to SQL 2000) server version and compatibility version check

I have a script which uses features not present in SQL Server 2000. Specifically, the script creates a stored procedure which uses a data type added in SQL Server 2005. I need to use conditional ...
2
votes
1answer
991 views

Is there a connection history for SQL Server?

Is there a way to find the list of workstation that have connected to my SQL Server (2000) or to one of it's databases over its life time? Even a couple weeks would do for my purposes. Is there a log ...
2
votes
2answers
343 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....
2
votes
3answers
950 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 ...
2
votes
1answer
268 views

SQL Server 2000 HIGH CPU Usage with BusinessObjects reports (unsolvable?)

I have one of those weird questions, those ones that are nearly unsolvable (the only way to really solve them is to throw out the technology and buy new ones). I've had a number of experts (about 10 ...
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 ...
2
votes
1answer
83 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 ...
2
votes
2answers
178 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 ...
2
votes
2answers
620 views

Firehose mode in SQL Server

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

SQL Upgrade Adviser for win2k

I'm trying to upgrade a SQL Server 2000 instance to SQL Server 2008 R2. SQL Server 2000 resides on an old win2k box, and the new SQL instance is being run on a Server 2008 R2 platform. I am attempting ...
2
votes
0answers
880 views

Weird bug when copying from sql server management studio to excel in windows 7

I run a query in SQL management studio (results to grid), then select all results and copy with headers. Then I paste into Excel. The result: two specific records are put together on one row in ...
2
votes
1answer
415 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 ...
2
votes
2answers
362 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 ...
2
votes
3answers
541 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 ...
2
votes
2answers
811 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 ...
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 ...
1
vote
6answers
64 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. ...
1
vote
6answers
1k views

Is it possible to change all users passwords to upper-case

I'm currently migrating some servers from MS sql server 2000 to 2008. Some of the legacy apps are password protected by essentially checking if a user with that name and password exists on the server. ...
1
vote
1answer
48 views

SQL Server database backups storage

This is rather basic question. We do backups of all the databases on the server and size around 20GB every week. All that is scheduled (shrinking,Backing up) We store them on Network drive. Now ...