• I use appraoch #2 and that working fine for me...

    SQL Server 2012 does not support Linked Server to SQL Server 2000, workaround[/URL]