Home Forums SQL Server 2008 T-SQL (SS2K8) Run Stored Procedure on remote server RE: Run Stored Procedure on remote server

  • November 13, 2012 at 9:00 am

    #1558528

    exec('exec OPENDATASOURCE(''sqloledb'',''Data Source=sqlsrv1; User ID=user1;Password=Pwd1'').Orders.dbo.testreport''' + @parameter1 + ''','+@parameter2+'' )

    Above statement gives me error

    Incorrect syntax near ','.