Andy, while I am no DB expert, Access should allow you to connect to a MS SQL server data base and use all the Access-style visualization I think. I use access to view the DB cause Access has an AWESOME paste-append feature and you can move the columns around (visually).
Create a new file > Project using existing database And then point it at the SQL server. ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, February 22, 2007 11:36 AM To: CF-Talk Subject: A few questions about SQL Server 2000 I've got some elaborate joins I'm performing against tables with which I'm not all that familiar. Access has a built in function called Relationships which allows you to visualize tables and their columns. Does SQL Server have something like this? Alternately, is there a quick way of dumping a few tables (just the structure) from SQL Server into Access so that I can use the relationships tool there? ____________________________________ Andy Matthews Senior Coldfusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com <http://www.dealerskins.com/> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
