Different strokes for different folks! I believe how you will do it will depend on your specific environment. Sometimes it's better to have WA, sometimes it's not. I believe this...

I somehow envy some of you who gets to have the final say on implementation and screening of queries/codes for production. I am a DBA and was also an analyst/programmer...

what happens is that you restored a database with defined users in it but are not defined under SQL Server's. To see which database users have no corresponding sql server...