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.

Gail,

The recovery mode is Bulk-Logged

No log backups are running, that I can see.

No replication.

We don't have a point-in-time recovery requirements for these databases.

Running the SELECT you specified, for...

This topic is very interesting to me, in fact I've already posted a message about it on this site's forums. My biggest concern is, should we be putting our...