Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

how to enable SQL CMD MODE using t-sql script Expand / Collapse
Author
Message
Posted Wednesday, June 24, 2009 1:18 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 21, 2014 11:11 AM
Points: 30, Visits: 91
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'

Post #741315
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse