ram66
3/20/2007 3:21:00 PM
Also, the error message I get is:
Msg 102, Level 15, State 1, Line 6
Incorrect syntax near '@user_id'.
And I have tried various variable names instead of @user_id.
Thanks!
"ram66" wrote:
> Can anyone tell me why this is a syntax error?
>
> declare @user_id as varchar(8);
> set @user_id='TEST';
> DROP USER @user_id;
> GO
>
> Thanks!
>