orphaned users

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Nagesh S-432384 SSCrazy Points: 2231 More actions · Answer 1

To get list of orphaned users user the following query

USE databasename;

GO

EXECUTE sp_change_users_login @Action='Report';

To fix the Orphaned users logins one at a time

USE databasename;

GO

EXEC sp_change_users_login 'Update_One', 'database_User', 'ServerlevelDet'

Nag
------------------------------------------------
How to get the best help on a forum

http://www.sqlservercentral.com/articles/Best+Practices/61537

bala2 SSCertifiable Points: 5547 More actions · Answer 2

we can fix orphanded users trough ssis packages in Sql 2005,but how can we fix in 2000 server? is it possible through DTS packages?

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 3

No, you need to go to TSQL to fix them, usually one at a time.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt