declare @fileNo nvarchar(20); declare @OutPutmessage nvarchar(150); set @fileNo='sl3193'; set @OutPutmessage=null; SELECT spresults.* FROM OPENROWSET('SQLNCLI', 'server=xxx.yyy.xx.xx;Uid=username;Pwd=passwoord; database=[dbName]; Persist Security Info=False', 'EXEC [AlahliX].dbo.[ELStudentsDet] @Regno= sl3193,@message=null') AS spresults
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)