column description?

Hi All
how can i access a normal sql server 2000 tables column description and give it a value from a query or from a stored procedure?
thanks for the help!
Hi,
Did you meant extended property? If yes then;
Have a look into procedure sp_addextendedproperty in books online.
Sample:-
This example adds the property ('caption,' 'Employee ID') to column 'ID' in
table 'T1.'
CREATE table T1 (id int , name char (20))
GO
EXEC sp_addextendedproperty 'caption', 'Employee ID', 'user', dbo,
'table', T1, 'column', id
See the function ::FN_LISTEXTENDEDPROPERTY to retrive the extended property.
Thanks
Hari
MCDBA
"m.ahrens" <mahrens@.discussions.microsoft.com> wrote in message
news:AD5C515B-5CF1-41A5-B264-29BB565DE8C6@.microsoft.com...
> Hi All
> how can i access a normal sql server 2000 tables column description and
give it a value from a query or from a stored procedure?
> thanks for the help!
|||See fn_listextendedproperty and sp_addextendedproperty in SQL Server 2000
Books Online.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"m.ahrens" <mahrens@.discussions.microsoft.com> wrote in message
news:AD5C515B-5CF1-41A5-B264-29BB565DE8C6@.microsoft.com...
Hi All
how can i access a normal sql server 2000 tables column description and give
it a value from a query or from a stored procedure?
thanks for the help!
|||Hi,
Did you meant extended property? If yes then;
Have a look into procedure sp_addextendedproperty in books online.
Sample:-
This example adds the property ('caption,' 'Employee ID') to column 'ID' in
table 'T1.'
CREATE table T1 (id int , name char (20))
GO
EXEC sp_addextendedproperty 'caption', 'Employee ID', 'user', dbo,
'table', T1, 'column', id
See the function ::FN_LISTEXTENDEDPROPERTY to retrive the extended property.
Thanks
Hari
MCDBA
"m.ahrens" <mahrens@.discussions.microsoft.com> wrote in message
news:AD5C515B-5CF1-41A5-B264-29BB565DE8C6@.microsoft.com...
> Hi All
> how can i access a normal sql server 2000 tables column description and
give it a value from a query or from a stored procedure?
> thanks for the help!
|||See fn_listextendedproperty and sp_addextendedproperty in SQL Server 2000
Books Online.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"m.ahrens" <mahrens@.discussions.microsoft.com> wrote in message
news:AD5C515B-5CF1-41A5-B264-29BB565DE8C6@.microsoft.com...
Hi All
how can i access a normal sql server 2000 tables column description and give
it a value from a query or from a stored procedure?
thanks for the help!
|||http://www.aspfaq.com/2244
http://www.aspfaq.com/
(Reverse address to reply.)
"m.ahrens" <mahrens@.discussions.microsoft.com> wrote in message
news:AD5C515B-5CF1-41A5-B264-29BB565DE8C6@.microsoft.com...
> Hi All
> how can i access a normal sql server 2000 tables column description and
give it a value from a query or from a stored procedure?
> thanks for the help!
|||http://www.aspfaq.com/2244
http://www.aspfaq.com/
(Reverse address to reply.)
"m.ahrens" <mahrens@.discussions.microsoft.com> wrote in message
news:AD5C515B-5CF1-41A5-B264-29BB565DE8C6@.microsoft.com...
> Hi All
> how can i access a normal sql server 2000 tables column description and
give it a value from a query or from a stored procedure?
> thanks for the help!
|||Thanks for the help!
I got it!!
have a nice day!
"Hari" wrote:

> Hi,
> Did you meant extended property? If yes then;
> Have a look into procedure sp_addextendedproperty in books online.
> Sample:-
> This example adds the property ('caption,' 'Employee ID') to column 'ID' in
> table 'T1.'
> CREATE table T1 (id int , name char (20))
> GO
> EXEC sp_addextendedproperty 'caption', 'Employee ID', 'user', dbo,
> 'table', T1, 'column', id
>
> See the function ::FN_LISTEXTENDEDPROPERTY to retrive the extended property.
> --
> Thanks
> Hari
> MCDBA
> "m.ahrens" <mahrens@.discussions.microsoft.com> wrote in message
> news:AD5C515B-5CF1-41A5-B264-29BB565DE8C6@.microsoft.com...
> give it a value from a query or from a stored procedure?
>
>
|||Thanks for the help!
I got it!!
have a nice day!
"Hari" wrote:

> Hi,
> Did you meant extended property? If yes then;
> Have a look into procedure sp_addextendedproperty in books online.
> Sample:-
> This example adds the property ('caption,' 'Employee ID') to column 'ID' in
> table 'T1.'
> CREATE table T1 (id int , name char (20))
> GO
> EXEC sp_addextendedproperty 'caption', 'Employee ID', 'user', dbo,
> 'table', T1, 'column', id
>
> See the function ::FN_LISTEXTENDEDPROPERTY to retrive the extended property.
> --
> Thanks
> Hari
> MCDBA
> "m.ahrens" <mahrens@.discussions.microsoft.com> wrote in message
> news:AD5C515B-5CF1-41A5-B264-29BB565DE8C6@.microsoft.com...
> give it a value from a query or from a stored procedure?
>
>