Quick help please

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bobby Henningsen - 27 Feb 2006 20:04 GMT

I've made a demo showing the use of an Event Notification. It has worked a
100 times before but all of a sudden it doesn't !!?? Here's the code and
everything else is in place. I've just installed the server and it's a
Developåer Edition and I'm using the good old Northwind Database. It has the
right level and I've enabled the Service Broker. So what is wrong. Am I
missing some options that has to be set ??? it can't be the code. Worked
before. Changing the code to use the server_guid doesn't work either. My
queue is empty!!

Create Event Notification NotifyDeadlock
On Server

For Deadlock_Graph

To Service 'NotifyService','current database'

Regards :)
Bobby Henningsen

Reply to this Message

Roger Wolter[MSFT] - 27 Feb 2006 20:41 GMT

When you say demo, I start to think about my problem around writing a demo
while hooked to the domain and then trying to run it not connected to the
domain. This will give you an error in the sys.transmission_queue that says
it can't send messages in the security context. The answer here is usually
to make the database owned by SA instead of a Windows user.
ALTER AUTHORIZATION ON DATABASE::[NorthWind] TO [sa];

You could also have caused problems by detaching and attaching the database
or by rolling back a receive 5 times in a row. The error in
sys.transmission_queue should tell you if this has happened.

For troubleshooting try this:

http://blogs.msdn.com/remusrusanu/archive/2005/12/20/506221.aspx

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

> I've made a demo showing the use of an Event Notification. It has worked a
> 100 times before but all of a sudden it doesn't !!?? Here's the code and
[quoted text clipped - 15 lines]
> Regards :)
> Bobby Henningsen

Reply to this Message

Bobby Henningsen - 27 Feb 2006 22:23 GMT

Thanx a bunch. I've not tried it yetbut I'm sure it the issue about the
owner as i suddenly remember seeing this before. Just seem to have forgot
because the error isn't that logical to me :)) Thx again.

Regards .)
Bobby Henningsen

> When you say demo, I start to think about my problem around writing a demo
> while hooked to the domain and then trying to run it not connected to the
[quoted text clipped - 31 lines]
>> Regards :)
>> Bobby Henningsen

Reply to this Message