Cannot insert the value NULL into column ‘owner_sid’, table ‘msdb.dbo.sysjobs’ | SQL Server




Hi All
Today we faced below error while creating a new Job @ server XXXXXXXXX . The job was similar to other jobs except Owner of job should be some application user 'domain\user_03'.

"Cannot insert the value NULL into column ‘owner_sid’, table ‘msdb.dbo.sysjobs’; column does not allow nulls. INSERT fails."
While trouble shooting i tried to give sa as job owner but face same error. Then we just tried to find SID of user by below query's
select * from sysusers where name = 'DOMAIN\user_03'

sidname
0x010500000000000515000000AE9EFAED43D316F2BD707BCF318F0400DOMAIN\user_03



select * from sysusers where name = 'domain\user_03'

NULL
Output is clear : Issue is due to case sensitivity.
Even column name is also case sensitive like SID will not work(Invalid column name 'SID'.) where as sid is working fro sys users table. 
Reason : Collation is Latin1_General_BIN  : this is used to employ case sensitivity due to various reasons

No comments

Algae Services. Powered by Blogger.