You've asked some good questions, Mr or Mrs 500, so let me see if I can answer them.

Yes, the databases are available 24/7 through our web applications. However, the...

Thank you, Timothy and David for your replies. I don't think we have a copy of SQL Server 2005 administration books around, but it sounds as though that would...

Thank you, Fraggle, for the link to the other thread on the difference between SQL Server Maintenance Plans and SQL Server Jobs.

What is logshipping?

David, it sounds like, given what you've said, I would be better off either dettaching the files and attachning them after I've copied them to the new server, or doing...

I just watched your video podcast on this topic, Steve. Nice place! If you ever want to sell it...

But seriously onto the topic at hand. I do...

Brian, I'd like to ask a question about the "Setting and Changing the Server Collation" article that you referred to. Steps 2 and 3 of the instructions say to...

OK, thank you, Brian.

Is the default collation not case sensitive for only username, or is it also not case sensitive for password?

WOW! You're right, that is not going to be easy or quick. Someone else set up this new test database, and now I wish he hadn't done that....

OK, I've found the problem. Apparently the username is case sensitive. I didn't expect that. I know that the password is case sensitive, but I didn't realize...

It is hard to tell, as the stored procedure where it is failing is the first one that it hits.

The weird thing is that, if I connect to...

K. Brian Kelley (8/14/2008)

---

Grantor is simply who granted the permissions to the grantee. You can change this by revoking the permissions and regranting it.

Do the SIDs match up for...

Thank you. We don't have VSTE for anybody, let alone DBA's, so I guess I'll go with the PowerShell method.

"VSTE for DBAs". What is VSTE?

I'll review your PowerShell videos, thanks.