To debug the stored procedure
Hi,plz gv ans "how we will debug the stored procedure steps".
Thanks
You must Sign In to post a response.
Category: Smart Devices
plz gv ans "how we will debug the stored procedure steps".
Thanks
#710993
which version of sql server you are using?
You want to debug SP in sql server or in some other tool?
If you want to debug it in SQL Server 2005 and newer version then follow http://msdn.microsoft.com/en-us/library/ms174763.aspx link. Everything is given here.
Dharmendra Kumar
dharmendra.hbti@gmail.com
+919911308352
http://blog.dkumar.co.in
You want to debug SP in sql server or in some other tool?
If you want to debug it in SQL Server 2005 and newer version then follow http://msdn.microsoft.com/en-us/library/ms174763.aspx link. Everything is given here.
Dharmendra Kumar
dharmendra.hbti@gmail.com
+919911308352
http://blog.dkumar.co.in
#710994
Hi,
When you need to debug a stored procedure, you only have to locate it in the database explorer — Step-in and step-over command and is available from the debug menu. Optionally, start debugging from a stored routine source window, or from the Code toolbar.
Once you have the object browser top menu, select a stored procedure in a database and click on the debug option in top menu. Select the start debugging option and debug the stored procedure.
Refer this link also,
http://msdn.microsoft.com/en-us/library/hh272701%28v=vs.103%29.aspx
Regards,
Gandhi
When you need to debug a stored procedure, you only have to locate it in the database explorer — Step-in and step-over command and is available from the debug menu. Optionally, start debugging from a stored routine source window, or from the Code toolbar.
Once you have the object browser top menu, select a stored procedure in a database and click on the debug option in top menu. Select the start debugging option and debug the stored procedure.
Refer this link also,
http://msdn.microsoft.com/en-us/library/hh272701%28v=vs.103%29.aspx
Regards,
Gandhi
#710995
Hi,
Goto SQL Server management Studiko-> Goto Object Explorer-> Click on the server (or may be your local machine)->Select Database-> Select Programmability-> C lick on Storedprocedures-> Right click on the particular Storedprocedure for instance "sp_EmployeeDetails". Select Debug Procedure
If the storedproceudre has any input parameters, the the Debug Procedure dialog box will be appearing, with a table containing column for the input parameters list and the other for value for those input parameters Enter values for each parameter, and click OK.
Thanks
Padma
Have a good Day
Goto SQL Server management Studiko-> Goto Object Explorer-> Click on the server (or may be your local machine)->Select Database-> Select Programmability-> C lick on Storedprocedures-> Right click on the particular Storedprocedure for instance "sp_EmployeeDetails". Select Debug Procedure
If the storedproceudre has any input parameters, the the Debug Procedure dialog box will be appearing, with a table containing column for the input parameters list and the other for value for those input parameters Enter values for each parameter, and click OK.
Thanks
Padma
Have a good Day
Return to Return to Discussion Forum