By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,903 Members | 1,922 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,903 IT Pros & Developers. It's quick & easy.

Debugging a stored procedure

P: n/a
kd
Hi All,

How to debug a stored procedure?

Thanks,
kd
Nov 21 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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" <kd@discussions.microsoft.com> wrote in message
news:87**********************************@microsof t.com...
Hi All,

How to debug a stored procedure?

Thanks,
kd

Nov 21 '05 #2

P: n/a
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" <kd@discussions.microsoft.com> wrote in message
news:87**********************************@microsof t.com...
Hi All,

How to debug a stored procedure?

Thanks,
kd


Nov 21 '05 #3

P: n/a
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" <kd@discussions.microsoft.com> wrote in message
news:87**********************************@microsof t.com...
Hi All,

How to debug a stored procedure?

Thanks,
kd


Nov 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.