Debugging Stored Proc

Results 1 to 2 of 2

Thread: Debugging Stored Proc

  1. #1
    Join Date
    Dec 1969

    Default Debugging Stored Proc

    I heard from someone briefly that you can alter the parameters of SQL Server&#039;s debugging tool for the stored Proc validation. I&#039;m sick of getting messages such as "Error on line 1 character 1" being that Character 1 of line one is the letter C for Create...<BR><BR>Anyone know how to do this?

  2. #2
    Join Date
    Dec 1969

    Default RE: Debugging Stored Proc

    What *I* usually do will be use the priny statement to print out the values but i guess that will only be helpful if you are creating Dynamic SP....but otherwise you usally know with what error you are thrwn cause you KNOW which line.<BR><BR>Honestly i have not heard of such a thing so if it is possible and you find out, please post it here and let us know too.<BR><BR>

Posting Permissions

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