On Apr 11, 1:04 pm, "Tony Rogerson" <tonyroger...@torver.net> wrote:
> Hi Deepak,
>
> Check my other post to your thread, I use event notifications to capture the
> ALTER_TABLE event, you would store that in a normal database table.
>
> You could then use query notifications to capture that new row being
> inserted, i'll try and get an example working this weekend if I've time.
>
> Tony.
>
> --
> Tony Rogerson, SQL Server MVPhttp://sqlblogcasts.com/blogs/tonyrogerson
> [Ramblings from the field from a SQL consultant]http://sqlserverfaq.com
> [UK SQL User Community]
>
> "deepak" <tsdee...@gmail.com> wrote in message
>
> news:1176274029.002652.286610@d57g2000hsg.googlegroups.com...
>
>
>
> > Hi Remus,
>
> > Thanks for the reply, i thought about Event Notifications .but my
> > question is how do you communicate the notified event from the
> > sqlserver to the dotnet application,is there a way to do this? .
> > it will be very usefull ,if you could throw some light on the same,
>
> > Cheers
> > Deepak
>
> > On Apr 11, 10:17 am, "Remus Rusanu [MSFT]"
> > <remusronl...@microsoft.com> wrote:
> >> Query Notifications is for detecting when the content of a table was
> >> changed
> >> (rows inserted/delete/updated). To detect when the structure was changed
> >> (like adding a column) you can use Event Notifications for the ALTER
> >> TABLE
> >> event, seehttp://msdn2.microsoft.com/en-us/library/ms189453.aspx
>
> >> HTH,
> >> ~ Remus
>
> >> "deepak" <tsdee...@gmail.com> wrote in message
>
> >>news:1176267774.065319.105900@d57g2000hsg.googlegroups.com...
>
> >> > Hi There,
>
> >> > Is there a way in which Sqlserver can notify the dotnet application
> >> > when a new column is added . i believe we can not use Query
> >> > notifiaction here(correct me if i am wrong) .i am using sqlserver 2005
> >> > and dotnet 2.0 .
>
> >> > if anybody have an idea of how to do this or know any link in this
> >> > regard,please share with me.
>
> >> > Hope i am clear
>
> >> > Cheers
> >> > Deepak- Hide quoted text -
>
> >> - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

"deepak" <tsdeepak@gmail.com> wrote in message
news:1176274029.002652.286610@d57g2000hsg.googlegroups.com...
> Hi Remus,
>
> Thanks for the reply, i thought about Event Notifications .but my
> question is how do you communicate the notified event from the
> sqlserver to the dotnet application,is there a way to do this? .
> it will be very usefull ,if you could throw some light on the same,
>
> Cheers
> Deepak
>
>
>
> On Apr 11, 10:17 am, "Remus Rusanu [MSFT]"
> <remusronl...@microsoft.com> wrote:
>> Query Notifications is for detecting when the content of a table was
>> changed
>> (rows inserted/delete/updated). To detect when the structure was changed
>> (like adding a column) you can use Event Notifications for the ALTER
>> TABLE
>> event, seehttp://msdn2.microsoft.com/en-us/library/ms189453.aspx
>>
>> HTH,
>> ~ Remus
>>
>> "deepak" <tsdee...@gmail.com> wrote in message
>>
>> news:1176267774.065319.105900@d57g2000hsg.googlegroups.com...
>>
>>
>>
>> > Hi There,
>>
>> > Is there a way in which Sqlserver can notify the dotnet application
>> > when a new column is added . i believe we can not use Query
>> > notifiaction here(correct me if i am wrong) .i am using sqlserver 2005
>> > and dotnet 2.0 .
>>
>> > if anybody have an idea of how to do this or know any link in this
>> > regard,please share with me.
>>
>> > Hope i am clear
>>
>> > Cheers
>> > Deepak- Hide quoted text -
>>
>> - Show quoted text -
>
>