To suppress NCS in a script - script sample (22237)

When using Native Command Substitution (NCS), a portion of the script may need to remain as native commands and not translated to LiteSpeed extended stored procedures.

NCS translates the entire script if a portion is not specifically designated a native commands.

To suppress NCS in a script

To preserve portions of t-sql script not to be translated by NCS, add the syntax in example below. Note, the complete command must be included
"/*no_translate */" and "/*end_no_translate */" The symbols surrounding the commands are required.

Example:

BACKUP DATABASE pubs
TO DISK = 'd:\backup\test.bak'
WITH
DESCRIPTION = 'full backup of pubs',
STATS,
INIT
/*no_translate */
BACKUP DATABASE Northwind
TO DISK = 'd:\backup\test2.bak'
WITH
DESCRIPTION = 'full backup of Northwind',
STATS,
INIT
/* end_no_translate */
BACKUP DATABASE Model
TO DISK = 'd:\backup\test3.bak'
WITH
DESCRIPTION = 'full backup of Model',
STATS,
INIT

This script would use LiteSpeed format for the databases Pubs and Model and the Northwind would be on SQL Server native format.

More information about /* ads_translator_deactivate */ and /* ads_translator_activate */, can be found on Native_Command_Substitution_HelpFile.ZIP on the Quest Support website:
http://support.quest.com/Portal/Logon.asp?ReturnURL=/support_download/Downloads.asp

NOTE: NCS is no longer supported with LiteSpeed (as of   Version 4.7)