Post reply

error executing msdb.dbo.sp_help_job

  • August 10, 2010 at 1:01 pm

    #142347

    Hi,

    I am trying to execute the stored procedure [msdb].[dbo].sp_help_job to know the DTS jobs that are currently running. I am using SSMS 2005 to connect to SQL Server 2000 and I am logged in as a normal user.

    Here's the error I am getting when executed:

    A severe error occurred on the current command. The results, if any, should be discarded.

    Also I have granted executable permissions to my login on that stored procedure but still get the same error.

    Can anyone suggest me what am I doing wrong? Is this something to do with the user roles?

    thanks

    TZ

  • August 10, 2010 at 1:07 pm

    #1204996

    is this KB relevant http://support.microsoft.com/kb/910416

    you may also see Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 00000020 at 0x0110B72B 2. int the error log

    if so this is a known bug and there is a hotfix

  • August 10, 2010 at 1:17 pm

    #1205000

    Hi,

    Thanks for your reply. I am getting the same error when connected to the SQL Server 2000 from SSMS 2008. Guess this is something to do with the server I am connecting to and not the client itself.

    thanks

    TZ

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply