How can we help you today? How can we help you today?

SQLCMD Variables

I have a set of SQL scripts that utilize SQLCMD Variables......for example


:setvar Pub_Server "[team-1]"
:setvar Sub_Server "[team-1\Reporting]"
:setvar SubscriberDB "Reporting_team1"
:setvar PostSnapshotScript "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\repldata\index\indexfile.sql"

I've changed my variable names but you should be able to see the gist of what I am trying to accomplish. This portion of the script is at the top of my SQL script and will be called later on in the script. This works well in SSMS but doesn't using this utility. I receive a error - Incorrect syntax near ':'.

Is the use of SQLCMD Variables not supported with this utility? I could break the script out into 5 different variations and hard code in the values but trying to stay away from that.
ChrisYates
0

Comments

4 comments

Sort by
  • dlkj
    Hi cyates04,

    SQL Multi Script doesn't support SQLCMD variables. We have rough feature parity with SSMS which doesn't support them either.

    Thanks,
    --
    Daniel
    dlkj
    0
  • ChrisYates
    Thanks for the quick response.
    ChrisYates
    0
  • dcam
    Hi,

    The SQLCMD syntax is supported by management studio. Using the 2008 client there is the option under the query menu to execute scripts using the SQLCMD syntax.

    Will there be support for SQLCMD syntax in future versions on MultiScript?

    David
    dcam
    0
  • dlkj
    Hi David,

    Thanks for letting us know about that. It's amazing what's hidden in SSMS.

    Unfortunately we aren't planing to make any updates to SQL Multi Script in the immediate future.

    Daniel.
    dlkj
    0

Add comment

Please sign in to leave a comment.