Search results for query: *

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...

Thanks, codestorm. That was prompt and right on the ball.

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...