When I last used that trick the management studio never stopped working, only sql server, so unlrss they have changed that, its a free way to get more features out of express edition.
Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Nov 15, 2012 11:54 PM, "Gerald Guido" <gerald.gu...@gmail.com> wrote: > > > > > Or downliad the full trial version with tools and get studio from there > > instead. > > > > Yeah, what Russ said. I think the trial version is good for 6 months. > > IIRC you can also get the MSSQL developer edition for $40-$50. It is > the equivalent of the Enterprise version. Not sure if > the Licencing allows you to use Management Studio to push changes to > production Databases. I don't see why not. > > You might be eligible to get the Web addition for free via > the WebsiteSpark program http://www.microsoft.com/web/websitespark/ > > Web edition removes the Ram and Database size limitations. It might > be worth a try. > > In any event, here is the feature matrix for the different versions. > > http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx > > HTH > > G! > > On Thu, Nov 15, 2012 at 6:03 PM, Russ Michaels <r...@michaels.me.uk> > wrote: > > > > > You do get ssis and backups its just not in the sql management studio so > > you have to script it. > > Or downliad the full trial version with tools and get studio from there > > instead. > > > > Regards > > Russ Michaels > > www.michaels.me.uk > > www.cfmldeveloper.com - Free CFML hosting for developers > > www.cfsearch.com - CF search engine > > On Nov 15, 2012 10:25 PM, "Justin Scott" <leviat...@darktech.org> wrote: > > > > > > > > > Oh, and I don't think you can run scheduled backups either. Which > > > > is an issue when using it in production. > > > > > > We use Tomahawk Backup on some of our web servers to back up the > > > website code and images to both local and off-site storage. Tomahawk > > > (and many other backup utilities) will interface with SQL Server (even > > > the Express edition which we have deployed in production in a few > > > places) and back up your databases locally and off-site as well. > > > Works out pretty well. > > > > > > > > > -Justin Scott > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353205 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm