If your connection hangs while attempting to start sql server broker service, its likely caused by the system trying to gain exclusive access to your database. Some people recommend stopping and restarting the sql server instance. I find that a little heavy-handed, like swatting a fly with a sledge hammer. Instead switch the database into single user mode, enable the broker service, and restore the database to multi-user mode. 1) Set the database to single user mode: ALTER DATABASE [DBNAME] SET SINGLE_USER...

I recently migrated my dev environment to a new pc. I moved over all the databases and reattached them. Unfortunately, I soon discovered my SSBS services weren’t working. I was sending messages to my service, but nothing was showing up in the queue. I added logging and monitoring to the stored procs that act as an entry point to the services, and the stored procs I use for activation. Still, nothing. When I ran the Broker Server Diagnostic tool (ssbdiagnose) (available in {Program files}\Microsoft...

I recently had to write a data migration script from one SQL Server DB to another one. I could have used SSIS, but it would have required a learning curve that our timeframe didn't permit. A few hours later I had a functioning script that moved over most of the useful data (2 days later I discovered some more data that had to be migrated, but that's a separate issue). In developing the migration script I had to deal with a series of key pool tables, each with their own identity columns for key generation....