We are moving from our databases NT4/SQLServer7 to W2K/SQLServer2K, on
new hardware. In our NT4/SQLServer7 environment we used Local Server
Groups mapped to sql logins for authentication. In the SQLServer2K
world we would like to use Domain Local Groups mapped to sql logins
Is there a way (anyway - DMO,TSQL, or 3rd party tool) in sqlserver to
1.) Remap the login accounts to NT doamin groups
- or -
2.) Copy the permissions from one sql login to another sql login
so we do not have to manually repermissions the databases.
Thanks for your help, it is greatly appreciated.