Collation question

Question

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Stokes SSCrazy Eights Points: 9861 More actions · Answer 1

Try using 'collate database_default'.

CREATE VIEW dbo.YYYY

AS

SELECT *

FROM ZZZZ.Part.dbo.XXXX XXX_1 collate database_default

------------------------------
The Users are always right - when I'm not wrong!