• For SQL Server 2005, the compatiblity level can maximum be 90 and there is no command like HONOR_BROKER_PRIORITY

    I tried this code in both SQL 2005 and 2008. i got error for the 2 properties i said above for 2005 and in 2008 it got compiled well...