I need to create a view from another database (linked as connectionserver) but here I need a different collation.
Example:
CREATE VIEW vw_table1
AS
SELECT *
FROM server2.table1;
How can I specify the collation by using this script?
Thanks in advance