what is sqlserver database remark returned fom sp_databases?
The sp_databases stored proc in sqlserver returns a remarks column. Where doe开发者_StackOverflow社区s this information come from, and can I edit it?
This field always retuns null. You can not edit it, unless you modify the system stored procedure which is not recommended.
See http://msdn.microsoft.com/en-us/library/aa259636(SQL.80).aspx
Simply run sp_helptext sp_databases
and you'll see:
REMARKS = convert(varchar(254),null)
It's a brand new NULL, manufactured just in time, for your convenience.
精彩评论