We currently have a SQL 2005 Server which we use as a report server.
This now needs to link to a Navision database on a SQL 2014 server using collation Latin1_General_100_CI_AS.
I have happily set up a linked server on SQL 2005 but any queries using it fail.
Can anyone advise on how to add Latin1_General_100_CI_AS collation on SQL Server 2005?
Is this even possible or will have to upgrade the SQL Server?
Kind regards
Rob
Aucun commentaire:
Enregistrer un commentaire