The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
33 views

Migrating SQL Server 2000 from Physical to Virtual

My team will be tasked with a Physical-to-Virtual migration of SQL Server 2000. The main requirement will be: Minimization of downtime and minimization of impact on operation. The action plan is as ...
0
votes
0answers
25 views

SQL Server 2000: Monitor replication

starting with (Microsoft) SQL Server 2005, there are stored procedures available to monitor replication (http://www.g-productions.nl/index.php?name=sp_replmonitorhelppublication) But as we are a bit ...
1
vote
1answer
156 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 ...
2
votes
0answers
22 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 ...
0
votes
1answer
78 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
75 views

Recover sql server 2000 sa password

I had forgotten my SQL server 2000 sa username password and now i am not able to connect to it. previously i had disabled windows authentication and had only username sa. Now I ant to recover / ...
0
votes
1answer
93 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 ...
0
votes
1answer
40 views

Distinguish between multiple SQL Server instances

In Task Manager I see two instances of sqlserver.exe. One is consuming a significant number of resources, so I'd like to attempt to harness it in a bit. How do I determine which database this ...
0
votes
1answer
289 views

How can i find what's using the RAM in the server?

I am dealing with 32bit Windows 2003 server which was once a physical box, but now is virtualized in vmware. There are two SQL Server instances running. One is 2000 Standard, another is 2008 R2 ...
0
votes
1answer
99 views

Upgrading SQL Server 2000 to 2012

please is there any checklist available for upgrading SQL server 2000 to 2012? What is your experience with performing this? Could be the upgrade performed directly at all, or will I need to go ...
-1
votes
1answer
321 views

Generate sql script of a table schema in SQL 2000 through script

I wrote some scripts for correcting my old sql 2000 db schema compared to new sql 2000 db. This is done through a loop operations. First check if any table not found in my old db, then running a table ...
2
votes
0answers
1k 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 ...
0
votes
1answer
61 views

SQL Server 2000 on Windows 2008 Logon Account

I have managed to install SQL2000 on Windows 2008 (Fun!) but have a small issue I cannot figure out. When starting the MSSQL$2000 service with a domain account, the service fails to start reporting: ...
-1
votes
1answer
32 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
218 views

SQL Server 2000 unable to apply cumulative update 8.00.2187

Windows Server 2003 SP2, SQL Server 2000 SP4 (8.00.2039 - according to Add/Remove programs) but with patch 8.00.2055 applied according to 'select @@version' When I try to apply the cumulative update ...
0
votes
1answer
1k 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 ...
2
votes
3answers
263 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 ...
0
votes
1answer
62 views

The SQL Server proxy MUST be a domain account?

I'm trying to setup a proxy account for a SQL Server 2000 instance (for running xp_cmdshield, by the way). I have administrative privilegies on the local server, but not in the domain. The ...
-1
votes
2answers
398 views

MSDE - How to enable mixed mode authentication

I'm trying to enable mixed mode authentication (SQL Server and Windows). I've tried following these rules but the registry key I need to change is missing... any ideas on how I can do this? ...
0
votes
2answers
338 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
85 views

Transactional Replication from SQL Server 2008 to 2000

I has transactional replication from my server1 (MS SQL 2000) to server2 (MS SQL 2000) in another company (and on different network) and it worked OK. Instead of using real name of server2, I used ...
0
votes
1answer
20 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
3answers
75 views

In SQL 2000 how do you determine what process slows down the server

Sql Server 2000 is maxed out, and I am not sure why, but I believe it may be due to the fact that a query or queries were run that are slowing it down. Is there a way to determine which query caused ...
0
votes
1answer
159 views

Migrating databases from SQL 2000 to 2008 R2

Hands-ups, I have no idea what I'm doing! We have an old SQL 2000 Server with 2 databases. I have a new server running SQL Server 2008 R2. Can someone outline the basic steps of migrating the ...
2
votes
1answer
310 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 ...
0
votes
1answer
211 views

SQLSTATE 42000 on Restore after restoring native backup from NetBackup tape

My environment is Windows Server Standard 2003 SP2, SQL Server 2000 SP4 with a few additional patches, NetBackup Admin console 7.1 and NetBackup Client 6.5.3. I take nightly full backups that restore ...
1
vote
1answer
49 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 ...
0
votes
2answers
68 views

SQL Server 2008 Vs SQL Server 2000

The performance of SQL Server 2000 database is not improving with the latest multi-core processors. I think SQL Server 2000 is not capable of utilising these cores. So, I plan to switch to SQL ...
0
votes
2answers
126 views

Diagnosing intranet performance issues

I'm attempting to figure out why our intranet is having performance issues. From some basic troubleshooting, I'm leaning towards the issue being our SQL server, which is hosted on a separate server. ...
3
votes
1answer
286 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 ...
2
votes
2answers
1k 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.
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 ...
0
votes
2answers
292 views

Where can I get SQL Server 2000 Cumulative patch 8.00.2283?

There are a number of good sites with versions and they list 8.00.2283 as downloadable but I can't find it anywhere. I can find other cumulative patches but not 2283.
0
votes
2answers
118 views

Synch SQL 2008 with failover server?

Currently they have a single SQL 2000 Std install on a server that needs to be retired. They run an app in terminal services to manipulate the data. So I'm looking at two new servers with SQL 2008 ...
2
votes
2answers
100 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
148 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 ...
0
votes
2answers
640 views

I cannot connect from .net 4.0 to sql server 2000

I'm running a winform application from visual studio 2010 .net 4.0 that needs to connect to sql server 2000. The problem is I constantly get: A network-related or instance-specific error occurred ...
1
vote
1answer
733 views

SQL Server 2000: SQL Server Browser Service missing

I have an instance of SQL Server 2000 SP4 running on Windows Server 2003 Standard Edition. In the Services MMC snap-in, the SQL Server Browser service is not listed. I am looking for reasons why this ...
1
vote
2answers
344 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.
2
votes
1answer
138 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 ...
1
vote
2answers
281 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
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 ...
0
votes
3answers
62 views

Attaching A Non-MDF SQL-Server 2000 Database

I am trying to view a copy of a SQL Server 2000 database I received, but I cannot find a way to 'attach' the database to my instance of SQL Server. I have fairly limited experience working with SQL ...
0
votes
3answers
102 views

SQL Server Performance & Latching

I have a SQL server 2000 instance which runs several concurrent select statements on a group of 4 or 5 tables. Often the performance of the server during these queries becomes extremely diminished. ...
0
votes
2answers
41 views

SQL server 2000 reporting bad values to ASP.Net Application

I have an instance of SQL server 2000 (8.0.2039) with a rather simple table. We recently had users complain about an application I wrote returning bad values for some of the dates in the databse. ...
0
votes
1answer
321 views

SQL Server 2000 Memory Status

I'm trying to get a better idea of how my SQL 2000 instance is using it's memory. I've run DBCC MEMORYSTATUS and I'm hoping someone can give me a better idea of how to interpret the output. My main ...
2
votes
1answer
2k 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 ...
0
votes
1answer
66 views

Implications of renaming sql server 2000 instance

I have a sql server 2000 of which I want to replicate the data to a sql server 2008. However the output from select @@servername and select serverproperty('servername') on the 2000 server are ...
0
votes
2answers
90 views

SQL server connecting issue

We recently installed SQL server 2000 Std. edition on my new windows server 2003 R2 server which is the additional domain in our existing windows 2003 server domain. Now i am unable to connect this ...
0
votes
2answers
409 views

Microsoft SQL server - cannot start Enterprise Manager

I have a windows 2000 system, running Microsoft SQL server 2000, and a lot of other junk. When I try to start the Enterprise Manager, I get the following error message. Snap-in failed to ...