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 2005 Forums
 SQL Server Administration (2005)
 sp_adduser

Author  Topic 

priyaram
Yak Posting Veteran

82 Posts

Posted - 2007-01-25 : 11:10:54
We are having a job in our sqlserver 2000, where it runs everyday to check any new user created in database 1 and it add that's user in another database database 2 , using the stored procedure sp_adduser.
but after we upgraded to sqlserver 2005 , this job is failing everyday by giving the error message like "'xxx is not a valid login or you don't have permissions ' SQlstate42000,error 15007.

Any help is welcome
   

- Advertisement -