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