Notification when a new column is added to a table

  • Thread starter Thread starter deepak
  • Start date Start date
D

deepak

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).
 
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
Click to expand...

Perhaps you'd better explain *why* the columns are being added to the
database schema during the execution of the application ...
 
Back
Top