Service Broker!

The database user had created some routes, services, queues, etc.

They were no longer used, deleted them and the user could be removed.

The DB User is not the DB owner (my AD account is) and has no schemas. I was able to remove all of its roles and it became disabled...

Tried "select * from sys.event_notifications"; it returned no rows!

I loved the psuedo "Are we there yet?". Thanks for taking the time!

Bridge of Sighs - Robin Trower

Animals - Pink Floyd

Heaven and Hell - Sabbath

Neil Young Greatest Hits

Any... Stevie Ray Vaughn

I simply use syntax like:

convert(varchar, @EndDate, 101) >= '2/6/2007'

This way your date with a time is converted only to a date and will always be equal or less than the...

Thanks Steve.

I thought I had tried this before and found it not fully detaching the Job from the trigger. I am going to give it another shot... no pun intended.

...

Thanks Steve.

No sweat with backing up from 7.0 and restoring to v.2000?

I do need logins and everything else, not familiar with DTS but I will research it.

I want all of the trigger code to execute if possible. For example; I send emails when some records are added. I do not want the transaction to roll...