SSISDB and master db has different collation

Rahul Pathak 1 Reputation point
2021-03-02T07:05:39.657+00:00

Is it advisable to keep SSISDB and Master database on different collation? I have my SSISDB on SQL_Latin1_General_CP1_CI_AS and Master on Latin1_General_BIN2. Shall I also get my SSISDB's collation to Latin1_General_BIN2?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,748 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,454 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,896 Reputation points
    2021-03-02T09:46:49.653+00:00

    Hi @Rahul Pathak ,

    Defines a collation of a database or table column, or a collation cast operation when applied to character string expression. Collation name can be either a Windows collation name or a SQL collation name.

    Please refer to COLLATE (Transact-SQL).

    Best regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.