Koen Verbeeck (7/16/2012)
SQLRNNR (7/13/2012)
Koen Verbeeck (7/12/2012)
You have to make sure SQLNCLI10 is used, as SQLNCLI11 doesn't support connections to SQL Server 2000. Which provider did you choose in the Linked Server menu?Koen, have you been able to get it to work?
Just curious since there is no upgrade path from 2000 to 2012 and 2000 compat mode is not even supported in 2012. That in mind makes me think that linked servers from 2012 down to 2000 are not supported either.
I'm not the OP, so I don't know 🙂
I knew that.
I was curious if you had ever tried to create a linked server between 2k and 2k12 yourself and gotten it to work. 🙂
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events