create log file for a scrip

I'm am new to using SQL Server. In Oracle, when I create scripts to
manipulate data, I have a log file automatically created from within the
script by issuing the SPOOL command. Is there a similar functionality in SQL
server? Besides the log file which records each transaction. Thanks
Hi,
USE OSQL and redirect the output to a text file.
OSQL -USA -Ppassword -SServer -iC:\script.SQL >c:\log.txt
Thanks
Hari
SQL Server MVP
"Lee Ann" <Lee Ann@.discussions.microsoft.com> wrote in message
news:95E24AE5-39E0-4A95-A522-E9E9DF2B2215@.microsoft.com...
> I'm am new to using SQL Server. In Oracle, when I create scripts to
> manipulate data, I have a log file automatically created from within the
> script by issuing the SPOOL command. Is there a similar functionality in
> SQL
> server? Besides the log file which records each transaction. Thanks
|||Thanks Hari
"Hari Prasad" wrote:

> Hi,
> USE OSQL and redirect the output to a text file.
> OSQL -USA -Ppassword -SServer -iC:\script.SQL >c:\log.txt
> Thanks
> Hari
> SQL Server MVP
> "Lee Ann" <Lee Ann@.discussions.microsoft.com> wrote in message
> news:95E24AE5-39E0-4A95-A522-E9E9DF2B2215@.microsoft.com...
>
>