Hi

I was implementing a feature using SQLDependency in my current application and I found something funny that is really bugging me. I cannot use 3-part names when naming the database.

If I use this query, everything is working correctly:

"SELECT MAJDate FROM dbo.DatabaseEvent WHERE Event = 'BloombergUpdate'"

If I use a 3-part name, like the following one, events are raised non-stop:

"SELECT MAJDate FROM HedgeFund_PRD.dbo.DatabaseEvent WHERE Event = 'BloombergUpdate'"

I always use 3-part names because the application is connecting to multiple databases on the same server (and I often have multiple versions of the same database on my laptop – different stages)

Do you know any workaround to this problem so that I can use the 3-part names?