problem with stored proc

hi

i have a sp with this in:

CREATE USER [@newuser] FOR LOGIN [@newuser]

why does it create a user @newuser instead of the contents of this var ?

Johan

Johan,

You probably based this on seeing such examples as:

CREATE USER [Domain\Login] FOR LOGIN [Domain\Login]

Because the [ ] is an escape that tells the parser not to examine the
contents of the brackets more closely. It allows the use of unsupported
characters in names. But it means that the code does not even see the
variable name. If you remove [ ], then this should work.

SET @newuser = 'Domain\Login'

CREATE USER @newuser FOR LOGIN @newuser

A variable already safely contains the value with special characters, so
does not need to be bracketed.

RLF

"Sagaert Johan" wrote in message

> hi
>
> i have a sp with this in:
>
> CREATE USER [@newuser] FOR LOGIN [@newuser]
>
> why does it create a user @newuser instead of the contents of this var ?
>
> Johan
>
>
>
>
>
>
>
>
>
>