"Joe Webb" <joew@webbtechsolutions.com> wrote in message
news:9ck512pjpjbnc126l4v3l3aund6b7sojtk@4ax.com...
> Since your question is about SqlDependency and Query Notifications,
> you'll probably have more luck in another newsgroup - may
> microsoft.public.sqlserver.programming. This one is for SQL Server
> Notification Services.
>
>
>
> --
> Joe Webb
> SQL Server MVP
> http://www.sqlns.com
>
>
> ~~~
> Get up to speed quickly with SQLNS
> http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
>
> I support PASS, the Professional Association for SQL Server.
> (www.sqlpass.org)
>
>
> On Fri, 10 Mar 2006 17:13:06 -0600, "skg" <skg@yahoo.com> wrote:
>
>>Looks like i have to use threading!
>>http://msdn2.microsoft.com/en-us/library/3ht3391b(VS.80).aspx
>>
>>"skg" <skg@yahoo.com> wrote in message
>>news:%23Pu$vfGRGHA.4696@tk2msftngp13.phx.gbl...
>>>i am finding the notification is triggered only once when the field
>>>changes
>>>first time. Its not triggered second time. How can i have it trigger
>>>everytime there is a change in the field.
>>>
>>> Here is code snippet. thx
>>>
>>> ...
>>>
>>> ..static void Main()
>>>
>>> {
>>>
>>> SqlCommand cmd = new SqlCommand("SELECT au_id, au_lname FROM
>>> dbo.authors",
>>> conn))
>>>
>>> SqlDependency depend = new SqlDependency(cmd, null,0);
>>>
>>> depend.OnChange += new OnChangeEventHandler(MyOnChanged);
>>>
>>> conn.Open();
>>>
>>> SqlDataReader rdr = cmd.ExecuteReader();
>>>
>>> ...
>>>
>>> ...
>>>
>>> }
>>>
>>> MyOnChanged(object caller, SqlNotificationEventArgs e)
>>>
>>> {
>>>
>>> Console.WriteLine("result has changed");
>>>
>>> Console.WriteLine("Source " + e.Source);
>>>
>>> Console.WriteLine("Type " + e.Type);
>>>
>>> Console.WriteLine("Info " + e.Info);
>>>
>>> }
>>>
>>>
>>>
>>