sql - Insert data from linked server stored procedure into table -



sql - Insert data from linked server stored procedure into table -

we have setup sql server 2008 "server1" linked sql server "server2". on "server2", there stored procedure can query fine "server1":

exec [server2].[xx].[dbo].[sp] param

however, start inserting info linked server sp, run problems. utilize next code:

insert server1.dbo.table (column1, column2, ...) exec [server2].[xx].[dbo].[sp] param

when started out, received "known" errors like:

ole db provider "sqlncli" linked server "linkedserver" returned message "the partner transaction manager has disabled back upwards remote/network transactions.". msg 7391, level 16, state 2, line 2 operation not performed because ole db provider "sqlncli" linked server "linkedserver" unable begin distributed transaction.

as stated in similar questions like: inserting local table linked stored procedure inserting results of stored procedure linked server

so, configured msdtc on both servers. query runs 20 seconds , aborts error message:

ole db provider "sqlncli10" linked server "server2" returned message "no transaction active.". msg 7391, level 16, state 2, line 14 operation not performed because ole db provider "sqlncli10" linked server "server2" unable begin distributed transaction.

as opposed previous errors, there nil in windows event log.

first of all, query considered distributed transaction because of insert local table?

second, if seek execute distributed query this:

begin distributed tran select * [server2].master.sys.sysprocesses commit tran

i exact same error message after 20 seconds.

i don't know how investigate farther here. firewall issue?

sql sql-server-2008 stored-procedures linked-server

Comments

Post a Comment

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer - when trying request rest service @ time of response getting exception.. feb 21, 2013 2:34:49 pm com.sun.jersey.spi.container.containerresponse mapmappablecontainerexception severe: exception contained within mappablecontainerexception not mapped response, re-throwing http container java.lang.noclassdeffounderror: not initialize class net.sf.cglib.proxy.enhancer @ org.hibernate.proxy.pojo.cglib.cgliblazyinitializer.getproxyfactory(cgliblazyinitializer.java:117) @ org.hibernate.proxy.pojo.cglib.cglibproxyfactory.postinstantiate(cglibproxyfactory.java:43) @ org.hibernate.tuple.entity.pojoentitytuplizer.buildproxyfactory(pojoentitytuplizer.java:162) @ org.hibernate.tuple.entity.abstractentitytuplizer.<init>(abstractentitytuplizer.java:135) @ org.hibernate.tuple.entity.pojoentitytuplizer.<init>(pojoentitytuplizer.java:55) @ org.hibernate.tuple.e...
Read more

Accessing MATLAB's unicode strings from C -

Accessing MATLAB's unicode strings from C - how can access underlying unicode info of matlab strings through matlab engine or mex c interfaces? here's example. let's set unicode characters in utf-8 encoded file test.txt, read as fid=fopen('test.txt','r','l','utf-8'); s=fscanf(fid, '%s') in matlab. now if first feature('defaultcharacterset', 'utf-8') , c engevalstring(ep, "s") , output text file utf-8. proves matlab stores unicode internally. if mxarraytostring(enggetvariable(ep, "s")) , unicode2native(s, 'latin-1') give me in matlab: non-latin-1 characters replaced character code 26. need getting access underlying unicode info c string in unicode format (utf-8, utf-16, etc.), , preserving non-latin-1 characters. is possible? my platform os x, matlab r2012b. addendum: documentation explicitly states "[mxarraytostring()] supports multibyte encoded characters...
Read more

javascript - mongodb won't find my schema method in nested container -

javascript - mongodb won't find my schema method in nested container - i trying access method of schema stored within mixed container. here situation : have cases model can many different things, have schema each of these things stored in "casecontent" mixed property. var caseschema = mongoose.schema({ casecontent : {}, object : {type:string, default : "null"}, collision : {type : boolean, default : false} }); the casecontent property filled model of 1 of schemas, 1 exemple : var treeschema = new mongoose.schema({ applecount : {type : number, default : 3} }); treeschema.methods.dostuff = function (data) { console.log('hey, listen'); homecoming true; }; then, want utilize method of schema original container : caseschema.methods.dostuff = function (data) { if (this.casecontent.dostuff !== undefined) { this.casecontent.dostuff(); console.log('it worked'); } else { ...
Read more