microsoft.public.sqlserver.server

Author

Script Users SQL2K

Leandro Loureiro dos Santos

2002-11-28, 10:23 am

Hello,

Hwo can i script all users created in my SQLSERVER2K ?
I dont want script users who use a database, i want to script all users on
the server.

Thanks
Leandro L S

Steven Wilmot

2002-11-28, 2:23 pm

You want to script SQL Logins, not users ... this can be done from
Enterprise-manager

Tools / Generate SQL Script.

Steven

"Leandro Loureiro dos Santos" <lesantos@sefa.es.gov.br> wrote in message
news:uE497gvlCHA.488@tkmsftngp02...
> Hello,
>
> Hwo can i script all users created in my SQLSERVER2K ?
> I dont want script users who use a database, i want to script all users on
> the server.
>
> Thanks
> Leandro L S
>
>
>
>

Sponsored Links