August 29, 2008 08:12pm pdt

1. angelIII 13,900
2. chapmandew 8,200
3. cactus_d... 4,000
3. EugeneZ 4,000
3. jinesh_ka... 4,000
6. mark_wills 3,580
7. ee_rlee 3,400
8. dragos_c... 3,000
9. dportas 2,950
10. mlmcc 2,200
11. gbshahaq 2,164
12. knightEkni... 2,000
12. dvz 2,000
12. dtodd 2,000
12. aneeshatti... 2,000
12. dorianm 2,000
12. saurabh726 2,000
12. Zippit 2,000
12. burrcm 2,000
12. sujith80 2,000
12. BillBach 2,000
12. Thomasian 2,000
12. matthewr... 2,000
12. coldboy 2,000
12. Smart_Man 2,000

1. angelIII 20,200
2. chapmandew 8,200
3. dqmq 5,630
4. gbshahaq 4,164
5. cactus_d... 4,000
5. jinesh_ka... 4,000
5. EugeneZ 4,000
8. mark_wills 3,580
9. ee_rlee 3,400
10. nedfine 3,375
11. dragos_c... 3,000
11. ram_0218 3,000
13. dportas 2,950
14. harfang 2,664
15. sujith80 2,600
16. jerryb30 2,500
17. rockiroads 2,400
18. gatorvip 2,375
18. rorya 2,375
20. mlmcc 2,200
21. capricorn1 2,100
22. knightEkni... 2,000
22. dvz 2,000
22. TechSoEasy 2,000
22. yodercm 2,000
22. vadimrapp1 2,000
22. aneeshatti... 2,000
22. RQuadling 2,000
22. johnsone 2,000
22. dtodd 2,000
22. mr_egypt... 2,000
22. Kdo 2,000
22. rbrooker 2,000
22. stevbe 2,000
22. Smart_Man 2,000
22. coldboy 2,000
22. saurabh726 2,000
22. cpkilekofp 2,000
22. momi_sa... 2,000
22. epochasset 2,000
22. _agx_ 2,000
22. Jillyn_D 2,000
22. Raynard7 2,000
22. BillBach 2,000
22. ryancys 2,000
22. matthewr... 2,000
22. dorianm 2,000
22. Thomasian 2,000
22. burrcm 2,000
22. andrewbl... 2,000
22. Zippit 2,000
22. jimpen 2,000

07.05.2007 at 09:01AM PDT, ID: 22677135

	[x] Attachment Details

Behavior of sp_addlinkedserver

Asked by andersonpower in Data Manipulation, MS SQL Server

Tags: sp_addlinkedserver

I have a stored procedure that will run daily. This SP will need to call another SP on a different server. To do this, I believe that I should be using sp_addlinkedserver, correct? The SP on the remote server does not return anything -- it just adds a record to the remote database.

My questions are:
1. Does sp_addlinkedserver need to be called every time the remote SP is executed? Or does this command link the servers permanently?
2. If this does link the servers permanently, would there be any performance issues related to leaving them linked? Or should I unlink them when I'm finished?Start Free Trial

Keywords: Behavior of sp_addlinkedserver

	Title
1	sp_spaceused
2	sp_reassign_dtspackageowner Perm…
3	sps 2001 to wss
4	SP finished
5	sp_send_dbmail on insert trigger free…
6	Automate the start and stop of a profile…

Loading Advertisement...

20080716-EE-VQP-32

Behavior of sp_addlinkedserver

Asked by andersonpower in Data Manipulation, MS SQL Server

Tags: sp_addlinkedserver

About this solution