Retrieve error message from MS SQL to QTP

I have to load files to MS SQL:

exec [database].[dbo].[tablename]  @FullFilePath = 'fullpathtofile'

File has trailer and header. Case invalid or missing header or trailer, stored procedure should generate error. How can I retrieve that error to QTP?

I tried

if err.number<>0 then
MsgBox hex(err.number) & vbcrlf & err.description

but it did not result.