I'm still assimilating little tidbits of information about the Nov-Dec CTP build. Put this one in your pubs database in the CTP:
create procedure deletejob (@id int)asbegin try delete jobs where job_id = @idend trybegin catch -- you knew about these print error_number() print error_message() print error_severity() print error_state() -- these are undoc'd but work in the CTP print error_line() -- line number print error_procedure() -- procedure nameend catchgo
execute deletejob 2go
Theme design by Jelle Druyts
Pick a theme: BlogXP sqlx BlogXP sqlx
Powered by: newtelligence dasBlog 2.0.7226.0
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.
© Copyright 2008, Bob Beauchemin
E-mail