question

RahulPathak-9426 avatar image
0 Votes"
RahulPathak-9426 asked Monalv-msft edited

SSISDB and master db has different collation

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-generalsql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @RahulPathak-9426 ,

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.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @RahulPathak-9426 ,

May I know if you have anything to update?

Best regards,

Mona

0 Votes 0 ·