Which collation is used for Service Broker messa

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Which collation is used for Service Broker messages sent between the instances?

You have two Service Broker instances running. One is on SQL1 with the default collation and the other is on SQL2 setup for French collation. Which collation is used for Service Broker messages sent between the instances?

Answer
Service Broker does not consider the collation, using byte-by-byte matching for names.

Explanation
Neither collation is used. Service Broker operates in a collation independent method that removes collation information from the messages.

(Continued on next question...)

Other Job Interview Questions

• In SSIS, what is the difference between output columns and external columns?
• You created a SQL Server 2005 Service Broker queue ....
• How can you you be sure that a SOAP queries that are looking for a WSDL response will be provided?
• Can a deterministic computed column be full-text indexed in SQL Server 2005? Submitted by Matija Lah
• What message types exist in SQL Server 2005 Service Broker?
• What does the Log Reader agent in SQL Server 2005 replication do?
• You have a SQL Server 2005 cluster and need to add anti-virus software as per your corporate standards. What should you exclude from scans?
• If you want to apply a hot fix to SQL Server 2005, do you need to apply them all in order?
• What does the sqlwb utility do?
• In replication, what is each set of the source data that is replicated from the source server called?
• More...