Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Error Handling

Author  Topic  PoojaJ Starting Member 10 Posts Posted - 2007-02-07 : 03:51:51 I m trying to take Database Backup using a Dynamic Query with BACKUP DATABASE command in a stored procedure. I tried to capture the Error i.e 3257 which indicates insufficeient disk space. But on executing the Stored procedure and seeing the Execution thrugh Profiler an exception is shown with the same err no. and the error handling that i hav done is surpassed. Could u tell me y this happens and wats the solution. Also is there a way to capture error msgs corresponding to SQL error no. Thank you in advance