Aim - to copy a table containing geometry fields between two database servers.
The task was made slightly trickier as the two servers are on two different domains.
I wanted to use SQL rather than FME, or a SQL Server wizard, as it would be easier to script the process for the several tables I had to copy.
The first task was to set up linked servers. I used the following SQL (when logged in to my destination server, and using SQL Server Management Studio) to add the source server:
EXEC sp_addLinkedServer 'MY_SOURCE_SERVER_NAME'