0
votes
1answer
166 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
107 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
2answers
93 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
2answers
178 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 ...