There is a free tool for SQLServer2005 at http://sqlmanager.net/products/mssql/manager/.
It's called EMS SQLManager Lite. The "Lite" part means it doenst have some features on it, but nothing that would worry us for what we do. The bits taken out are for professional DBAs and what's left is fine for making tables, manipulating data, modifying databases, etc. The extract database is a neat feature that allows turning an entire database, or teh structure only, or the data only in to a SQL Script that you can run i a query analyser to duplicate the database on another server. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 2/25/07, Mike | NZSolutions Ltd <[EMAIL PROTECTED]> wrote: > Hi guys, > > Did a bit of research on this topic, but a little confused. > > What should I be using as an enterprise manager equivalent for sql > server 2005 (hosted at my webhost). I wish to be able to connect to the > db and create/organise tables - including reordering columns, and also > create queries/views/sp's. > > Am wondering if I need to purchase full license of sql server 2005 for > my local machine to achieve this ? > > Any help/advice would be appreciated. > > mike > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270649 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
