<div>
sql 2005 wonrt support debugging feature. you have use print statements for each and every line
</div>


sql 2005 wonrt support debugging feature. you have use print statements for each and every line

<div>
When you run the procedure you should be getting bunch of error messages in the result pane/message window below. It points on which line the error occured. You can go through that to look at the errors line by line.<br />
P.<br />

</div>


When you run the procedure you should be getting bunch of error messages in the result pane/message window below. It points on which line the error occured. You can go through that to look at the errors line by line.
P.


<div>
I'm using some cursors, I'm trying to figure out which record is causing a foreign key error, that's why I would like to step through. &nbsp;So there is no way to step through the sql code?
</div>


I'm using some cursors, I'm trying to figure out which record is causing a foreign key error, that's why I would like to step through.  So there is no way to step through the sql code?

<div>
<div class="content wysiwyg-content">
I created a large SQL procedure. &nbsp;I've found a few errors I need to correct. &nbsp;Is there a way to step through line by line in SQL Server 2005. &nbsp;If not, how can I debug line by line to see what is causing an error. &nbsp;SQL Server Profiler? &nbsp;Thanks!!!
</div>
</div>


I created a large SQL procedure.  I've found a few errors I need to correct.  Is there a way to step through line by line in SQL Server 2005.  If not, how can I debug line by line to see what is causing an error.  SQL Server Profiler?  Thanks!!!

SQL debugging question

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.