Comment Field in MS SQL Server - Like Comment field in MS Access

[JordanR]

Is it possible to set a table field in MS SQL Server to be like a comment field in MS Access.
If so, how do I set it up and are there any security risks?

Thanks

 

[vongrunt]

AFAIK can be done with extended properties but isn't much practical:

execute sp_addextendedproperty 'Comment', 'Blah blah', 'user', 'dbo', 'table', 'myFirstTable', null, null
execute sp_addextendedproperty 'Comment', 'Blah blah 2', 'user', 'dbo', 'table', 'mySecondTable', null, null

select A.name, B.value as comment from sysobjects A
left join ::fn_listextendedproperty ('Comment', 'user', 'dbo', 'table', null, null, null ) B on A.name=B.objname
where A.xtype = 'U' order by A.name