View Single Post
  #1  
Old 04-23-2007, 10:12 AM
BrandonG BrandonG is online now
Registered User
 
Join Date: 11-13-2006
Posts: 12
How to supress output into the log window using Run SQL (ISQLW)

I have a problem with trying to get the SQL output to supress. I am using the standard Run SQL with the exception that I changed the EXE to isqlw due to the way that OSQL was processing some special characters in my scripts. Below are the 3 ways that I have tried configuring the step(s) (there are 20 or so) to supress output with no luck.

Can anyone offer any assistance

First:
<step action='Run SQL'>
<Abort type='11'>0</Abort>
<Database>C1DAT</Database>
<InputFile>%Script_Get_Location%\Installation\Veri fy Script\Val_DB.sql</InputFile>
<Location>isqlw</Location>
<Output type='3'>1</Output>
<OutputFile>%Script_Get_Location%\%SS_VERSION%Vali date_Central_Db.sql</OutputFile>
<Password>%validate_SA_Pass%</Password>
<SecType type='3'>1</SecType>
<Server>%COMPUTERNAME%</Server>
<UserName>sa</UserName>
<Width>10000</Width>
<indent type='3'>2</indent>
<name>Val_DB.sql</name>
<nologging type='11'>-1</nologging>
</step>

Second:
<step action='Run SQL'>
<Abort type='11'>0</Abort>
<Database>C1DAT</Database>
<InputFile>%Script_Get_Location%\Installation\Veri fy Script\Val_DB.sql</InputFile>
<Location>isqlw</Location>
<Output type='3'>1</Output>
<OutputFile>%Script_Get_Location%\%SS_VERSION%Vali date_Central_Db.sql</OutputFile>
<Password>%validate_SA_Pass%</Password>
<SecType type='3'>1</SecType>
<Server>%COMPUTERNAME%</Server>
<UserName>sa</UserName>
<Width>10000</Width>
<indent type='3'>2</indent>
<name>Val_DB.sql</name>
<nologging type='11'>0</nologging>
</step>

Third:
<step action='Run SQL'>
<Abort type='11'>0</Abort>
<Database>C1DAT</Database>
<InputFile>%Script_Get_Location%\Installation\Veri fy Script\Val_DB.sql</InputFile>
<Location>isqlw</Location>
<Output type='3'>1</Output>
<OutputFile>%Script_Get_Location%\%SS_VERSION%Vali date_Central_Db.sql</OutputFile>
<Password>%validate_SA_Pass%</Password>
<SecType type='3'>1</SecType>
<Server>%COMPUTERNAME%</Server>
<UserName>sa</UserName>
<Width>10000</Width>
<indent type='3'>2</indent>
<name>Val_DB.sql</name>
</step>
Reply With Quote