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.
Best Regards
Virusim