整理设置 [英] Collation settings

问题描述

您好 - SQL Server上的默认排序规则设置为 SQL服务器的排序规则设置更改为与数据库设置相同的设置为  维护我们在数据库上配置的用户，代理作业等。

Hi- The default collation settings on SQL server is set to Latin1_General_CI_AS. The SQL database instance has collation setting of "SQL_Latin1_General_CP1_CI_AS". Now the application team has requested that the collation settings for the SQL server be changed to the same as database setting to maintain the users, agent jobs etc that we have configured on the database.

此外，我们将有另一个SQL数据库具有排序规则设置"Latin1_General_CI_AS"。 

In addition, we are going to have another SQL database with collation setting "Latin1_General_CI_AS". 

我的查询是，如果我们将默认SQL服务器排序规则设置为"SQL_Latin1_General_CP1_CI_AS"，这是否会对其他数据库产生影响 使用整理设置"Latin1_General_CI_AS"。

My query is if we set the default SQL server collation to "SQL_Latin1_General_CP1_CI_AS", will this have an impact to the other database with collation setting "Latin1_General_CI_AS".

谢谢！

推荐答案

您的描述有点混乱。 SQL实例是SQL服务器。您是在谈论数据库和SQL实例上的排序规则吗？

Your description is a bit confused. The SQL instance is the SQL server. Are you talking about the collations on the database and the SQL instance?

这篇关于整理设置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！