Posted by teddysnips on 07/03/06 07:47

Dan Guzman wrote:

> > How do I give the SPROC permission to execute?
>
> Since DBCC OUTPUTBUFFER can only be executed by sysadmin role members, you
> must be a sysadmin to use this technique to get the error message. I
> believe you will find this disclaimer in Erland's article.
>
> SQL 2005 has structured error handling that allows you can get error details
> in a CATCH block without the kludge.

The SPROC executes in a Job, which is owned by SA, which is a member of
the sysadmin role. Where am I going wrong?!?

Unfortunately, SQL2005 is not an option.

Edward

[Back to original message]