I've posted this comment previously a while ago in another thread - but one of the differences between Set and Select which I find are important is that the annoying...

Yeah that's what I meant, the SIDs get mismatched. I like that idea of generating a script to pick up the SIDs.

Although I feel that this idea only suits...

Yeah but I think that trashes all of the logins.

It's actually a reasonable database, around 15 gigabytes, although copying a file of that size is no problem in this day...

Just love to jump in here, I write so many stored procedures I just about go blind.

Select / Set are both great ways of moving data into variables, but Set...