async_tsql icon indicating copy to clipboard operation
async_tsql copied to clipboard

Documentation: Add tip to Read Me about SET ENABLE_BROKER (for people who don't know it is needed)

Open ejlofgren opened this issue 9 years ago • 0 comments

Thank you so much for sharing this code!

If you wouldn't mind editing https://github.com/rusanu/async_tsql/blob/master/README.md and adding a note along these lines, it'd probably help other newbies like me:

To actually get your SPROCS to be called, you need to SET ENABLE_BROKER on the database, e.g.:

ALTER DATABASE [Database_name] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;

Here's where I shared this tip on StackOverflow: http://stackoverflow.com/a/31861317/908677

Thanks again!

  • Elijah Lofgren

ejlofgren avatar Aug 06 '15 16:08 ejlofgren