# Is there a option to Spool sql to screen?

**URL:** <https://forums.toadworld.com/t/is-there-a-option-to-spool-sql-to-screen/34157>\
**Category:** Toad for SQL Server\
**Created:** [September 24, 2015, 2:51am UTC](https://forums.toadworld.com/t/is-there-a-option-to-spool-sql-to-screen/34157 "2015-09-24T02:51:51Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![villi](https://avatars.discourse-cdn.com/v4/letter/v/a87d85/32.png) [@villi](https://forums.toadworld.com/u/villi)\
**Post date:** [September 24, 2015, 2:51am UTC](https://forums.toadworld.com/t/is-there-a-option-to-spool-sql-to-screen/34157/1 "2015-09-24T02:51:51Z")

</div>

I’m used to using Toad for Oracle and there I could get all command that were generated by Toad to the screen. Is this possible in Toad for SQL server?

---

<div class="post-metadata">

**Author:** ![Cathy.Liu](https://avatars.discourse-cdn.com/v4/letter/c/41988e/32.png) [@Cathy.Liu](https://forums.toadworld.com/u/Cathy.Liu)\
**Post date:** [September 24, 2015, 7:23pm UTC](https://forums.toadworld.com/t/is-there-a-option-to-spool-sql-to-screen/34157/2 "2015-09-24T19:23:49Z")

</div>

Hi Villi,

Toad for SQL Server has a similar function which is Session Browser. You can find it from Tools-\>Administer-\>Session Browser.

Find your processes and go to Last T-SQL command batch, you will see the sql just like spool of Toad for Oracle.

For more details please reference toad for SQL Server help.

Feel free to contact me if there is any problems.

Thanks,

Cathy.

---

<div class="post-metadata">

**Author:** ![Cathy.Liu](https://avatars.discourse-cdn.com/v4/letter/c/41988e/32.png) [@Cathy.Liu](https://forums.toadworld.com/u/Cathy.Liu)\
**Post date:** [September 24, 2015, 7:29pm UTC](https://forums.toadworld.com/t/is-there-a-option-to-spool-sql-to-screen/34157/3 "2015-09-24T19:29:22Z")

</div>

Hi Villi,

Toad for SQL Server has a similar function which is Session Browser. You can find it from Tools-\>Administer-\>Session Browser.

Find your processes and go to Last T-SQL command batch, you will see the sql just like spool of Toad for Oracle.(see the screenshot below)

For more details please reference toad for SQL Server help.

Feel free to contact me if there is any problems.

Thanks,

Cathy.

---

<div class="post-metadata">

**Author:** ![villi](https://avatars.discourse-cdn.com/v4/letter/v/a87d85/32.png) [@villi](https://forums.toadworld.com/u/villi)\
**Post date:** [September 25, 2015, 1:27am UTC](https://forums.toadworld.com/t/is-there-a-option-to-spool-sql-to-screen/34157/4 "2015-09-25T01:27:42Z")

</div>

Ok thanks, is there a option for this in the free version?

---

<div class="post-metadata">

**Author:** ![Cathy.Liu](https://avatars.discourse-cdn.com/v4/letter/c/41988e/32.png) [@Cathy.Liu](https://forums.toadworld.com/u/Cathy.Liu)\
**Post date:** [September 27, 2015, 6:49pm UTC](https://forums.toadworld.com/t/is-there-a-option-to-spool-sql-to-screen/34157/5 "2015-09-27T18:49:14Z")

</div>

Hi,

There is no option for Session Browser on Free version, it is not available on free version but you can download our 6.7 Beta Version.It supports session browser well and you can find it on Tools|Administer directly.

Beta Download link :

[www.toadworld.com/.../default.aspx](http://www.toadworld.com/.../default.aspx)

Thanks,

Cathy

---

<div class="post-metadata">

**Author:** ![villi](https://avatars.discourse-cdn.com/v4/letter/v/a87d85/32.png) [@villi](https://forums.toadworld.com/u/villi)\
**Post date:** [September 29, 2015, 2:31am UTC](https://forums.toadworld.com/t/is-there-a-option-to-spool-sql-to-screen/34157/6 "2015-09-29T02:31:38Z")

</div>

Great thanks.

It would be a beneficial addon to have a Show Sql tab in the table view like in Toad For Oracle in your future releases 🙂
