Debugging a stored procedure

[kd]

Hi All,

How to debug a stored procedure?

Thanks,
kd

[DevNick]

This really doesnt have anything to do with VB, did you post in the SQL, or
to the oracle or DB people for the product you use?
Its different for each of them.

you need to be a dba to do it(security wise).

"kd" <[e-mail]> wrote in message
news:87**********************************@microsof t.com...

Hi All,

How to debug a stored procedure?

Thanks,
kd

[kd]

Hi,

Sorry, I should've been more clear.

I would like to debug a stored procedure from the vb.net development
environment. I am executing 'ExecuteNonQuery' (which in turn executes a
stored procedure) from my vb code and I want to be able to step into the
stored procedure and debug it. I have heard of SQL debugger, but don't know
to enable it in the vb.net environment in order to be able to step into a
stored procedure.

Regards,
kd.

"DevNick" wrote:

This really doesnt have anything to do with VB, did you post in the SQL, or
to the oracle or DB people for the product you use?
Its different for each of them.

you need to be a dba to do it(security wise).

"kd" <[e-mail]> wrote in message
news:87**********************************@microsof t.com...

Hi All,

How to debug a stored procedure?

Thanks,
kd

[Deepti Kalakonda]

You cannot debug a stored procedure by executing the stored procedure from
the 'ExecuteNonQuery' method.
You can only debug the stored procedure directly from the IDE. To debug the
stored procedure, you have to set the breakpoints in a stored procedure by
opening the procedure from the server explorer, and then right-click the
stored procedure in the server explorer, and click "Step Into Stored
Procedure".

"kd" wrote:

Hi,

Sorry, I should've been more clear.

I would like to debug a stored procedure from the vb.net development
environment. I am executing 'ExecuteNonQuery' (which in turn executes a
stored procedure) from my vb code and I want to be able to step into the
stored procedure and debug it. I have heard of SQL debugger, but don't know
to enable it in the vb.net environment in order to be able to step into a
stored procedure.

Regards,
kd.

"DevNick" wrote:

This really doesnt have anything to do with VB, did you post in the SQL, or
to the oracle or DB people for the product you use?
Its different for each of them.

you need to be a dba to do it(security wise).

"kd" <[e-mail]> wrote in message
news:87**********************************@microsof t.com...

Hi All,

How to debug a stored procedure?

Thanks,
kd