Categories
Development

SQL Azure Remote Procedure

We are trying to execute a remote procedure on an Azure database : INSERT INTO #temp ( ConsultantId ,UserId ,Name ,Email ,Phone ,DefaultContact ) EXEC @RemoteResult = sp_execute_remote @RemoteSource ,@SQLString ,@ParmDefinition ,@userid = @userid; Where #temp is a table with the same 6 columns as shown in the insert above. However, we always get the […]