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
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