ooops need to check my Belgium public holidays better :-p

If you had that you probably had this one too the good old DMV's one

http://www.quest.com/Quest_Site_Assets/TechnicalBriefs/dmv_poster_Quest_Software.pdf

Excellent just a little off of the sides as its nearly beer garden time baby!

Just seeing if this works <SMILEY TYPE="envy"/> <SMILEY TYPE="envy"/> <SMILEY TYPE="envy"/> <SMILEY TYPE="envy"/>

Edit #whatever

I give up

you mention that the databases were migrated from one data center to another, was this to a clean install of SQL Server? If this instance was alread in use i'd...

this link details how it works, useful to know if you haven't come accross it before

http://support.microsoft.com/kb/918992

using sp_help_revlogins to transfer your sql logins will recreate them with the same SID, however I have seen occasions especially when moving from different version when you still need to...

Can I just clarify that your trying to script users at a database level not logins at an instant level? Do users frequently change roles within your application or...

Done, thanks for the suggestion:-D

Taking no credit for it, twitter.com/#!/BrentO did the leg work.

Edit - IF CODE ADDITCT ALERT!

mmmmmmmmmm

You can grant permissions in SQL Server to AD Groups as well as AD Users, in fact i'd use this approach wherever possible, for AD security use local groups to...

Please post once you get it working @ the weekend

The version which you are not allowed to use 'commercially' is Developer Edition

Laminating

You can move the files, after the service has been stopped but there is no need as new ones are created