Re: create log file for a scrip



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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:95E24AE5-39E0-4A95-A522-E9E9DF2B2215@xxxxxxxxxxxxxxxx
> 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


.



Relevant Pages

  • Re: command line vs grid control
    ... have Oracle on-site for their line-of-business applications. ... customers that Oracle(all of its products not just the RDBMS) run on ... SQL Server where appropriate. ... Written any shell scripts in Windows to ...
    (comp.databases.oracle.server)
  • Re: Slow performance after restarting
    ... Columnist, SQL Server Professional ... Launch additional instances of Query Analyzer and verify the connection ... Detach/Rename/Re-attach gets me a much smaller transaction ... >> log file is this size or what you do for backups. ...
    (microsoft.public.sqlserver.programming)
  • Re: Transaction Log Failure
    ... A maintenance plan can not create a log file, ... then bring up sql server. ... > maintenance plan that would create a transaction log file every hour. ... > 2004-12-14 21:00:43.51 backup BACKUP failed to complete the command ...
    (microsoft.public.sqlserver.server)
  • Re: Slow performance after restarting
    ... without the hotfix but the problem disappeared when the hotfix ... Columnist, SQL Server Professional ... Launch additional instances of Query Analyzer and verify the connection ... >> log file is this size or what you do for backups. ...
    (microsoft.public.sqlserver.programming)
  • Re: The location of transaction log file
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > log file of existing database? ... >>> How to change the location of transaction log file of existing ... >>> database files into two different drives. ...
    (microsoft.public.sqlserver.server)