Yay... I found that SQL Server does have database diagrams. That's what I'm looking for.
-----Original Message----- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Thursday, February 22, 2007 10:57 AM To: CF-Talk Subject: RE: A few questions about SQL Server 2000 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/> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270479 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
