I want to use the SQL Server Service Broker to generate a message (inside SQL Server) and for it to be read in an external C# app.
I am limited to Windows 2003 running SQL Server 2005. I've read a bunch of articles, that allude to this being a possibility, but I do not see an example anywhere. Is this possible?
To connect to the Database Engine from another computer On a second computer that contains the SQL Server client tools, log in with an account authorized to connect to SQL Server, and open Management Studio. In the Connect to Server dialog box, confirm Database Engine in the Server type box.
T-SQL has statements for accessing Service Broker: SEND, RECEIVE and others. You can use ADO.NET to execute them.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With