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.