Multi script limit?

• 
  Hi,
  
  Is the application locking up (as in the ui stops working?) or does it just not return any more results?
  
  If you leave it running for a few min do the SQL Queries time out?
  
  Cheers,
  --
  Daniel

  dlkj June 11, 2009 05:46

  - 0 +
• 
  Hi,
  The application sort of locks up. What I mean by that is that I see the spinning "wheel" to the left hand side of the Script execution in progress... status whirling but nothing seems to be happening. As well if I click on the Cancel button it greys out but doesn't stop the spinning wheel thing.
  To actually cancel the script, or so I think, I have to go to File|Exit and shutdown the app.
  
  Results of the query itself are the same this morning. I don't get any error messages at all and the script stops at about server ~95 of 150.

  efdavila June 11, 2009 10:56

  - 0 +
• 
  Can you run the query against the last 55 servers only?
  --
  Daniel

  dlkj June 11, 2009 11:01

  - 0 +
• 
  Sure.
  
  Is there a way to export the list of servers so I can pull a subset out? Along the same lines if I maintain a list of servers with the sa password is there a method to import (the list is always getting updated)?
  
  TIA

  efdavila June 11, 2009 11:17

  - 0 +
• 
  @version for each server individually. I found that one of the servers was offline (shutdown) and this is where Multi Script hung. Once I unchecked that particular server the script ran against all servers without problem.
  
  This is a pretty good tool but it would benefit greatly if it had the ability to import a list of servers with their associated password. Also the list of servers you add isn't in alpha order so comparing against an existing list is quite a pain.
  
  Thanks...

  efdavila June 11, 2009 13:56

  - 0 +
• 
  Hi,
  
  Lots of Multi Script users have asked for an import/export/organization utility for database lists, so I have written a small utility that should tide you over until some more list management finds its' way into the product.
  
  http://labs.red-gate.com/index.php/Mult ... st_manager
  
  I hope this is useful for you!

  Brian Donahue June 12, 2009 04:14

  - 0 +
• 
  Thank you. I'll give it a try.

  efdavila June 16, 2009 16:56

  - 0 +

Add comment

Please sign in to leave a comment.