Search Sort Posts:  Oldest to newest Newest to oldest

06-10-2008, 6:56 PM capatree Joined on 06-10-2008 Posts 1 T-SQL How to execute t-sql query using control panel? The Webbase Enterprise Manager doesn't have this feature.  Do we have to use third party tools?    Report

06-10-2008, 9:51 PM Neocognitron Joined on 06-11-2008 Posts 1 Re: T-SQL I use SQL Server Management Studio, free from Microsoft.  Works great, even remotely.    Report

06-11-2008, 3:22 PM deanman Joined on 04-11-2007 Posts 187 Re: T-SQL <BLOCKQUOTE><table width="85%"><tr><td class="txt4"><img src="/Themes/default/images/icon-quote.gif">&nbsp;<strong>capatree wrote:</strong></td></tr><tr><td class="quoteTable"><table width="100%"><tr><td width="100%" valign="top" class="txt4"> How to execute t-sql query using control panel? The Webbase Enterprise Manager doesn't have this feature.  Do we have to use third party tools?<br> </td></tr></table></td></tr></table></BLOCKQUOTE> Go to control panel 'Database' => 'MSSQL Manager', connect to your data base, and use 'Tools' => 'Query Analyser' to execute T-SQL scripts/commands. I <3 WebHost4Life.com    Report

06-14-2008, 8:30 AM HOPS Joined on 03-30-2008 Posts 7 Re: T-SQL  Neocognitron wrote: I use SQL Server Management Studio, free from Microsoft.  Works great, even remotely. I'd love to use SQL Server Management Studio remotely except NTL/VirginMedia deemed fit the block the ports it uses due to concerns over viruses. Darn annoying! I wonder if there's any chance WebHost4Life could offer a second port for SQL connection. SQL 2005 can handle mutliple ports. Cheers, Rob.    Report

06-14-2008, 11:34 PM deanman Joined on 04-11-2007 Posts 187 Re: T-SQL The advantage of Web based Enterprise Manager is the secure connection -- and it's faster. https://sqladmin.mysite4now.com However, generating SQL has been disabled (see below)... Error 424 Object required SQLDMO must be installed on your server so that this option is available. --- And yes, DB info is not available anymore (TIMEOUT)... I <3 WebHost4Life.com    Report

Webhost4life Fo... » Database Relate... » MSSQL » T-SQL

(please select) Forums Home |- Search Forums |- Active Topics |- Unanswered Posts User Options |- Sign In |- Join this community |- Forgot Password Webhost4life News/Updates |- Webhost4life News and Announcements |- Outages and maintenance |- FREE Hosting Account to active Forum Members |- Features Suggestion |- Pre-Sales Questions |- Do a Survey and Get Free Hosting Service General Discussion and Help |- Windows Server 2008 / IIS 7 |- Classic ASP |- ASP.NET C# |- ASP.NET VB.NET |- Other ASP.NET Language |- Silverlight |- PHP |- PERL |- Javascript |- General Discussion |- Sharepoint Development Environment |- VS.NET |- MS Frontpage |- Macromedia Dreamweaver |- Macromedia Flash Auto Plug-ins |- Dotnetnuke |- Community Server |- Rainbow Portal |- nGallery |- ASP.NET Community Starter kit |- ASP.NET Commerce Starter kit |- PHP Plugins |- Future Plug-in Candidate Application Database Related Support |- MSSQL |- MS Access |- MySql Others |- Smartermail |- Control Panel |- Webstats |- Online resources |- Scripting Resources