Scripting / Log Options


These setting are used when Objects scripted from Object View

 

Scripting Options Description

Script DROP for tables, views Script DROP statements for tables, views
Script DROP for procedures Script DROP statements for procedures, functions
Use ALTER / REPLACE Use ALTER / REPLACE for procs, functions if available
Script Object Level PermissionsScript object level permissions
Script Object Owner/SchemaScript object Owner / Schema
Script Object Physical PropertiesScript object physical properties
Script Collation ClauseScript table collation clause
Script GRANT TO PUBLICScript GRANT TO PUBLIC
Script Object in New WindowScript object in new Script Tab

Log Options Description

Enable SQL LogEnable SQL logging
  Log File per ServerOne log file for each server
  Monthly / Daily (Checked)Start new log file every month or every day
  Include ResultsInclude query results in a log file
  Log DirectoryDirectory where to create log files