T-SQL

MSSQL

T-SQL

---

capatree 06-10-2008, 6:56 PM
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?

Re: T-SQL

---

Neocognitron 06-10-2008, 9:51 PM
I use SQL Server Management Studio, free from Microsoft.  Works great, even remotely.

Re: T-SQL

---

deanman 06-11-2008, 3:22 PM
<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

Re: T-SQL

---

HOPS 06-14-2008, 8:30 AM

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.

Re: T-SQL

---

deanman 06-14-2008, 11:34 PM
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