export roles and users into CSV

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marty - 12 Mar 2008 10:11 GMT

First of all, my SQL coding skills are not very good. Therefore I am
looking for a script which will export all SQL2k DB Roles (Application
& Database) including the Users (native SQL & AD Groups (we are using
mixed mode)) into a *.CSV.

thanks for your help

Reply to this Message

Randy Pitkin - 13 Mar 2008 16:54 GMT

That would be a nice Script to have.
In the meantime, try going to each database and selecting Generate Scripts.
Then only choose to scipt logins ?
that should be it,

Now to do it for one or more databases on one or more Servers.
Might have to try that on sunday

> First of all, my SQL coding skills are not very good. Therefore I am
> looking for a script which will export all SQL2k DB Roles (Application
> & Database) including the Users (native SQL & AD Groups (we are using
> mixed mode)) into a *.CSV.
>
> thanks for your help

Reply to this Message

Marty - 14 Mar 2008 08:03 GMT

Hi Randy

Have a look at this link:

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31889/

Just need to build a DTS around the script and than adding it on each
DB server

> That would be a nice Script to have.
> In the meantime, try going to each database and selecting Generate Scripts.
[quoted text clipped - 10 lines]
>
> > thanks for your help

Reply to this Message