I want ip address of sql server while copying data using a stored procedure

Question

I have a job which has a stored procedure that copies data from one server to another.But problem is that there are two servers,in one i've to copy data in batch of 50 and other in the batch of 10.So,i need to check ip addresses in that case

Answer 1

see http://stackoverflow.com/questions/142142/sql-query-to-get-servers-ip-address