Re: SQL2000-user not grantable to login

From: "Fritz Franz" <fritzfranz24@xxxxxxxxxxx>
Date: Thu, 14 Jun 2007 13:32:24 +0200

"Michael Epprecht [MSFT]" <michael.epprecht@xxxxxxxxxxxxxxxxxxxx> ha scritto

Hello

sp_change_users_login is your friend here. It will re-synchronize the DB
User ID with that of the SQL Server Login of the same name.

USE FOC
GO
EXEC sp_change_users_login 'Auto_Fix', 'dbm'
GO

GREAT! Thx, it works!

Fritz

.

References:
- SQL2000-user not grantable to login
  - From: Fritz Franz
- Re: SQL2000-user not grantable to login
  - From: Michael Epprecht [MSFT]

Prev by Date: Re: SQL2000-user not grantable to login
Next by Date: Re: permissions required for executing CDOSys stored procedures
Previous by thread: Re: SQL2000-user not grantable to login
Index(es):
- Date
- Thread