locked
Debugging SQL 2008 in VS 2008 RRS feed

  • Question

  • I have been using VS 2008 in Server Explorer to debug SQL 2000 Stored Procedures (e.g. setting break points. step into) w/o problems. Once we swithced to SQL 2008, I am unable to debug. The following are the settings I have:

    1) Use Windows Account to establish connection.

    2) execute sp_addsrvrolemember 'Domain\Name', 'sysadmin' to make sure I have sysadmin right

    3) execute sp_enable_sql_debug

    When I tried to step into store procedure, the following error occured

    "T-SQL execution ended without debugging. You may not have sufficient permission to debug. Click Help for more information"

    Can anyone help me to pinpoint where the issues are ?

     

    Thanks

    Thursday, April 14, 2011 2:43 PM

Answers

  • You  may need to launch Visual Studio instance as administrator, by right-clicking VS icon, and select "run as administrator".
    Eric Yang [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Proposed as answer by eryang Monday, April 25, 2011 9:52 AM
    • Marked as answer by eryang Monday, May 2, 2011 3:59 AM
    Tuesday, April 19, 2011 1:25 AM