Query Notification

Hi,
I have problem with SqlDependency and could not use any sample in VB.NET
2005. Some samples I found in internet, use Start mehod that I don't have in
my SqlDependency instance. And some of them use Id and Servie properties of
SqlNotificationRequest that VS IDE suggests using UserData instead of them.
I would be most grateful if anybody could post a URL to VB sample so that I
can use.
I am using SQL Server 2005 - 9.00.1187.07 with VS.NET Beta 2.0.50512
Thanks again,
Leila
BTW: Where is SQL-CLR group'!! :(You should upgrade to RTM if possible; changes to SqlDependency occurred in
the final CTP (September); I'm not sure if there were any more changes
between then and RTM.
Also, keep in mind that the Start method is static. You don't call it per
SqlDependency object, but rather for the entire application.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Leila" <Leilas@.hotpop.com> wrote in message
news:OBwjgkf5FHA.632@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have problem with SqlDependency and could not use any sample in VB.NET
> 2005. Some samples I found in internet, use Start mehod that I don't have
> in
> my SqlDependency instance. And some of them use Id and Servie properties
> of
> SqlNotificationRequest that VS IDE suggests using UserData instead of
> them.
> I would be most grateful if anybody could post a URL to VB sample so that
> I
> can use.
> I am using SQL Server 2005 - 9.00.1187.07 with VS.NET Beta 2.0.50512
> Thanks again,
> Leila
> BTW: Where is SQL-CLR group'!! :(
>|||Thanks indeed Adam,
Another question: Can I receive the notifications generated by EVENT
NOTIFICATION (such as DDL events) in my win app?
Finally I could do this for query notifications but I'd like to know if the
same thing can be done for other messages?
Leila
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:%23270H5m5FHA.1864@.TK2MSFTNGP12.phx.gbl...
> You should upgrade to RTM if possible; changes to SqlDependency occurred
> in the final CTP (September); I'm not sure if there were any more changes
> between then and RTM.
> Also, keep in mind that the Start method is static. You don't call it per
> SqlDependency object, but rather for the entire application.
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:OBwjgkf5FHA.632@.TK2MSFTNGP10.phx.gbl...
>