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.
BACKUP DATABASE pubs
TO DISK = 'd:\backup\test.bak'
DESCRIPTION = 'full backup of pubs',
BACKUP DATABASE Northwind
TO DISK = 'd:\backup\test2.bak'
DESCRIPTION = 'full backup of Northwind',
/* end_no_translate */
BACKUP DATABASE Model
TO DISK = 'd:\backup\test3.bak'
DESCRIPTION = 'full backup of Model',
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:
NOTE: NCS is no longer supported with LiteSpeed (as of Version 4.7)