473,322 Members | 1,510 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

How can I debug Stored Procedure?

Hi there
How can I debug Stored Procedure?
Thanks
Jul 20 '05 #1
1 8269
Elham GH (El**************@yahoo.com) writes:
How can I debug Stored Procedure?


If you don't have an Object Browser open, press F8 to open it. (We're
talking Query Analyzer.) Browse to the procedure of your choice, right-
click and at the bottom of the context menu, you find Debug. You need
to enter values for mandatory parameters (or check Set to NULL.) For
datetime data, use the format YYYY-MM-DD.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: JollyK | last post by:
Hello folks, Previously I have debugged stored procedures with VS.NET 2002 on Windows 2000 successfully. I know that in order to debug a stored procedure, I need to enable SQLServer debugging...
0
by: scott | last post by:
xp pro vs 2003 enterprise arch 2003 server with sql 2000 From xp pro and when using the to "step into stored procedure" option upon connection to a database in VS 2003 im getting the message: ...
5
by: moondaddy | last post by:
I have a website where cataloge pages are populated by calling a stored procedure on sql server. I use the sql data adapter's fill method to call this stored procedure and fill the dataset. about...
2
by: scott | last post by:
Hi, I followed everything this article suggests: http://support.microsoft.com/default.aspx?scid=kb;EN-US;836734 Yet I still get the following message when stepping into a SP: "Cannot...
2
by: Michael | last post by:
Running DB2 v7 UDB ("DB2 v7.1.0.93", "n031208" and "WR21333") on Windows XP, I am unable to find out why the "Build for Debug" option within Stored Procedure Builder is not enabled on Java stored...
1
by: scott | last post by:
..net 2003 - debug stored procedure ok on 2k - but ? on XP at breakpoint. Hi, In VS.net 2003 i set a breakpoint on a stored procedure and attempt to step into stored procedure to debug. All i...
2
by: Bill_DBA | last post by:
I have the following stored procedure that is called from the source of a transformation in a DTS package. The first parameter turns on PRINT debug messages. The second, when equals 1, turns on the...
6
by: fayez | last post by:
hi. I'm using DB2 9 Developer Workbench, Debug icon is dim (deactivated), I tried all help tools how to setup, but failed.. Am I missing any installations? or is there any special setting? ...
0
by: dwivedialok13 | last post by:
I am trying to debug a SQL server 2005 SP in VS 2005. I understand that there are two types of debugging (actully 3 but I am ignoring SQL/ CLR SPs written in C# etc). 1. Direct database...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.