Oh nice, that may just work )

However my linked server is actually on the same machine, but another instance. There is a syntax error, it does not like the \ between servername\instance so I tried it like servername.instance and it did not like the slash or the period.