Professional Web Applications Themes

stored procedures run through while debugging - Microsoft SQL / MS SQL Server

Does anybody know why I can't debug in the query yser (SQL Server 2000)? The stored procedure immediately runs through and presents me with the result. I have sufficient rights to execute SP_SDIDEBUG but this doesn't help. Thank you in advance! Daniel...

  1. #1

    Default stored procedures run through while debugging

    Does anybody know why I can't debug in the query yser
    (SQL Server 2000)? The stored procedure immediately runs
    through and presents me with the result. I have sufficient
    rights to execute SP_SDIDEBUG but this doesn't help.

    Thank you in advance!

    Daniel
    Daniel Guest

  2. #2

    Default Re: stored procedures run through while debugging

    SQL Server service where your stored procedures are located must be running
    under a Windows NT user account that has administration privileges to the
    server. Debugger can't run if SQL Server is running under a local system
    account. To check the type of account your server uses, go to Control Panel [/ref]
    and you will see Service dialog window. In the Log On As tab, uncheck the
    System Account option button and enter the account username and password in
    the fields located in the tab. The username can't be LocalSystem, the
    account user-name and password must be for a user.

    Refer to following topic in BOL

    "Troubleshooting the Transact-SQL Debugger"

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_
    servtools_5cfm.asp

    --
    -Vishal

    "Daniel Walzenbach" <de> wrote in
    message news:0c0501c3505b$45feac30$gbl... 


    Vishal Guest

  3. #3

    Default Re: stored procedures run through while debugging

    Thanks for your reply Vishal but unfortunately the SQL
    Server service is already running under a WIndows NT user
    account. Do you have any other ideas?

    Regards
    Daniel

     
    located must be running 
    privileges to the 
    under a local system 
    go to Control Panel [/ref][/ref]
    the Startup button 
    tab, uncheck the 
    username and password in 
    LocalSystem, the 
    url=/library/en-us/trblsql/tr_ 
    <de> wrote in [/ref]
    yser [/ref]
    sufficient 
    >
    >
    >.
    >[/ref]
    Daniel Guest

  4. #4

    Default Re: stored procedures run through while debugging

    Check for the troubleshooting section in BOL or the url i've mentioned in
    the post.

    --
    -Vishal

    "Daniel Walzenbach" <de> wrote in
    message news:008301c3505f$dc3127b0$gbl... 
    > located must be running 
    > privileges to the 
    > under a local system 
    > go to Control Panel [/ref]
    > the Startup button 
    > tab, uncheck the 
    > username and password in 
    > LocalSystem, the 
    > url=/library/en-us/trblsql/tr_ 
    > <de> wrote in [/ref]
    > yser [/ref]
    > sufficient 
    > >
    > >
    > >.
    > >[/ref][/ref]


    Vishal Guest

Similar Threads

  1. Debugging Procedures using dbVarName
    By paul_breitzmann in forum Coldfusion Server Administration
    Replies: 2
    Last Post: April 17th, 03:42 PM
  2. dt_ Stored Procedures
    By chopper in forum ASP Database
    Replies: 2
    Last Post: July 20th, 04:06 PM
  3. Stored Procedures and 4GL
    By Ahmer Sajjad in forum Informix
    Replies: 1
    Last Post: September 9th, 01:23 PM
  4. Debugging / Single Step into event procedures
    By R Millman in forum ASP.NET General
    Replies: 3
    Last Post: August 6th, 09:28 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139