Aha, so the use of a reserved word as a column name WAS my problem.
I've only used it in 3 tables! I'd better get started with changing things. Fortunately, it is in my power to do so.
Thanks, patrician and Terry.
When I used brackets, I got a different error saying that no such field
exists.
I'm using .NET SqlCommandBuilder class which automatically builds the
query for me. For eg, for an insert it generates the following:
INSERT INTO Press( Author , Date , Title , PublicationTitle ,
PageReference ...
I have an ASP.NET page which updates, deletes and adds records to/from one table in the database, but not another. The only difference between the two tables that I can see is that the 2nd table contains [Date] and [File] columns (Sql Server puts the brackets automatically to distinquish between...
I've worked it out!
Although the datagrid control, to which I bind the result of my query, does not display the 'value' column, I can still extract the descriptions programmatically.
Case closed.
Thanks, Terry, for your prompt reply. You've confirmed that using fn_listextendedproperty function is the way to go. It works perfectly in the SQL query analyser.
Unfortunately, for some reason, this function does not return the 'value' field (which is the description) when run from an ASP.NET...
In my strolling throught the SQL Server documentation sometime ago, I found how to hide system tables in the Enterprise Manager (leaving only your own tables showing). Now, that I want them back, I cannot find anywhere how to show them again.
Any suggestions?
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.