setvar is a mystery

6 Jan 2007 4:03 AM

ChrisHarrington

:setvar dbuser2 myuser
SELECT name

FROM sys.server_principals
WHERE name = $(dbuser2)

gives error

Msg 126, Level 15, State 1, Line 3
Invalid column name 'myuser'

----------

Chris Harrington
Active Interface, LLC.
http://www.activeinterface.com

6 Jan 2007 4:11 AM

ChrisHarrington

To answer my own question - after a bit of experimenting, I found I needed
to quote the variable. eg:

:setvar dbuser2 'myuser'
SELECT name

FROM sys.server_principals
WHERE name = $(dbuser2)

Show quote

"ChrisHarrington" <charrington-at-activeinterface.com> wrote in message
news:OdJ2VeUMHHA.1248@TK2MSFTNGP03.phx.gbl...
> :setvar dbuser2 myuser
> SELECT name
> FROM sys.server_principals
> WHERE name = $(dbuser2)
>
> gives error
>
> Msg 126, Level 15, State 1, Line 3
> Invalid column name 'myuser'
>
> ----------
>
> Chris Harrington
> Active Interface, LLC.
> http://www.activeinterface.com
>
>