[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Syntax Error on DROP USER

ram66

3/20/2007 3:16:00 PM

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!
3 Answers

ram66

3/20/2007 3:21:00 PM

0

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!
>

m.bohse

3/20/2007 3:30:00 PM

0

The Drop User statement don't accept variables. You need to use
dynamic SQL
Like

declare @user_id as varchar(8);
Declare cmd as varchar(100)
set @user_id='TEST';
SET cmd = 'DROP USER ' + @user_id
EXEC sp_executesql @cmd
GO

Markus

ram66

3/20/2007 4:36:00 PM

0

Thanks Markus that helped me a lot!

"m.bohse@quest-consultants.com" wrote:

> The Drop User statement don't accept variables. You need to use
> dynamic SQL
> Like
>
> declare @user_id as varchar(8);
> Declare cmd as varchar(100)
> set @user_id='TEST';
> SET cmd = 'DROP USER ' + @user_id
> EXEC sp_executesql @cmd
> GO
>
> Markus
>
>