Service Broker Gotchas - Its case sensitive
I've started using service broker and its full of new terminology. This will be a set of posts of the gotchas I've found on the way.
The first is "case". Most of us run SQL in case insensitive mode so we can refer to our tables and columns by what ever case is trendy at the time, camel case, title case, upper case etc.
Well in Service Broker case is very important because a number of the bits of service broker can reside on more than one server and to avoid any comparision issues all comparisions are bitwise comparisions.
The objects that are case sensitive are
- services
- contracts
- message types
This is explained in this BOL page
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlmsg9/html/4efdf2ff-2f09-4dfa-879b-d0dfb047fae4.htm
-