When your login fails, what do you see in the error log? There should be the same error message as you get when you log in, but there is a state number which gives further information why the login fails. (There are blog posts out there explaining these state numbers, but where I sit right now, I don't have a URL.)

Now that's a cool procedure. In the years I've worked with SQL Server, I've never heard of it. Too bad it's flagged for removal in a future version.

I just went through an exercise where we're moving a bunch of database from an old server to a new one. I encountered the whole SID-mismatch problem. I ended up building a list of all the permissions, dropping the user, recreating the user and then assigning all the permissions. It was a complete pain. I have yet to see if I caught everything. So far, I have.

Oh yes, it's a really important proc.And it's there since V2000 at least I think Yes, ALTER LOGIN is supposed to be the replacement, but it does not do the checking.. I have no news on that.. I think the'll gonna leave until all aspects are covered one way or another..guess we are expected to just ask the DMVs for that