code_junkie

SQL Server 2005 - Error_Message() not showing full message

Nov 11th, 2011
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. BACKUP DATABASE NonExistantDB TO DISK = 'C:TEMPNonExistantDB.bak'
  2.  
  3. BEGIN TRY
  4. BACKUP DATABASE NonExistantDB TO DISK = 'C:TEMPNonExistantDB.bak'
  5. END TRY
  6. BEGIN CATCH
  7. PRINT ERROR_MESSAGE()
  8. END CATCH
  9.  
  10. BACKUP DATABASE NonExistantDB TO DISK = 'C:TEMPNonExistantDB.bak'
Add Comment
Please, Sign In to add comment