You can use new debugging capabilities with SQL Server 2008.

>Sql server 2000 simple questions
>
>Hi,
>
>I had the following problem with Sql 2k
>
>01) if I want to backup my original table, when I export it to another
>new table name, all my key, columns and permissing is gone. Therefore, how
>can I ensure that table that I going to backup will not lost all those
>primary key and other setting.
>
>02) if I had written a new stored procedure to execute some other
>colleague written stored procedure which is many page long,
>how can I do to debug my stored procedure. Any tools or
>method that will assist/help me on debugging.
>
>03) How do I use the RaisError() function in sql server
>to debug my stored procedure, pls advise with example
>
>Anyone with above expertise, pls advise/help me.
>Thank you.