Jack/Steve,

Thanks for all your suggestions.

Jack

Question regarding the ADD_SERVER_ROLE_MEMBER.

"ADD_SERVER_ROLE_MEMBER" does not support synchronous trigger registration. Do you have any suggestion where I can look to resolve this issue. I'm not familiar the Service Broker.