Debug a stroed proc

Question

Debug a stroed proc

jim.rasmussen

SSC Eights!

Points: 999
More actions
March 9, 2010 at 10:17 am

#212352

I am trying to step thru a SP. On my production server I can do this. Set breakpoints ect. But on my test server I cannot. What am I missing to configure/setup?
TIA
Jim

Viewing 7 posts - 1 through 7 (of 7 total)

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Been quite awhile since I debugged a stored proc in SQL Server 2000. What error message(s) are you getting when you attempt to debug the procedure?

jim.rasmussen SSC Eights! Points: 999 More actions · Answer 2

No errors, just cant set breakpoints and see local variables.

Jim

Garadin One Orange Chip Points: 29613 More actions · Answer 3

Can you do a SELECT @@Version on both production and test?

Seth Phelabaum

Consistency is only a virtue if you're not a screwup.

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

jim.rasmussen SSC Eights! Points: 999 More actions · Answer 4

In production it is

in testing it is

Does this help?

TIA

Jim

Garadin One Orange Chip Points: 29613 More actions · Answer 5

Not as much as I'd hoped. Here are some KB articles on the debugger in SQL 2000. Sorry I can't give you a more specific answer.

http://support.microsoft.com/kb/280101

You might also try updating your test environment to be the same version as your live.

Seth Phelabaum

Consistency is only a virtue if you're not a screwup.

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Jeff Moden SSC Guru Points: 1004593 More actions · Answer 6

It would appear that your test server is a wee bit behind in the service pack department. My redcommendtion would be to bring it up to speed and try again.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Debug a stroed proc

Cookies on SQLServerCentral