The above solution is what I'd do.

Haven't used it, but these guys (http://www.easysoft.com/products/2002/lotus.phtml) have an ODBC driver.

Both the Guru's Guide (Henderson) and Advanced TSQL by Ban Gan are good books. Kalen's Inside SQL Server is a must as well. For practical stuff, Brian Knight's SS2K for...

insert #Test2 (account, volume)

Select      Account

              , 1 As Volume

From        #Test1

Group By  Account

You could use a Windows scheduled task to push the backups as well.

Do you have a datetime stamp of some sort?

Or you could use triggers to capture info in another table and process that table to update production.

If you know the alert, you could send some information in the mail using static text or perhaps a query from sysperfinfo.

I do not believe you can delete Meta Data Services from the EM snap in. Not sure it's a good idea. Why do you want to delete this?

you can right...

Rename the Windows server.

Inside SQL run:

sp_dropserver serverb

sp_addserver servera, local

Developers always think it's a minimal change and I can easily back it out. What if your syntax (SQL) is correct, but you miss a join and implment a cross...

Are you trying to install server? Because you will have connection issues, I believe with W2K Pro. I thought there was a limit.

You can install Personal edition, which is licensed...

There are other ways to do this, but they result in complicated SQL that is hard to read, write, adn work with. Kevin's solution is the best method and if...

While Brian has the best advice fro this, I typically leave the domain admins in because they are a small select group (here) and know better than to work with...

For a one time shot I use backup restore. Or for something like refreshing QA.

Be sure you check disabled account, computer restrictions, hours etc. in the account properties.