Extended Property - Sql Server 2005

Hello All,
How would we use extended property in SQL Server 2005?
Thanks
Shail ShrivastavaHi
It is not clear what you mean by "use extended property"!
The functions to reteive and set extended properties are the same as in SQL
2000 sp_addextendedproperty, fn_listextendedproperty,
sp_dropextendedproperty, sp_updateextendedproperty. You can also manipulate
them in SQL Server Management Studio by right clicking the table/column
(depending on where in the tree you are) and choosing Properties. Extended
Properties will be in the list for "select a page". You can then click on th
e
appropriate cells to add a new extended property or change an existing one.
John
"shailbpl@.gmail.com" wrote:

> Hello All,
> How would we use extended property in SQL Server 2005?
> Thanks
> Shail Shrivastava
>|||Hi,
Sorry, I did not explain in detail.
I want to know in what situation it is best fit. I know how to use it.
What other featurs in Sql Server2005 in comparision to SS 2000.
Thanks
Shail Shrivastava
John Bell wrote:
> Hi
> It is not clear what you mean by "use extended property"!
> The functions to reteive and set extended properties are the same as in SQ
L
> 2000 sp_addextendedproperty, fn_listextendedproperty,
> sp_dropextendedproperty, sp_updateextendedproperty. You can also manipulat
e
> them in SQL Server Management Studio by right clicking the table/column
> (depending on where in the tree you are) and choosing Properties. Extended
> Properties will be in the list for "select a page". You can then click on
the
> appropriate cells to add a new extended property or change an existing one
.
> John
>
> "shailbpl@.gmail.com" wrote:
>|||These are for your use, whatever your imagination finds. For instance, you c
an add things like:
Written By
Last modified by
A description or the purpose
...
You define your own tags and the values for the tags. The GUI tools has the
option to add a
description, which uses a tag named (I think) MS_Description.
I believe that Bill Vaughn write a good article on this topic in SQL Mag som
e 3-4 years ago (yes,
the feature was available in 2000).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<shailbpl@.gmail.com> wrote in message news:1150102503.607276.174940@.j55g2000cwa.googlegroup
s.com...
> Hi,
> Sorry, I did not explain in detail.
> I want to know in what situation it is best fit. I know how to use it.
> What other featurs in Sql Server2005 in comparision to SS 2000.
> Thanks
> Shail Shrivastava
>
> John Bell wrote:
>|||Hi
In addition to Bill Vaughn's articles in SQL Server Magazine, check out
those by Brian Moran on creating and maintaining a data dictionary. Most are
subscriber only.
John
"shailbpl@.gmail.com" wrote:

> Hi,
> Sorry, I did not explain in detail.
> I want to know in what situation it is best fit. I know how to use it.
> What other featurs in Sql Server2005 in comparision to SS 2000.
> Thanks
> Shail Shrivastava
>
> John Bell wrote:
>