IS THIS IS WHAT U R LOOKING FOR....

DECLARE

@SQLINDEXTABLENAME VARCHAR (200),

@SQL_STMT NVARCHAR(4000)

SET @SQL_STMT = 'SELECT @SQLINDEXTABLENAME = NAME FROM SYSOBJECTS WHERE ID = 5;

'

EXEC SP_EXECUTESQL @SQL_STMT, N'@SQLINDEXTABLENAME VARCHAR(200) OUTPUT', @SQLINDEXTABLENAME OUTPUT

PRINT @SQLINDEXTABLENAME

Cheers..Prakash

Prakash