export roles and users into CSV

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
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
"Marty" <martin-za.frick@.ubs.com> wrote in message
news:fe528b81-5d2a-4732-93f3-ad47f8316644@.c33g2000hsd.googlegroups.com...
> 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
|||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
On 13 Mrz., 16:55, "Randy Pitkin" <RandyPit...@.ydpages.com> wrote:[vbcol=seagreen]
> 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
> "Marty" <martin-za.fr...@.ubs.com> wrote in message
> news:fe528b81-5d2a-4732-93f3-ad47f8316644@.c33g2000hsd.googlegroups.com...
>