execute a command string -
10-25-2007
, 11:48 AM
hi,
i have a problem in executing a command. i want to grant
administrator rights to another user, but i have to select
it in a table.
this is my code:
declare @appo varchar (20)
select @appo=Login from Speedy.RemoteAccount where ...
exec ('grant dba to'||@appo)
but i have an error.
do you know which is the correct syntax?
thanks in advance
best regards
Mauro |