I am unable to use THROW SQL Server 2008 R2 -

sql server 2008 r2 management studio not recognized throw in below example, says

incorrect syntax near throw

i trying throw error here, can handled in website when insert same value twice.

begin try  insert businessid (businessid) values (@id)  insert businessid (businessid) values (@id)  end try  begin catch  print 'pk exist' throw end catch 

throw statement introduced in sql server 2012

http://msdn.microsoft.com/en-us/library/ee677615.aspx

you can use raiserror instead.

http://msdn.microsoft.com/en-us/library/483588bd-021b-4eae-b4ee-216268003e79(v=sql.105)

begin catch     declare @errormessage nvarchar(4000);     declare @errorseverity int;     declare @errorstate int;      select          @errormessage = error_message(),         @errorseverity = error_severity(),         @errorstate = error_state();      raiserror (@errormessage, -- message text.                @errorseverity, -- severity.                @errorstate -- state.                ); end catch;