Hi all:

Is it possible that we can execute a procedure(sp_amount) in a string format? Please see below.

declare @lerror char(50), @lcserver char(20), @lcdbname char(65), @lcsqlcmd char(1000)
select @lcserver = "[ej\jan]"
select @lcdbname = 'nsc'

select lcsqlcmd = "@lcserver.@lcdbname.dbo.sp_amount @cValue = 1, @error = @lerror output"
execute(lcsqlcmd)

however it gives me an error on it.

Hoping for your quick response. Thanks

Jan