You have a few things to check here and I might break it down into a couple queries and union them.

Each would join rows with first name matching.

1. would join...

Be sure you read a bit to understand what you're doing and don't just run the code. You could get yourself into trouble.

If you have more questions, specifically about your...

I don't think there's a way to reset the LSNs and as Gail mentioned, you can't detach/attach.

My guess is only another full backup will work.

If it's not in the logs, I think you're stuck.

http://msdn.microsoft.com/en-us/library/ms187408(SQL.90).aspx

There's one "D" in update.

Luke is correct, the parser is interpreting "GROUP" as the GROUP BY phrase. you need the square brackets.

I agree with Luke in that I'd rewrite this to be more readable.

The order of joins shouldn't matter, and that's what has been the advice, but you never know. However...

Happy Holidays and enjoy the end of the year, and be sure you celebrate something.

I knew Jeff would have something!

You have good points, and I'm not discounting them, but BOL saying 2+2=5 isn't the same as them documenting something and applying a terminology to it.

Microsoft calls a role "database...

No apology needed, bitbucket.

Thanks

I think 42 is the correct answer.

If you had to get some outside input for each one, that might not lend itself to a set based solution, especially if it's older. However if it were SQLCLR...

yep, saw that. actually all are possible except the log backup.

I've edited the post and I'll clean up the question somehow.

And I'd like to see you try.

I wonder how generating pin codes would be faster procedurally? Is it some randomness being introduced somehow?