none
Trying to call a stored procedure in msdb - I get Could not obtain information about Windows NT group/user Msg 15404, Level 16, State 10, Procedure xp_logininfo

    Question

  • I have a stored procedure in msdb that basically wraps sp_send_dbmail and then I grant execute to my procedure to a specific user.

    I can run this "wrapper" procedure just fine when connected as my windows account, but then again I am in the sysadmin role.

    When connected as the user who has been grated exec permissions, I get something like this

    Msg 15404, Level 16, State 10, Procedure xp_logininfo, Line 62
    Could not obtain information about Windows NT group/user  (user name here...) error code 0xffff0002

    Help?

    • Edited by shiftbit Thursday, April 04, 2013 4:32 PM
    Thursday, April 04, 2013 4:32 PM

All replies