Ah ok.
No I haven't created a linked server to SQL2000.
I replied to this thread originally because I know the 2012 native client is unable to connect to 2000.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP