Working with Group Execute in Toad for SQL Server

Hello. My name is Robert Pound and I'm a product technologist from Quest. In this video, I'm going to talk to you about Group Execute and Toad for SQL Server. So if you ever come across the problem where you need to, for instance, create a table on multiple databases or you just want to select for multiple databases, as you may have guessed, Toad has you covered.
So in the editor window to the left, we have the group execute tab that will show up. If it does not appear here, you can come to the top and choose editor and choose windows, and make sure that group execute is checked. Once it's there you can click on it and you can obviously pin it if you'd like.
So if you're going to do a group execution you click enable, and it will show an icon to the right saying group execute mode. And you can choose the connections that you want to execute on. If you want to be more precise, you can choose the individual databases.
So now, once I have it selected, I can come in and select individual databases that I want to run this execution on. And if you're running a select statement, you have the option of merging them into a single result set or into multiple results sets. And now, when I execute this, since we are in group execute mode, it will prompt me to say, are you sure you want to run against the selected targets, and you say yes.
And then, if you come back to the group execute, you can see, in this case, both of them failed because the tables already exist. But if you had a success, it would show up here. So you can see how each one of the executions was run against a particular connection, or a particular database. And that that's all there is to it for this particular function. Hopefully this was helpful.
For more information on this product, you can check out the help file. It has a wide range of information including tutorials. You can also check out community driven innovation going on at www.ToadWorld.com. For more information on this product, you can check out www.Quest.com/Products/Toad-for- SQL-Server. Thank you and have an excellent day.

Learn how variables can be used in the Toad for SQL Server editor and in automation. This short video covers: prompting users for inputs in automation, creating variables from SQL statements, using "if" conditions for flow control, and the use of variables to output to the console, email, and filenames.

This video shows features of Log Reader in Toad for SQL Server, including a quick example of how to recover data that has been inadvertently updated. It also shows how to access Log Reader from SSMS or Toad, how to interpret the data in the reader, how to format and filter the data, and how to use the various tools in order to affect change in the database.

This 2 part video series explores the basics of automation in Toad for SQL Server. In part 2 we test the script we created in the previous video, and schedule it to run weekly once we are satisfied. We also explore the Job Manager after scheduling is completed.

This 2 part video series explores the basics of automation in Toad for SQL Server. Topics include: a simple automation scenario, different ways of accessing automation in Toad, automation settings, user interface, and input/output for a select to file activity.