更换了sqlserver的时区并且重起过后依旧未生效
时间: 2023-08-12 08:03:28 浏览: 46
如果您已经按照正确的步骤更改了SQL Server的时区并重启了SQL Server服务,但时区仍未生效,可能有以下原因:
1. 操作系统的时区设置不正确:SQL Server的时区设置是基于操作系统的时区设置的。如果操作系统的时区不正确,那么SQL Server的时区也会不正确。您可以检查操作系统的时区设置是否正确,并进行更正。
2. 数据库的时区设置不正确:SQL Server中的每个数据库都有自己的时区设置。如果数据库的时区设置不正确,那么在该数据库中存储的所有时间戳都会不正确。您可以使用以下命令检查数据库的时区设置:
```
SELECT DATABASEPROPERTYEX('DatabaseName', 'Collation') SQLCollation,
DATABASEPROPERTYEX('DatabaseName', 'ComparisonStyle') SQLComparisonStyle,
DATABASEPROPERTYEX('DatabaseName', 'LCID') SQLLCID,
DATABASEPROPERTYEX('DatabaseName', 'IsFulltextEnabled') SQLIsFulltextEnabled,
DATABASEPROPERTYEX('DatabaseName', 'IsInProgress') SQLIsInProgress,
DATABASEPROPERTYEX('DatabaseName', 'IsOffline') SQLIsOffline,
DATABASEPROPERTYEX('DatabaseName', 'IsReadonly') SQLIsReadOnly,
DATABASEPROPERTYEX('DatabaseName', 'IsSingleUser') SQLIsSingleUser,
DATABASEPROPERTYEX('DatabaseName', 'IsSuspect') SQLIsSuspect,
DATABASEPROPERTYEX('DatabaseName', 'IsAutoClose') SQLIsAutoClose,
DATABASEPROPERTYEX('DatabaseName', 'IsAutoCreateStatistics') SQLIsAutoCreateStatistics,
DATABASEPROPERTYEX('DatabaseName', 'IsAutoUpdateStatistics') SQLIsAutoUpdateStatistics,
DATABASEPROPERTYEX('DatabaseName', 'IsQuotedIdentitiferEnabled') SQLIsQuotedIdentifierEnabled,
DATABASEPROPERTYEX('DatabaseName', 'IsAnsiNullDefaultEnabled') SQLIsAnsiNullDefaultEnabled,
DATABASEPROPERTYEX('DatabaseName', 'IsAnsiNullsEnabled') SQLIsAnsiNullsEnabled,
DATABASEPROPERTYEX('DatabaseName', 'IsAnsiPaddingEnabled') SQLIsAnsiPaddingEnabled,
DATABASEPROPERTYEX('DatabaseName', 'IsAnsiWarningsEnabled') SQLIsAnsiWarningsEnabled,
DATABASEPROPERTYEX('DatabaseName', 'IsArithmeticAbortEnabled') SQLIsArithmeticAbortEnabled,
DATABASEPROPERTYEX('DatabaseName', 'IsConcatNullYieldsNullEnabled') SQLIsConcatNullYieldsNullEnabled,
DATABASEPROPERTYEX('DatabaseName', 'IsNumericRoundAbortEnabled') SQLIsNumericRoundAbortEnabled,
DATABASEPROPERTYEX('DatabaseName', 'IsRecursiveTriggersEnabled') SQLIsRecursiveTriggersEnabled,
DATABASEPROPERTYEX('DatabaseName', 'IsCursorCloseOnCommitEnabled') SQLIsCursorCloseOnCommitEnabled,
DATABASEPROPERTYEX('DatabaseName', 'IsLocalCursorsDefault') SQLIsLocalCursorsDefault,
DATABASEPROPERTYEX('DatabaseName', 'IsFulltextEnabled') SQLIsFulltextEnabled,
DATABASEPROPERTYEX('DatabaseName', 'IsAutoShrink') SQLIsAutoShrink,
DATABASEPROPERTYEX('DatabaseName', 'IsTornPageDetectionEnabled') SQLIsTornPageDetectionEnabled,
DATABASEPROPERTYEX('DatabaseName', 'IsAutoUpdateStatsAsync') SQLIsAutoUpdateStatsAsync,
DATABASEPROPERTYEX('DatabaseName', 'IsParameterizationForced') SQLIsParameterizationForced,
DATABASEPROPERTYEX('DatabaseName', 'IsBrokerEnabled') SQLIsBrokerEnabled,
DATABASEPROPERTYEX('DatabaseName', 'RecoveryModel') SQLRecoveryModel,
DATABASEPROPERTYEX('DatabaseName', 'CollationName') SQLCollationName,
DATABASEPROPERTYEX('DatabaseName', 'ComparisonStyleName') SQLComparisonStyleName,
DATABASEPROPERTYEX('DatabaseName', 'LCIDName') SQLLCIDName,
DATABASEPROPERTYEX('DatabaseName', 'RecoveryModelName') SQLRecoveryModelName,
DATABASEPROPERTYEX('DatabaseName', 'CompatibilityLevel') SQLCompatibilityLevel,
DATABASEPROPERTYEX('DatabaseName', 'UserAccess') SQLUserAccess,
DATABASEPROPERTYEX('DatabaseName', 'Updateability') SQLUpdateability,
DATABASEPROPERTYEX('DatabaseName', 'IsDatabaseSnapshot') SQLIsDatabaseSnapshot,
DATABASEPROPERTYEX('DatabaseName', 'IsReadOnly') SQLIsReadOnly,
DATABASEPROPERTYEX('DatabaseName', 'IsSingleUser') SQLIsSingleUser,
DATABASEPROPERTYEX('DatabaseName', 'IsEmergencyMode') SQLIsEmergencyMode,
DATABASEPROPERTYEX('DatabaseName', 'IsInLoad') SQLIsInLoad,
DATABASEPROPERTYEX('DatabaseName', 'IsOffline') SQLIsOffline,
DATABASEPROPERTYEX('DatabaseName', 'IsOnline') SQLIsOnline,
DATABASEPROPERTYEX('DatabaseName', 'IsSuspect') SQLIsSuspect,
DATABASEPROPERTYEX('DatabaseName', 'IsShutdown') SQLIsShutdown,
DATABASEPROPERTYEX('DatabaseName', 'IsInStandby') SQLIsInStandby,
DATABASEPROPERTYEX('DatabaseName', 'ServiceName') SQLServiceName,
DATABASEPROPERTYEX('DatabaseName', 'SnapshotName') SQLSnapshotName,
DATABASEPROPERTYEX('DatabaseName', 'IsAnsiNullDefaultOn') SQLIsAnsiNullDefaultOn,
DATABASEPROPERTYEX('DatabaseName', 'IsAnsiNullsOn') SQLIsAnsiNullsOn,
DATABASEPROPERTYEX('DatabaseName', 'IsAnsiPaddingOn') SQLIsAnsiPaddingOn,
DATABASEPROPERTYEX('DatabaseName', 'IsAnsiWarningsOn') SQLIsAnsiWarningsOn,
DATABASEPROPERTYEX('DatabaseName', 'IsArithmeticAbortOn') SQLIsArithmeticAbortOn,
DATABASEPROPERTYEX('DatabaseName', 'IsCursorCloseOnCommitOn') SQLIsCursorCloseOnCommitOn,
DATABASEPROPERTYEX('DatabaseName', 'IsLocalCursorDefaultOn') SQLIsLocalCursorDefaultOn,
DATABASEPROPERTYEX('DatabaseName', 'IsQuotedIdentifierOn') SQLIsQuotedIdentifierOn,
DATABASEPROPERTYEX('DatabaseName', 'IsRecursiveTriggersOn') SQLIsRecursiveTriggersOn,
DATABASEPROPERTYEX('DatabaseName', 'IsNumericRoundAbortOn') SQLIsNumericRoundAbortOn,
DATABASEPROPERTYEX('DatabaseName', 'IsConcatNullYieldsNullOn') SQLIsConcatNullYieldsNullOn;
```
如果时区不正确,您可以使用以下命令更正:
```
USE master;
GO
ALTER DATABASE DatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO
ALTER DATABASE DatabaseName COLLATE Latin1_General_CI_AI;
GO
ALTER DATABASE DatabaseName SET MULTI_USER;
GO
```
请将上述命令中的“DatabaseName”替换为您的数据库名称,并将“Latin1_General_CI_AI”替换为您所需的正确时区。
如果以上方法仍无法解决问题,建议您联系SQL Server的支持团队,以获取更进一步的帮助和支持。