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.

You don't really want to use the timestamp type, rather a datetime marked at the time or some flag that indicates where they were. I'd post the data and insert/...

I like Chris' suggestion and would use that.

I'm not sure this is available in this extended stored procedure.

It's a stored procedure, so an insert..exec will do it

create table mytest( drive varchar(2), mb numeric)

insert mytest exec master..xp_fixeddrives

select * from mytest

drop table mytest