Supongo que:
Código SQL:
Ver originalCREATE PROCEDURE prueba
@id NCHAR(8) AS
---
DECLARE @SQLString VARCHAR(200)
---
SET @SQLString = 'select TOP 100 * from TABLA WHERE ID=''' + @id + ''' '
SELECT * FROM OPENROWSET('SQLOLEDB', 'SERVIDOR';'USER';'PWD' ,
@SQLString )