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
Patrice - 11 Apr 2007 10:26 GMT
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
> Hi There,
>
[quoted text clipped - 11 lines]
> Cheers
> Deepak
Rad [Visual C# MVP] - 11 Apr 2007 19:47 GMT
> Hi There,
>
[quoted text clipped - 11 lines]
> Cheers
> Deepak
Perhaps you'd better explain *why* the columns are being added to the
database schema during the execution of the application ...

Signature
Bits.Bytes
http://bytes.thinkersroom.com