Viewing 5 posts - 1 through 5 (of 5 total)
I dont know if you need this for teach but If you want to fall on the catch, try with sp_executesql N'INSERT INTO TMPTABLE......' because this way SQL dont compile...
August 12, 2013 at 12:48 pm
#1640679
The solution: I created a SP on Server2 (this will be the Publicator) It executes the SP who create the data at the end SELECT this data, so the SP...
August 9, 2013 at 7:41 am
#1640150
Thanks everyone!
After think about this problem! and thanks to that the planets were aligned, I found the light at the end of the tunnel! jejeje I find a way to...
August 7, 2013 at 9:07 am
#1639437
Actually, around 280000 rows and I make the test on my own laptop, but It will work on LAN.
Thanks
August 6, 2013 at 5:25 pm
#1639176
Sadly, SQL Server scan the table from linked server, thats why you cant do it quickly. I am looking for the answer too and when I find it, I will...
August 6, 2013 at 3:02 pm
#1639139