Cannot catch the error when the backup file is in use
I cannot catch the error because it returns a text message instead of a rowset as usual.
The process cannot access the file because it is being used by another process. SQL Backup exit code: 500 [SQLSTATE 42000] (Error 1). The step failed
SQL Backup version 126.96.36.19925
Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)