Professional Web Applications Themes

Can U Debug or step through a Stored Procedure??? - Microsoft SQL / MS SQL Server

In the Object Browser of QA, right-click on the proc you want to debug and click on Debug. -- Tom --------------------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com/sql "Tim" <com> wrote in message news:01a601c34d5c$13e7bc70$gbl... Can You Debug or step through a Stored Procedure??? i have some thing that look right but don't work i would like to debug like a VB app is that possible??? Thanks Tim...

  1. #1

    Default Re: Can U Debug or step through a Stored Procedure???

    In the Object Browser of QA, right-click on the proc you want to debug and click on Debug.

    --
    Tom

    ---------------------------------------------------------------
    Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    SQL Server MVP
    Columnist, SQL Server Professional
    Toronto, ON Canada
    www.pinnaclepublishing.com/sql


    "Tim" <com> wrote in message news:01a601c34d5c$13e7bc70$gbl...
    Can You Debug or step through a Stored Procedure??? i
    have some thing that look right but don't work i would
    like to debug like a VB app is that possible???


    Thanks

    Tim

    Tom Guest

  2. #2

    Default Re: Can U Debug or step through a Stored Procedure???

    Ok i'm in the Query yer, is the object Browser the
    edit window...? i Have SQL SERVER 7.0... i can't seem to
    find debug...

    Tim
     
    want to debug and click on Debug. 
    ------ 
    news:01a601c34d5c$13e7bc70$gbl... 
    Tim Guest

  3. #3

    Default Re: Can U Debug or step through a Stored Procedure???

    This feature is available only in SQL Server 2000.

    --
    Tom

    ---------------------------------------------------------------
    Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    SQL Server MVP
    Columnist, SQL Server Professional
    Toronto, ON Canada
    www.pinnaclepublishing.com/sql


    "Tim" <com> wrote in message news:0b4101c34d63$630d8f80$gbl...
    Ok i'm in the Query yer, is the object Browser the
    edit window...? i Have SQL SERVER 7.0... i can't seem to
    find debug...

    Tim
     
    want to debug and click on Debug. 
    ------ 
    news:01a601c34d5c$13e7bc70$gbl... 

    Tom Guest

  4. #4

    Default Re: Can U Debug or step through a Stored Procedure???

    Tim,

    See if this helps.

    Microsoft SQL Server 7.0: Stored Procedure Debugging How-To
    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvid/html/msdn_storedproceduredebugtech.asp


    --
    Dinesh.
    SQL Server FAQ at
    http://www.tkdinesh.com

    "Tim" <com> wrote in message
    news:0b4101c34d63$630d8f80$gbl... 
    > want to debug and click on Debug. 
    > ------ 
    > news:01a601c34d5c$13e7bc70$gbl... [/ref]


    Dinesh.T.K Guest

  5. #5

    Default Re: Can U Debug or step through a Stored Procedure???

    Hi All,
    I read all the posts in the news group about sql debugger, i am trying
    to debug from a remote client, iam loggin in as sa so i dont have rights
    permission, the problem is that the execution never stops on the break
    points
    I understand g duvall had the same problem, any solutions ?

    "Dinesh.T.K" <mail.tkdinesh.com> wrote in message
    news:phx.gbl... 
    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvid/html/msdn_storedproceduredebugtech.asp 
    > > want to debug and click on Debug. 
    > > ------ 
    > > news:01a601c34d5c$13e7bc70$gbl... [/ref]
    >
    >[/ref]


    Ashish Guest

Similar Threads

  1. Stored Procedure Help
    By drudiggy in forum Coldfusion Database Access
    Replies: 11
    Last Post: November 29th, 08:44 PM
  2. Stored procedure?
    By SG via DotNetMonster.com in forum ASP.NET Web Services
    Replies: 0
    Last Post: February 23rd, 01:06 PM
  3. Stored procedure
    By Uri in forum Microsoft SQL / MS SQL Server
    Replies: 13
    Last Post: August 19th, 03:23 PM
  4. Debug step into event handlers
    By Robert Millman in forum ASP.NET General
    Replies: 0
    Last Post: July 29th, 03:24 PM
  5. need help on a stored procedure
    By Helixpoint in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 8th, 01:26 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