Post reply

Step into Stored Procedure failing with message "Cancelled by User"

  • October 26, 2009 at 1:11 am

    #216570

    Hi Friends,

    I am trying to debug a stored procedure using "Step into Stored Procedure" in VS 2008. The operation is getting end with the message "Cancelled by User" in Output windo. Could some one take me out from this problem.

    Thanks in advance for your help.

    Thanks & Regards,

    Venkat.

  • October 26, 2009 at 4:23 am

    #1070593

    Can you execute that proc in SSMS window and see if it executes successfully?

    ---------------------------------------------------------------------------------

  • October 29, 2009 at 4:03 pm

    #1072873

    Do you have administrator privileges on your box? Debugging CLR procedures from VS2008 requires to be administrator.

  • October 30, 2009 at 4:12 am

    #1073002

    Quite right Flo - this message is normally caused by not being an administrator, or using a SQL Server account which is not a sysadmin. Vista users also have to be careful to start the IDE 'as administrator' and to ensure that any Windows Authentication account used to connect to SQL Server is explicitly a sysadmin: the BUILTIN\Admininstators group is not granted sysadmin access by default.

    Paul

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

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

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