Friday, February 24, 2012

Is there any sp deals with the table sysproperties ?

Hi,
Is the table sysproperties a new added one to sql 8.0 ?
Because I cannot found the description about it in SQL
Server Online book.
BTW: Is there any sp deals with this table ?
Thansk
.Hi,
Thanks.
>--Original Message--
>Hi,
>sysproperties is used to store the extended
properties .Adding and
>retrieving extended properties was introduced in
SQL2000.But for that there
>is no need to use sysproperties, instead you can use the
system functions
>sp_addextendedproperty and ::fn_listextendedproperty.
>--
>Dinesh.
>SQL Server FAQ at
>http://www.tkdinesh.com
>"gohigh" <gohigh@.sh163.net> wrote in message
>news:01e201c356b2$45835c30$a101280a@.phx.gbl...
>> Hi,
>> Is the table sysproperties a new added one to sql 8.0 ?
>> Because I cannot found the description about it in SQL
>> Server Online book.
>> BTW: Is there any sp deals with this table ?
>> Thansk
>> .
>>
>
>.
>

No comments:

Post a Comment