Home Forums SQL Server 2005 Business Intelligence how to enable SQL CMD MODE using t-sql script RE: how to enable SQL CMD MODE using t-sql script
Birdman-969830
SSC Veteran
Points: 260
More actions
June 24, 2009 at 1:18 pm
#1014878
If you mean in a job as in TSQL that you execute in Managment studio, why don't you set SQLCMD mode on by default?
tools ->options -> Query Execution -> Enable 'by default, open new queries in SQLCMD mode'