Tagged Questions

0
votes
1answer
421 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
3answers
58 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
2answers
397 views

Find last access datetime stamp for objects in SQL Server 2000 database

I'm in the planning stage/phase of migrating one of our SQL Server 2000 databases to 2008. Our database holds numerous tables (hundreds) and stored procedures (hundreds). I'm trying to figure out ...
1
vote
0answers
60 views

Why do I get a SQL 2000 DATABASE Disconnected error when Databse is online?

Every Database works on our SQL 2000 Server. One Database responds with "Error 0: This server has been disconnected. You nust reconnect to perform this operation." It then poroceeds to look at the ...
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 ...