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.