I have a procedure which pulls data from one database and insert into another. Sofar both the databases were in same server. Now one of the database will be shifted a remote server. Wot are the changes I will have to make in the procedure..? How will I insert into the tables in remote database..?
Thanks in advance...