Thanks all, sorry I didn't say more about what I'd tried. Turned out to be a .. in the database name!
I use I've used INFORMATION_SCHEMA in the past but my code generator was using cfdbinfo and I didn't feel like changing it. I knew it was a bad idea at the time but I had different plans for two sites, one a .co.uk, the other a .com, so I named them ldnhotels.com and ldnhotels.co.uk respectively. SQL Server didn't complain when I created the DBs so I went with it. Thanks all. Adrian http://www.adrianlynch.co.uk/ -----Original Message----- From: Dominic Watson Sent: 13 January 2008 10:46 To: CF-Talk Subject: Re: cfdbinfo not returning tables lol another reason people might not be familiar with it via that ISO standard - the document has 1121 pages! Not a page turner either I'm sure. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296511 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4