Toad World® Forums

Spool output in Toad for SQL Server


#1

Hi,

I am new to SQL Server. I am confortable with Toad for Oracle but the toad for SQL Server is completely new.

I need to spool the output using toad for SQL server. Any suggestions?

Srikanth


#2

Found this question not answerted. There is no analog of Oracle Spool.
To enable SQL Trace

» Select Tools | Execution Trace and then select whether to generate a log file or display the output in a window.

If you selected a log file, the file is stored by default in:

Windows 2003 and XP: C:\Documents and Settings\username\Local Settings\Application Data\Quest Software\Toad for database version\ConnectionTrace.log

Windows Vista or later OS: C:\Users\username\AppData\Roaming\Quest Software\Toad for database version\ConnectionTrace.log