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
 General SQL Server Forums
 New to SQL Server Programming
 sysdb error

Author  Topic 

aakcse
Aged Yak Warrior

570 Posts

Posted - 2010-03-11 : 12:50:57
Hi All,

Could any one put some light on the below error, I am getting,
when I run the proc with some parameter I get result
and for some other parameter I get the below error

do I missing some priviliges?

The server principal "ABC\User" is not able to access the database "sysdb" under the current security context.
Msg 916, Level 14, State 1, Line 1

Regards,
aak

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-03-11 : 14:46:18
It depends on what is going on in your "proc".
We cannot see.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

aakcse
Aged Yak Warrior

570 Posts

Posted - 2010-03-11 : 14:57:28
Thanks Webfred,

I got it, it was calling a proc where, there has a issue.

Regards,
aak
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-03-11 : 15:00:33
fine


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -