Ah cheers dude. Good to know. Adrian
-----Original Message----- From: Tom Donovan [mailto:[EMAIL PROTECTED] Sent: 16 November 2007 22:39 To: CF-Talk Subject: Re: cfdbinfo REMARKS column Adrian Lynch wrote: > Where would the remarks column get populated from when I use the code > below on SQL Server 2000? > > <cfdbinfo datasource="#datasource#" type="tables" name="tables"> > <cfdump var="#tables#"> > I think you are out of luck here. According to the SQL Server 2000 docs at http://msdn2.microsoft.com/en-us/library/aa260318(SQL.80).aspx "REMARKS - SQL Server does not return a value for this column." Ditto for SQL Server 2005 http://msdn2.microsoft.com/en-us/library/ms186250.aspx It's peculiar that this is a column which is returned by the Catalog Stored Procedure sp_tables. The docs are right though - it is always NULL, even when you use sp_tables. -tom- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293533 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
