| Thread | Last Post | Replies |
|
| Design question with SQL Service Broker - External Activation | 29 Jun 2006 22:06 GMT | 5 |
In my current project is suitable for a messaging scenario so we decided to use SQL Broker to handle it. I chose External Activation, since the actual message processing has some complex logic and besides that I don't want to have too much stress under SQL CLR Host. I'd already seen ...
|
| Sending Messages to Remote SQL Servers | 29 Jun 2006 14:31 GMT | 2 |
I am trying to find an example of how to send messages to a remote sql server. Books online is cryptic at best and the other examples I have seen are all very basic. Any pointers much appreciated
|
| service broker permission | 27 Jun 2006 16:17 GMT | 1 |
I have a queue execute on dbo and calling a stored procedure to process some data. the stored procedure calls a view that references a table on another database on the same server. I am getting a denied error when the procedure select from the view? if I login as sa and select ...
|
| Problems with service broker network access | 26 Jun 2006 12:57 GMT | 2 |
I have some problems with service broker network access by using windows authentication. The source and target instances are started under Local System. According to the BookOnline: "Note:
|
| Activation and rollback | 09 Jun 2006 04:11 GMT | 2 |
When a transaction containing a receive command is rolled back 5 times, the is_received_enabled is turned off. Is the magic number (5) for turning the queue off configurable, and is there any way to monitor or reset that count? Thanks,
|
| Some questions on Service Broker settings | 07 Jun 2006 15:35 GMT | 5 |
I have some questions on Service Broker settings: 1) Could you clarify the following settings for creating conversation between two local databases? In order to create such conversation you prescribe to set the TRUSTWORTHY
|