1
vote
1answer
72 views

Password case sensitivity when upgrading from SQL Server 2000 to 2005

Anyone please help! Today is 3rd day that I'm banging my hand to solve this problem. So the situation is, I've inherited a project which worked on SQL Server 2000, later client decided to upgrade the ...
0
votes
1answer
40 views

SQL Reporting service unable to start after restoring on new hardware

I have a SQL server that the hardware is failing. As a solution we restored the image of the server on a multicore (more less new) server. The problem is that SQL 2000 cannot be started if number of ...
0
votes
1answer
73 views

Setup was unable to validate logged in user

I'm trying to upgrade SQL Server 2000 to SP4, so I can upgrade it to 2008 later, but I'm getting this error. I tried with windows login that have administrator privileges, and with sa password as ...
-1
votes
1answer
31 views

Problems when connecting to a SQL Server 2000 when the name has a trailing space [closed]

We have two application servers that a configured quite similarly, however there is a discrepancy between them when they attempt to connect to a server name with a space appended to the end. So, for ...
0
votes
1answer
844 views

get a sql server 2000 database out of emergency mode

there is a db in emergency mode,which i was told to make it "normal". in the enterprise manager i can not see any objects(like tables, users and stuff). in the guy's computer, i connect to the server ...
0
votes
2answers
273 views

Killing a cross server SELECT query has lead to an indefinite KILLED/ROLLBACK process. What's going on here?

A long running query was being run on a SQL Server 2005 database which referenced tables on a SQL Server 2000 database. Both instances of SQL Server are running on the same machine. It was only a ...
0
votes
1answer
19 views

SQL Server: how do I know if I have lost or corrupt data after an automatic recovery?

My SQL Server 2000 logs show that the server performed an automatic recovery on several of our databases. The logs do not mention any errors found. Could I have corrupt or lost data?
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 ...
3
votes
1answer
271 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
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 ...
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 ...
0
votes
2answers
145 views

SQl 2005-2008 vs. SQL 2000 maintenance

At my company we've been using SQL Server for quite a while and have followed the recommended upgrade path. I've noticed that over the last couple of years I'm spending way more time rebuilding ...
1
vote
2answers
330 views

MS SQL Server 2000 IPv6

Does anyone know if SQL Server 2000 supports IPv6? I did some googling around, but I'm not finding any documentation on it.
1
vote
2answers
267 views

Transaction log: Truncate vs. backup

I have a SAP ECC instance which runs on SQL Server 2000. The database is set up with the Full recovery model, but a transaction log backup is never done (not my choice). Instead, a full backup is ...
2
votes
1answer
1k 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 ...
1
vote
5answers
107 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
45 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
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 ...
3
votes
1answer
745 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 ...
1
vote
1answer
287 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
690 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 ...
1
vote
2answers
182 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
2answers
84 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
42 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
775 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
666 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 ...
1
vote
3answers
68 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
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. ...
0
votes
2answers
164 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
184 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 ...
1
vote
3answers
4k 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
566 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 ...
8
votes
2answers
303 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
236 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
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
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 ...
0
votes
2answers
431 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
2answers
327 views

Sql 2000 Connect From Domain PC to WorkGroup PC using Windows Authentication

Sql 2000 - I am trying to connect from a PC w/ client tools that is on a domain, to a Sql Server 2000 box that is NOT on the domain using Windows Authentication. I thought I had done this in the ...
0
votes
1answer
82 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
1answer
1k views

Installing both SQL 2000 and SQL 2008 on the same machine

Is it possible to install BOTH 2000 and 2008 on the same machine (and have them as different instances) Ideally, I want the 2008 to be default instance, with 2000 named "legacy" or something... We ...
1
vote
1answer
99 views

SQL Server 2000 restore error

i'm trying to do point in time restore and following error occurs... and database goes into xxxxx(loading) state... Backup set cannot be applied because it is on a recovery path inconsistent with ...
0
votes
1answer
68 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 ...
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
3answers
102 views

Top queryes in SQL Server 2000

I'm looking for a way to identify top resource consuming queries in SQL Server 2000. Is thre a way to do that other than Sql profiler or a third party monitoring tool like Quest?