you should be able to connect to 2000 from SSMS. I'm not sure about the Express version, but I wouldn't expect it to fail.

I have SSMS here, SQL 2005, SP1...

How did you define the temp table? Did you add a collation to the DDL?

I don't think you can change the priority of a single DTS process. What you can do is build checks into those processes, perhaps at places, and query to...

That's interesting. I'd say 1,000/sec is high, but that's just a guess. It's been some time since I tracked this. I ought to see what SSC does.

There's some nHibernate in use here in the admin tools. When it became problematic to add columns to a page (related table) or change the queries for particular pages, I...

You can right click on most of the folders and there is a "Generate Scripts" option for jobs, alerts, etc. You run that, then take the result and run that...

To add to Gail's note.

It looks like you have a 4:00am backup. I assume you do that once a day, with log backups taking place every hour.

If you lose the...

You can ONLY move a table with a clustered index. You do this by rebuilding the clustered index on the new filegroup. If you don't have one, just create one...

What is the data type of the field you are using in the WHERE clause, and what exactly is the code you are using?

Likely, as Lynn mentioned, you have an...

I assume the domain is correct, and that you can log on locally to the VM.

Can you log on with NT Auth to (local)?

Here's the other issue. If you find errors in DBCC, and you've just run your backup, it might be useless. I'd argue you should get the integrity checks done, and...

That's a fair point and I'll reword the question and answer and award points back.

Most people working with SQL Server, are laypeople, and to them, Unicode is UCS-2, 2 bytes...

That is in vague.

Does the file reside on the SQL Server? Does it need to? Typically SQL Server doesn't write to the file system. It can, but that's not something...

Did you add the new disk as a clustered resource? I'm not sure it shows up automatically.

I would use the T-SQL script that Mani provided. Get used to using scripts, and you could easily set this to run at the end of other maintenance operations that...