Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ISQLW Replacement Expand / Collapse
Author
Message
Posted Wednesday, June 17, 2009 6:20 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, December 21, 2012 6:44 AM
Points: 26, Visits: 133
I use Microsoft SQL Server Management Studio for development/debug production/user support/system maintenance/... but need to contentiously monitor specific systems and continuously run 1 or 2 TSQL update scripts all day long. I have found it easiest to do all generic task in Management Studio (8-15 windows) and separate (usually 2 occasionally max 4 windows) application monitoring/update scripts in ISQLW for fast and easy locating, modify, and running. I have checked advertisers but have not found anything as simple as ISQLW and with small system footprint. VB Apps really is over kill and is not as flexible. Any one know of or use an alternative to ISQLW for very small footprint and flexibility to run/tweak/display TSQL scripts? I already split the display window to Management Studio for development and scripts get lost within all open windows.
Post #736449
Posted Wednesday, June 17, 2009 7:35 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:03 AM
Points: 41,548, Visits: 34,470
Have you looked at SQLCMD? It's the replacement for osql which itself was the replacement for isql.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #736543
Posted Wednesday, June 17, 2009 7:38 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:02 AM
Points: 14,825, Visits: 27,300
Yeah, I was going to suggest SQLCMD as well.

Plus, why are you manually opening all kinds of windows in SSMS to do manual updates all day long? You should be able to script out processes and schedule them with SQL Agent or set up triggers and not have to sit there manually running tons of different scripts to keep the system up.

Also, you might look into PowerShell. It provides more programming ability without all the overhead of VB or C#.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #736547
Posted Wednesday, June 17, 2009 3:55 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, December 21, 2012 6:44 AM
Points: 26, Visits: 133
The problem is a need to closely monitor multiple servers jobs running custom applications and performance. This is accomplished easily by TSQL scripts, then when an issue is found able by changing certain parameters drill down to narrow or broad overview of application progression. When intervention is required SQL Server Management Studio is used to resolve issues. I oversee several applications adding users/codes periodically all day. We are rewriting the app but for now must do research and verification then manually enter user/codes. This is done very nicely by existing parameterized scripts. SQLCMD is nice to run a script but does not seem to lend itself to an all day monitoring of application DB's by script like ISQLW does. SQL Management Studio will allow me to maintain these windows/scripts but it takes so long to find the correct window when have a large number of windows open and running. Really nice to split off scripts that I just want to monitor periodically, with no chance of accidentally close/save/run if mixed in with development work windows. Frenzied multitasking does have a tendency biting you when you least can afford it.
Post #737050
Posted Thursday, June 18, 2009 5:31 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:02 AM
Points: 14,825, Visits: 27,300
I don't understand what ISQLW does that SQLCMD does not?

From the sounds of it, you really might benefit from Powershell.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #737416
Posted Thursday, June 18, 2009 5:45 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:03 AM
Points: 41,548, Visits: 34,470
Oh, sorry. I misread. ISQLW is Query Analyser. It's ISQL that SQLCMD's a replacement for.

I'm curious why management studio's not acceptable. You can always open multiple copies of it if you like.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #737426
Posted Thursday, June 18, 2009 6:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, December 21, 2012 6:44 AM
Points: 26, Visits: 133
Maybe I have misunderstood the roll of SQLCMD? What I have read is that it is a fabulous tool to run a SQL script from a command line, but what I need is to leave the connection open to repeatedly run the script for monitoring, and then tweak the parameters/code to explore the range of anomalies possible in custom DB applications. Power shell appears to be a great ?reporting? tool to display known predetermined scripts, not browsing or do (Research/Validate/Update) table contents. Management Studio can open multiple copies (NIiiicccceee) but it is resource intensive just to display a result grid. So when you open two-three DTS/Visual Studio for migrating packages (2000-2005-2008), Outlook, Word, Excel, Access, Windows Explorer, couple Internet Explorers, Job Activity Monitor, Remote Desktop Connections,... all on one laptop masquerading as a work station.
Post #737456
Posted Thursday, June 18, 2009 6:23 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:03 AM
Points: 41,548, Visits: 34,470
Have you looked at Toad? It's 3rd party and not free, but I've heard good things about it. Other option if you still have 2000 disk lying around is to install QA. It connects to SQL 2005, haven't tried 2008. Might be worth a try.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #737458
Posted Thursday, June 18, 2009 6:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:02 AM
Points: 14,825, Visits: 27,300
I just tried QA against 2008. It works. Nominally. I haven't run a full-on regression test or anything.

I'm sorry too. I thought you, the OP, were trying to find ways to automate what sounds like an awful lot of thrash.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #737463
Posted Thursday, June 18, 2009 10:15 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, December 21, 2012 6:44 AM
Points: 26, Visits: 133
I greatly appreciate your help on my conundrum. I used Toad with Oracle (Nice) but it looks like it has a large footprint also. I had a copy of needed DLLs from 2000, but someone deleted them when cleaning up servers, and was hoping to use a currant app so will not have to continually face this issue when changing workstations or upgrades. I have seen a Web Browser App at previous employment that you could enter a script and it would display the result set, but have not figured it out yet. Thanks a million.
Post #737737
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse