Sorry, bad question. Everyone gets points.

Richard,

As much as I'd like to get up some sympathy for the Marketing guys and gals, I'm sure that they could focus on lying about other products for a year...

The automation is the same whether it's a scheduled job or an unscheduled job. You still would create the scripts to perform the restore.

If you have the logins, you can...

What do you mean change on the fly? Change from 11 to 12 to 1 (13)?

It's not clear from your question what the requirement is.

First, I'm not sure what your report means. You haven't defined what the various items would be.

Second, this almost sounds like homework. You should attempt to do something, generate some...

Maybe we should get a Zune and test 😉

I'll have someone look into it. The links should go directly to the MP3 files.

Congrats, Gail!

Baseball knowledge probably does help with the levels. I picked these over the summer, so my apologies for outside influences 🙂

As an FYI,

Willy Mays - 660 Home runs

Babe...

If you use Enterprise Manager to assign the account, it will assign the correct local permissions.

The network permissions will be in Active Directory for the old account.

You can read mail (http://msdn2.microsoft.com/en-gb/library/ms179879.aspx), however this can be a security risk and it will be removed in future versions.

Agree with the advice above.

You can search the Microsoft site and you'll see SP2 available. It was released last summer. There were some bugs and I'd apply cumulative update 3 post SP2. Not sure...

I don't think there's a performance impact, it's more a security issue. There is additional checking of rights when you cross databases, but that's minor. Unless this is a very...

detach the databases, copy the mdf/ldf files over, and reattach the database.

Right click in SSMS will give you the detach/attach options.

You should be running regular log backups, this will remove the active portions of the log, and it should alleviate the need to shrink it.

Don't shrink the database unless you...

I'd agree with your actions. You don't want to mess with the hardware that your database depends on and if you're not an expert, get someone who is.