Enterprise Manager is intended for this sort of purpose... and Query Analyzer although it's intended as a script-based way to interract with the server in MS SQL 2000 also provides an object browser ( left pane like CF Studio's db browser ) with some convenient new features. I know that Access can be used as a front-end for SQL Server db's ... There's a fairly common billing software package for ISP's that uses it as a front-end for reporting, etc. however, I've never seen the need for it as a developer. Use the SQL Server CD you used to install the server on your workstation and install the "client access tools". That will set you up with both Enterprise Manager and Query Analyzer.
Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 > We have been using Access for so long now I got used to > being able to > enter/edit data with a few mouse clicks, just opened up > the table and > started typing or making corrections (to users, parameters > files, or > erroneous transactions during development). > Now that development has been ported to SQL, I dread the > command-line data > entry of ISQL 6.5. Is there an easier way to do what I got > used to doing > with Access? A recent article, I believe it was in CFDJ, > talked about > interfacing the Access front-end to an SQL database thru > ODBC. Have you > actually tried it? Any tips/tricks? > Thanks In Advance > Ed Gordon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
