March 9, 2010 at 10:17 am
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
March 9, 2010 at 10:34 am
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?
March 9, 2010 at 10:56 am
No errors, just cant set breakpoints and see local variables.
Jim
March 21, 2010 at 10:32 am
March 22, 2010 at 7:06 am
In production it is
Microsoft SQL Server 2000 - 8.00.2187 (Intel X86) Mar 9 2006 11:38:51 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
in testing it is
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Does this help?
TIA
Jim
March 22, 2010 at 8:13 am
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.
March 23, 2010 at 7:59 pm
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
Change is inevitable... Change for the better is not.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy