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

You way want to elaborate a bit about what you are trying to do. You meant
that your application should be able to handle a schema change in "real
time" ?

I would avoid to change the schema as part of an application normal flow. I
would likely use some data structure to store these as "metadata" (basically
each "extended property" would be stored as a row so that users can add new
properties without having to change tables schema).

---
Patrice

1176274216.895724.146***@w1g2000hsg.googlegroups.com...
Show quoteHide quote

On 10 Apr 2007 23:50:16 -0700, deepak wrote:

Show quoteHide quotePerhaps you'd better explain *why* the columns are being added to the
database schema during the execution of the application ...

OO Architecture Question
Append Nodes to existing XML File/Document .net 1.1
Net Framework 3 loads up 2 as well?
Master Volume Control in C#
socket programming in asp.net possible?