khushbu (1/21/2013)
Hi,Need some help in determining if the below statement is good enough.
How can I get statement to execute in Catch block?
I'm out of ideas..
IF (SELECT is_broker_enabled FROM sys.databases WHERE name = 'MYDB') = 0
BEGIN TRY
ALTER DATABASE MYDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE MYDB SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE
ALTER DATABASE MYDB SET MULTI_USER;
END TRY
BEGIN CATCH
ALTER DATABASE MYDB SET NEW_BROKER
END CATCH
Do you want that whenever ANY try block get failed due to any reason , the stmt in catch get fired ? i dont think so. Why can't you use IF-ELSE block, Catch is generally use to handle errors.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)