Online Documentation for SQL Backup for SQL Server

Defining T-SQL statement


Use this step to define a T-SQL statement to be executed.

 

Service tasks - Execute T-SQL statement - Defining T-SQL statement

 

 

Type the T-SQL statement in the Query text tab.

 

Use the Execute timeout field to define time restriction for checking the statement procedure.

 

Use the Check statement button to run the statement on the server in PARSEONLY mode to ensure that T-SQL statement is correct. The detailed log of errors is displayed at the Errors tab.

 

Note: The Check statement button is not available in Template mode.

 

Use Load\Save buttons for loading or saving the script from\to an internal file.

 

All errors are displayed on the Errors tab.

 

Service tasks - Execute T-SQL statement - Defining T-SQL statement - Error