I have 2 questions regarding column descriptions stored in sysproperties.
After many hours of searching (as it is not documented), I finally found where the column descriptions are stored and how to retrieve them (this newsgroup helped me to find some of the answers). But I'm puzzled, why column descriptions are not stored in syscolumns with other column-related info?
I was also wondering why sysproperties table does not have public permissions to SELECT (while most other system tables have public permission to select by default). It is as if such column info is protected. I can't see why it should be. Perhaps, I'm missing something. Does anybody know the answer to these questions?
The reason I'm asking is because I have a .NET web user control that uses column descriptions as control tooltips. However, it doesn't have administrators access rights, therefore it does not have permission to access sysproperties.
Thanks.
After many hours of searching (as it is not documented), I finally found where the column descriptions are stored and how to retrieve them (this newsgroup helped me to find some of the answers). But I'm puzzled, why column descriptions are not stored in syscolumns with other column-related info?
I was also wondering why sysproperties table does not have public permissions to SELECT (while most other system tables have public permission to select by default). It is as if such column info is protected. I can't see why it should be. Perhaps, I'm missing something. Does anybody know the answer to these questions?
The reason I'm asking is because I have a .NET web user control that uses column descriptions as control tooltips. However, it doesn't have administrators access rights, therefore it does not have permission to access sysproperties.
Thanks.