Group Already Exists

I have run the "sp_change_user_logins" to create accounts that were already
lodged in a database to the new SQL server.
I have a Windows Group that I would like to recreate the SQL login for but I
get an error when I manually try to create the account stating that the
account already exists.
I don't see a Stored Procedure for the Groups other then "changegroup" but
that just changes a users setting for an existing group.
So the question is, HOw do I bring that Windows Group that already exists in
the database so that I can create a SQL logon for that Windows Group.
Thanks
Update your client tools to SP3a. You can then see 'orphaned' users,
including Windows-based users, in your database. You can then delete the
database user before re-adding it. 'sp_change_users_login' only allows you
to fix SQL-based logins.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"John E Davis" <JohnEDavis@.discussions.microsoft.com> wrote in message
news:B6D1B78F-29B5-4AAC-A2CE-FCF1D9D546CF@.microsoft.com...
> I have run the "sp_change_user_logins" to create accounts that were
already
> lodged in a database to the new SQL server.
> I have a Windows Group that I would like to recreate the SQL login for but
I
> get an error when I manually try to create the account stating that the
> account already exists.
> I don't see a Stored Procedure for the Groups other then "changegroup" but
> that just changes a users setting for an existing group.
> So the question is, HOw do I bring that Windows Group that already exists
in
> the database so that I can create a SQL logon for that Windows Group.
> Thanks