The sql-server-2000 tag has no wiki summary.
1
vote
0answers
72 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
0answers
13 views
Generate Script in SQL Server 2000 (in Order)
I want Generate script of all views and functions in my database, but when i execute this script i find a problem of ("object xxx doesn't exist") because i have many views select data from other ...
0
votes
1answer
17 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:
...
0
votes
0answers
28 views
SQL Server 2005/2000 Linked Server Problems
I have the following configuration...
ASP.Net 4.0 Web Application (AppServer)
SQL Server 2005 (SQL2005)
SQL Server 2000 (SQL2000)
I have a linked query which links from SQL2005 to SQL2000.
The ...
0
votes
0answers
27 views
SQL Trace Profiler Not Capturing All Connections
I'm trying to run a profiler trace on a server to track any unused databases. I'm seeing connections through 'Audit Login', however for certain active databases there's nothing showing up on the ...
0
votes
1answer
27 views
Problems when connecting to a SQL Server 2000 when the name has a trailing space
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
56 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
60 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
2answers
46 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
33 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
46 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
52 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
27 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
16 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
44 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
35 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
83 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
40 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 ...
0
votes
0answers
44 views
SQL Server 2000 horizontal/vertical replication initial snapshot
I got a question. Do I need for transactional replication with horizontal/vertical filters make a full db synchronization including all table and data?
I need to replicate one-way, SQL Server 2000 ...
1
vote
1answer
25 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
38 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
67 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
78 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
1answer
206 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.
0
votes
0answers
18 views
SQL Server Error Checking Integrity
I have a client on old hardware and software. They are uninterested in upgrading tonight or even anytime soon. I set up a SQL Server backup job for them so they can copy their database off every ...
3
votes
1answer
118 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
130 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
58 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
49 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 ...
1
vote
0answers
99 views
Understanding deadlock trace log (SQL Server 2000)
Can someone help me understand the trace log resulting from a deadlock? I'm not a DBA so I would like to know which of the two nodes is causing the deadlock. Your help is appreciated.
Server: SQL ...
0
votes
0answers
104 views
mssearch.exe causing high cpu load
Running MS Sql Server 2000 SP4 on Windows Server 2003. Was working fine up until a few weeks ago. No apparent changes made. MSSearch.exe climbs up to 60-80%. Having to kill process.
Tried rebuilding ...
0
votes
2answers
98 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
213 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
140 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
1answer
148 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
77 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
145 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
267 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
50 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
75 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
30 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
112 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
136 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
38 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
65 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
169 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 ...
0
votes
1answer
32 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
71 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
47 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
25 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. ...
