>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?
To switch data sets like that, I usually use another connection string. Are there any advantages of using the 3-part names such as you mentioned?