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.
| Author |
Topic |
|
AndreasMeyer
Starting Member
9 Posts |
 Posted - 2007-12-10 : 05:33:24
|
| Hello,I have SQL-Server 2000.Jobs are listed under "Management, SQL Server Agent, Jobs".In the properties of any job, in the Tab-page [General] there is a drop-down list for the caption Owner:In this list a domain user is listed that does not exist as login in this sqlserver (anymore).How can I remove this user from this list? Somehow it is orphaned.In SQL-Server the user is spelled with a small letter and in the domain this user only exists starting with a capital letter. So adding removing it from the domain does not help.Thank you.Andreas |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-10 : 22:29:28
|
| Is it a user in msdb? |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-11 : 05:00:08
|
| Go into sysusers in msdb and remove it from there. |
|
|
|
|
|
|
In properties of any job in SQL Server Agent,Jobs