how do debugging in sql server 2008???

Question

How do debugging in sql sever if i wanna to check value in store proc after each query???

Jignesh Trivedi · Answer

hi Please refer http://msdn.microsoft.com/en-us/library/hh272701(v=vs.103).aspx hope this will help you.

Sanjeeb Lenka · Answer

Refer to this link http://www.keepitsimpleandfast.com/2009/06/how-to-debug-your-sql-server-query.html http://msdn.microsoft.com/en-us/library/yet1b7by%28VS.80%29.aspx

venkata kumar · Answer

hi you can try like the fallowing exec procedurename 'parameter1''parameter2'.............