How to capture Error handling of LiteSpeed extended stored procedures?
WORKAROUND:
--create table SLSerrors..backuperrors (dbname varchar(128), errcode [int])
declare @returncode int
declare @database varchar(128)
set @database='master'
exec @returnCode = master.dbo.xp_backup_database @filename='C:\Backup\C:\Backup\2005\%D%H%M%S.bak', @database=@database
if @returnCode != 0 begin
insert into SLSerrors..backuperrors values (@database, @returncode)
end
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center