• Thanks for your offer this article.

    I met some errors after running your scripts; ERRORLOG memessageike this...

    ...

    2009-02-27 17:07:35.01 spid14s Error: 9644, Severity: 16, State: 14.

    2009-02-27 17:07:35.01 spid14s An error occurred in the service broker message dispatcher, Error: 15517 State: 1.

    and I could resolve this problem for below code,

    from http://social.technet.microsoft.com/Forums/en-US/sqlservicebroker/thread/a5af6e9a-f3b6-4b73-ae3d-95238502d28f/

    ALTER AUTHORIZATION ON DATABASE::[My_DB_Name] TO [SA];

    It works fine. I like it. 🙂