This is a high level question. We are going to be reviewing our current system architecture and a little bird, a good friend of mine who is one of the most knowledgable SQL Server MVPs I know, told me I should take a look at Service Broker. Well I have
I have successfully setup Login Auditing using Service Broker, but have an application that tries to login using invalid characters (猀愀). 2 empty squares. I have been unsuccessful in trapping this as an error in my Stored Proc