Viewing 15 posts - 5,656 through 5,670 (of 7,636 total)
OK, you should try to reset the Service Broker on this DB then. Execute this commands and try you trigger again:
USE Master
ALTER Database [Your DB] Set Enable_Broker with rollback...
August 31, 2008 at 9:43 pm
These are NOT Logon Event Notifications. These are ALTER TABLE Event Notifications.
August 31, 2008 at 7:17 pm
Please post the entire output from sys.transmission_queue.
August 31, 2008 at 4:44 pm
Steve Jones - Editor (8/31/2008)
What about a fast triangular join? Maybe it will flatten out to a linear algorithm :hehe:
Oh, it'll be faster, but it will still be an O(n2)...
August 31, 2008 at 4:01 pm
The first is that I wonder if all the query optimizer's various algorithms for read-ahead, costing, etc. will be rendered obsolete. (by Solid State Disks)
Yes, "Absolutely". 🙂
The large majority...
August 31, 2008 at 11:08 am
You can check for Database level DDL Trigers with this command:
Select * from [DatabaseName.]sys.triggers Where parent_class_desc = 'DATABASE'
August 31, 2008 at 10:00 am
My personal suspicion is that there is some unprintable character in their Domain Login Name. Try what Renuka said: try to find them in SysProcesses, if you can and...
August 31, 2008 at 9:56 am
I think that you should also check for a Create Proc DDL trigger on this database.
August 31, 2008 at 9:21 am
Are the other databases that it works on in the same server?
If the answer to this is Yes, then goto the DB that does not work, right-click on it in...
August 31, 2008 at 9:19 am
Are you sure that anyone is logged in with that username?
August 30, 2008 at 10:11 pm
Try to fire the Logon trigger, then do a: Select * From sys.transmission_queue and post the results here.
August 30, 2008 at 8:44 pm
Try it like this:
sp_who 'TRAFICO\production'
August 30, 2008 at 8:40 pm
Jeff Moden (8/30/2008)
rbarryyoung (8/30/2008)
Just to clarify: Are you getting this error when you try to Create it or when you try to Run it?
Not sure why we're trying to correct...
August 30, 2008 at 4:20 pm
I should add that my example above was the simplest one of these that I have done. I have been working with two other customers for over 20 months...
August 30, 2008 at 4:09 pm
Viewing 15 posts - 5,656 through 5,670 (of 7,636 total)