This tag is specifically for the 2000 version of Microsoft SQL Server

learn more… | top users | synonyms

0
votes
0answers
91 views

sql server 2000: no longer able to expand jobs in sql server agent

In SSMS on a Windows 7 machine, while connecting to a server running SQL Server 2000, I am no longer able to click on the Jobs to see the Object Explorer Details. Previously, this was not an issue, ...
0
votes
0answers
83 views

Database migrated to SQL Server 2005 with 80 compatibiltiy from SQL Server 2000 experiencing locks

I am supporting an application whose code my company did not write, and was originally developed back in 2000-2002, by a company that no longer exists. The code, while not great to maintain, ...
0
votes
0answers
195 views

Query should yield result but doesn't

I need to get data from a remote SQL 2000 server and store it in a new MySQL server. I am using the FreeTSD module for php 5.3 to connect to the SQL 2000 server. I can connect without problems. ...
0
votes
0answers
242 views

SQL Server 2000 database attach error to SQL Server 2005

I have a SQL Server 2000 database (mdf and ldf). When I try to attach it, using SQL Server Management Studio Express 2005, I get this error: Attach database failed for Server 'XXXXX\SQLEXPRESS'. ...
0
votes
0answers
31 views

Shrinking SQL Server 2000 database [duplicate]

Possible Duplicate: Shrinking SQL Server 2000 database I have become the defacto SQL Server Admin and I have been tasked with moving a production database to a new server. I am trying to ...
0
votes
0answers
108 views

Msg 15064, 15275, and 15235 when running sp_spaceused

I have a database on SQL Server 2000 (no, I can't upgrade right now) where I'm trying to run sp_spaceused on each table. I'm getting the messages below. Any given table may have any, all, or none of ...
0
votes
1answer
110 views

SQL Server 2000 Backup fails with Status = 33

I am trying to take a Full Backup of a database size about 75GB. It is SQL Server 2000 - 8.00.2055 x86 version. I have plenty of disk space where the backup is being created. So disk space isn't an ...
-1
votes
1answer
155 views

IO Frozen in error SQL error log

The log shows IO DBName is Frozen follow by thaw but yet my database schedule backup task which normally been running isn't since the network team are doing backs (not database backups, according to ...
-1
votes
1answer
1k views

Is my SQL Server 2000 connection string compatible with SQL Server 2012?

Currently I have an application in Visual Basic 6. This application connects to a SQL Server 2000 server using a Data Link file (.UDL) through the OLE DB provider for SQL. The server will be ...
-3
votes
2answers
345 views

Restore single page of a database - syntax error

I'm trying to run this query RESTORE DATABASE dbname PAGE = '1:442' FROM DISK = 'C:\dbname.bak' WITH NORECOVERY but getting the error: Msg 102, Level 15, State 1, Line 2 Incorrect syntax near ...
-4
votes
1answer
3k views

Can I create a view against a table on another instance? [closed]

I need to query a table from another SQL Server on a different server but same domain, but I am not sure how I will be able to do it. I tried the solution in this answer but it doesn't work for me as ...