Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 scheduled job help.

Author  Topic 

jshurak
Starting Member

44 Posts

Posted - 2006-12-04 : 10:55:30
I have a job that fails when it runs. The job itself is just a number of 'sp_change_users_login auto_fix' to fix a syncing issue we are having. I can run the script in Query Analyzer, manually, with no issues, but when its scheduled it fails. Its giving 'login already exists' errors, but its also reporting that its fixes some orphaned users. Does anyone know why this might be happening?
   

- Advertisement -