Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Auto Fix Orphaned Users Expand / Collapse
Author
Message
Posted Saturday, November 03, 2007 11:42 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the item Auto Fix Orphaned Users
Post #418284
Posted Tuesday, April 29, 2008 10:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 1:12 PM
Points: 1, Visits: 101
Hi,

In order to use the single command
SP_MSFOREACHDB "USE ?; EXEC SP_AUTOFIX_USERS;"
to sync users across all databases in 2005 instance creating SP_AUTOFIX_USERS procedure in Master database only was not sufficient.

For single command to work we had to create SP_AUTOFIX_USERS procedure in each of the user databases.

If SP_AUTOFIX_USERS was not created in particular user database the "Could not find stored procedure" error pops up.

Thanks
Post #492325
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse