SQL Server Performance Forum – Threads Archive

How to capture error exception?

Hi all.
i have manage upto 10 servers. i have a script. this script check all servers job status using openrowset command. if one statement failed then allother statements are terminated. but i need contiune with error. How it is possible? Thanks
S. Ramesh

Hi,
you may use RAISEERROR , refer below article for more.
http://msdn2.microsoft.com/en-us/library/ms177497.aspx Regards Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
————————
http://hemantgirisgoswami.blogspot.com

]]>