Debugg a large Stored Procedure

Hi,
Is there any way I can debug a large SP? Right now I am using print and
select statements to output the value, but can I do it like normal
programming language, set up break points, watch varaible values......
TIAQuery Analyzer, hit F8, find a stored procedure, right-click, Debug...
Visual Studio might have some facility for this as well.
"Ed Chiu" <EdChiu@.discussions.microsoft.com> wrote in message
news:DBC274B3-9FCD-47D1-8284-B190B1ACB5B9@.microsoft.com...
> Hi,
> Is there any way I can debug a large SP? Right now I am using print and
> select statements to output the value, but can I do it like normal
> programming language, set up break points, watch varaible values......
> TIA
>
>|||http://msdn.microsoft.com/library/d...asp?frame=true
David Portas
SQL Server MVP
--
"Ed Chiu" <EdChiu@.discussions.microsoft.com> wrote in message
news:DBC274B3-9FCD-47D1-8284-B190B1ACB5B9@.microsoft.com...
> Hi,
> Is there any way I can debug a large SP? Right now I am using print and
> select statements to output the value, but can I do it like normal
> programming language, set up break points, watch varaible values......
> TIA
>
>