I am writing an online remote database migration tool.
I need to write a stored procedure which can connect
to a remote SQL Server entered by the web-user.
The user will enter the hostname, username and password for the remote server.
How do I connect to this server?
I found something: sp_addlinkedserver - It seems to link to another server :) But how do I use it and how do I perform my SELECT and DELETE statements?