Debugging an SP

Question

Post reply

Debugging an SP

vaidyanathan_kalyanasundaram

Right there with Babe

Points: 799
More actions
October 25, 2007 at 11:17 pm

#91368

Hi,
When i try to debug/ step into an SP in Sql 2k i am not able to step through the SP code.I have rights to execute sp_sdidebug in my DB.
What else should i possibly check?

Viewing 15 posts - 1 through 15 (of 16 total)

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

jdwebwolf SSC Veteran Points: 268 More actions · Answer 1

jdwebwolf

SSC Veteran

Points: 268

October 26, 2007 at 11:09 pm

#745964

What happens when you try to step through?

vaidyanathan_kalyanasundaram Right there with Babe Points: 799 More actions · Answer 2

I supply the values when the SP is in debug mode and then when i execute the SP with breakpoints it just returns a null resultset with column headers alone...It does'nt hit the breakpoint...

ChiragNS One Orange Chip Points: 26137 More actions · Answer 3

Hi

Is the break point inside some condition?

"Keep Trying"

vaidyanathan_kalyanasundaram Right there with Babe Points: 799 More actions · Answer 4

I have put it on an IF loop...also tried putting it on a Select @var=" so and so"" statement.

ChiragNS One Orange Chip Points: 26137 More actions · Answer 5

HI

When u debug are u stepping into the IF loop?

Put the break point before the IF loop just to check.

"Keep Trying"

vaidyanathan_kalyanasundaram Right there with Babe Points: 799 More actions · Answer 6

Nope..Still no luck....BTW what are the statements on which i can place a breakpoint??

chris lewis-447023 SSC Rookie Points: 44 More actions · Answer 7

are you trying to debug on a local instance or a remote one? sometimes you need more configuration to achieve the latter.

vaidyanathan_kalyanasundaram Right there with Babe Points: 799 More actions · Answer 8

On a remote server...but my log in id has accees to SP_Sdidebug

VaiydeyanathanVS Hall of Fame Points: 3053 More actions · Answer 9

try out these links...Thought this might be useful to you.....

http://www.15seconds.com/issue/050106.htm

searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1197403,00.html

http://www.thescripts.com/forum/thread711362.html

http://www.ftponline.com/vsm/2002_11/magazine/columns/databasedesign/

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_22683964.html

http://www.codeproject.com/useritems/Debug_SQL_Procedure.asp

vaidyanathan_kalyanasundaram Right there with Babe Points: 799 More actions · Answer 10

Hi,

Thanks for your help...

when i went through the last link (from code project) they had told us to execute sp_sdidebug 'LEGACY_ON' and when i did that and tried to step into the SP once again i get this error now....

Server: Msg 508, Level 16, State 1, Procedure sp_sdidebug, Line 1

[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debugger on server (Error = 0x800401f3). Ensure that client-side components, such as SQLLE.DLL, are installed and registered on your computer.

Debugging disabled for connection 59.

what could this be due to?

John Dempsey Hall of Fame Points: 3225 More actions · Answer 11

It may be necessary to verify that you client and remote server are using the same version. I used to have the same problem until I updated my client version.

Jeff Moden SSC Guru Points: 1004307 More actions · Answer 12

vaidyanathan_kalyanasundaram (10/30/2007)
On a remote server...but my log in id has accees to SP_Sdidebug

I can't find any documention to support my thought on this, but don't you need to have "SA" privs to use the debugger??

--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)

vaidyanathan_kalyanasundaram Right there with Babe Points: 799 More actions · Answer 13

Hi ,

By same version you mean the clent&server need to have the same service packs??

martin-210793 Ten Centuries Points: 1083 More actions · Answer 14

Well just make sure that you are using the same versions of the software... SQL Server management studio for SQLServer 2005. and so on and so on for 2000.

And make sure you have the latest SQLServer service packs on your desktop for the client software.