Hi all, Does anyone know where the description property for columns in MSSQL 2K databases are stored? I'm presuming it's somewhere in one of the system tables, but I can't seem to find it. I want to create some kind of xml auto-documenting thang, pulling the name, datatype and description for each column in each table. I don't suppose there's a built in SP that gets that kind of info already?
Thanks, Kay. __________________________________________________ Kay Smoljak - Web Developer - PerthWeb Pty Ltd http://developer.perthweb.com.au - CF custom tags ______________________________________________________________________ Macromedia ColdFusion 5 Training from the Source Step by Step ColdFusion http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
