Extended Properties on a table

[Vayse]

I'm using an ADP on two different sites, each with its own SQL 2000 backend.
The design of both SQL databases is the same. When I use Redgates SQL
Compare, I can see that some of the tables now have extended properties.
These properties are present in one database, and not the other.
I never set any extended properties, at least none that I remember!
I looked up the help, but it mentions stored procedures to maintain the
extended properties.
1) Is there a GUI that lists these properties?
2) An easy way to delete all the extended properties?
3) Can Access generate these properties? I'm using Access 2003, with users
have from 2000 on.

Thanks
Vayse

 

[Patrice]

Access uses extended properties for some information when you edit the
table through an ADP project (for example field description).

 

[PFC Sadr]

when I was working at MICROSOFT I demanded a GUI interface in ADP for
the management of these extended properties.

I mean; a friggin datasheet view would have done the trick.

But MS claimed to me that 'anyone that needs to do this can do this
via TSQL'

I thank you for your question; I did my part to get this funcitonality
out of Microsoft


but they're too busy playing Xbox and inventing new languages like C#
to give a shit about MS Access..

I urge you to move to Dreamweaver, PHP and mySql.
that is the only way to protect yourself from Microsoft.

-Aaron MothaFuckin Kempf

 

[Vayse]

Thanks. How do I view these extended properties in SQL server?

 

[Patrice]

See :
http://msdn2.microsoft.com/en-us/library/ms186989.aspx
(Viewing Extended Properties)

Hope it helps.

 

[Vayse]

Thanks. I was hoping there was a GUI in 2000, but it seems its only in 2005.
Still, at least I can view them as text.

 

[Sylvain Lafontaine]

If you have installed the client tools for SQL-Server 2000 (Enterprise
Manager, Query Analyser, Profiler, etc.), then you can use the explorer
window for objects in Query Analyser (QA): click on F8 if this window is
hidden and take a look at the contextual menu (right click) for an option to
show the extended properties for each table or for each column.

Notice that the extended properties collection for the table is different
from the collection of each column.

In ADP, these extended properties are only used when you directly open a
table for viewing and are useless if you deal only with forms, reports and
modules/macros. Don't bother with them if they are not replicated to
another system.

 

[Vayse]

Perfect - thanks.

If you have installed the client tools for SQL-Server 2000 (Enterprise
Manager, Query Analyser, Profiler, etc.), then you can use the explorer
window for objects in Query Analyser (QA): click on F8 if this window is
hidden and take a look at the contextual menu (right click) for an option
to show the extended properties for each table or for each column.

Notice that the extended properties collection for the table is different
from the collection of each column.

In ADP, these extended properties are only used when you directly open a
table for viewing and are useless if you deal only with forms, reports and
modules/macros. Don't bother with them if they are not replicated to
another system.