Don't know if you knew this or not, but you can use Access as a front end to SQL Server. Make a new database project and point it to the server and database. The nice thing about this is the ability to use the query designer, report designer, macros and such in access without having to import the data. You create tables, edit data, create views, and stored procs.
I actually use this much more than enterprise manager and aquadata studios, my other database management tools. I have a project for each database I use. Double click and it opens so much quicker the other two. It is nice for creating excel data sets. Just create a new view, right click and export to excel without having to go through a lot. There are limitations and such. There are no DTS options or script writing abilities. I use EM for DTS and ADS for sql generation. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:281711 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
