As you might have guessed, I'll be there. Likely working the door for the party 🙂

Glad things are going well, Jack.

I would recommend VBSCript to do this. The FileSystemObject can perform file manipulation and the ADO objects can connect to SQL Server.

http://www.mssqltips.com/tip.asp?tip=1324

AFAIK, this is correct. You cannot detach a filegroup, only a database.

Pimane is correct, this is not intended to limit all queries. It is designed to limit resources when there is contention.

If no one is on the server except a single...

No issues. The Win 7 clients can connect to a SQL 2000 db. The clients are backwards compatible. It's the server code that's the issue in trying to install that...

Excellent comments, and thanks for the debate.

replication would do this.

If you have some type of date or timestamp field that can determine what's "new", you can build an SSIS package to easily move these.

AFAIK, the resource governer doesn't understand anything about the other instances.

It's a limiting factor, not a governing factor. If you have two groups, each allowed 70% max CPU, separate instances,...

Are you an administrator on your machine?

What edition of SQL Server 2005 are you installing?

Are you running SQL 2000 on the XP clients? Or do they connect to a server?

If you are installing SQL Server 2000 on the client, as MSDE, no, AFAIK, you...

Are you sure your function is returning one for the SQL Server Agent service account (or proxy account)?

If you remove that function call, does it work?

CAST and CONVERT http://msdn.microsoft.com/en-us/library/ms187928%28SQL.90%29.aspx

Wow

You would change the connection string for each platform, and would need drivers to connect to each server.

Note that each of these products uses a different version of SQL, so...