ISQLW in 2005?

I'm sure that I'm not the first to complain about this, but it bothers
me that it seems that MS is now forcing us to use this new bloated SQL
management studio. Don't get me wrong, it does a lot and is a great
management tool. However, nearly everything I do with SQL Server I do
through script. In fact, in the past, I avoided using EM at all costs
for performance reasons. Not everyone has the luxury of top-of-the-line
hardware, SANs, fast networks and local servers. Is there a lightweight
tool for 2005 like the old-school Query Analyzer?
-AlanHi Alan,
Your sentiment is shared by a lot of people, once you get used to the tool
though its fantastic - I write mainly in DDL myself rather than use the GUI.
You can use iSQL from SQL 2000 against a 2005 database so for existing
installations you'd be ok, but, give the management studio a try and you'll
find once you get used to the slightly different way of working then you'll
gain productivity.
Tony.
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"Alan Samet" <alansamet@.gmail.com> wrote in message
news:1136299129.784559.94230@.g43g2000cwa.googlegroups.com...
> I'm sure that I'm not the first to complain about this, but it bothers
> me that it seems that MS is now forcing us to use this new bloated SQL
> management studio. Don't get me wrong, it does a lot and is a great
> management tool. However, nearly everything I do with SQL Server I do
> through script. In fact, in the past, I avoided using EM at all costs
> for performance reasons. Not everyone has the luxury of top-of-the-line
> hardware, SANs, fast networks and local servers. Is there a lightweight
> tool for 2005 like the old-school Query Analyzer?
> -Alan
>|||If you do everything through scripts and want to minimize overhead, you
might want to just use sqlcmd.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Alan Samet" <alansamet@.gmail.com> wrote in message
news:1136299129.784559.94230@.g43g2000cwa.googlegroups.com...
> I'm sure that I'm not the first to complain about this, but it bothers
> me that it seems that MS is now forcing us to use this new bloated SQL
> management studio. Don't get me wrong, it does a lot and is a great
> management tool. However, nearly everything I do with SQL Server I do
> through script. In fact, in the past, I avoided using EM at all costs
> for performance reasons. Not everyone has the luxury of top-of-the-line
> hardware, SANs, fast networks and local servers. Is there a lightweight
> tool for 2005 like the old-school Query Analyzer?
> -Alan
>|||Nobody will prevent you from using the successor for OSQL --> SQLCMD
;-)
HTH, Jens Suessmeyer.|||At least that will work until the DOS prompt is retired from Windows. :-0
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1136300386.513873.242110@.z14g2000cwz.googlegroups.com...
> Nobody will prevent you from using the successor for OSQL --> SQLCMD
> ;-)
> HTH, Jens Suessmeyer.
>