Pascal Lebel
Valued Member
Points: 55
More actions
March 28, 2006 at 2:24 pm
#112565
Hi
I have a stored procedure in a database on server1
I need to insert a record in a table on server2 with the stored procedure on server1
I know that I need to link my SQL server to do that
I jus want to know if the performance of my SQL Server will drop if
I link two server.
Thanks
Jo Pattyn
SSC-Dedicated
Points: 32352
March 29, 2006 at 7:23 am
#629477
You will have a performance drop since it needs to communicate with another server.
How large the drop will be depends on the amount of data & network latency.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply