ALTER DATABASE SCOPED CONFIGURATION的问题 [英] Issue with ALTER DATABASE SCOPED CONFIGURATION

问题描述

我们的产品版本是：

Microsoft SQL Server 2017（RTM） - 14.0.1000.169（X64） 

2017年8月22日17:04:49 

版权所有（C）2017 Microsoft Corporation在Windows 10 Enterprise 10.0< X64>上，
企业版（64位） （Build 15063：）（管理程序）

以下设置选项不适用于  ALTER DATABASE SCOPED CONFIGURATION命令

OPTIMIZE_FOR_AD_HOC_WORKLOADS

XTP_PROCEDURE_EXECUTION_STATISTICS

XTP_QUERY_EXECUTION_STATISTICS

ELEVATE_ONLINE

ELEVATE_RESUMABLE

GLOBAL_TEMPORARY_TABLE_AUTODROP

例如：  ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET  OPTIMIZE_FOR_AD_HOC_WORKLOADS = OFF;

错误：

SQL错误：'OPTIMIZE_FOR_AD_HOC_WORKLOADS'附近的语法错误

解决方案

看起来像适用于 ：
Azure SQL数据库

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-scoped-configuration-transact -sql？view = sql-server-2017

our product version is :

Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) 
Aug 22 2017 17:04:49 
Copyright (C) 2017 Microsoft Corporation
Enterprise Edition (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 15063: ) (Hypervisor)

Following set options does not work with ALTER DATABASE SCOPED CONFIGURATION command

OPTIMIZE_FOR_AD_HOC_WORKLOADS

XTP_PROCEDURE_EXECUTION_STATISTICS

XTP_QUERY_EXECUTION_STATISTICS

ELEVATE_ONLINE

ELEVATE_RESUMABLE

GLOBAL_TEMPORARY_TABLE_AUTODROP

eg: ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET  OPTIMIZE_FOR_AD_HOC_WORKLOADS = OFF;

error:

SQL Error: Incorrect syntax near 'OPTIMIZE_FOR_AD_HOC_WORKLOADS'

解决方案

Looks like it Applies to: Azure SQL Database

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-scoped-configuration-transact-sql?view=sql-server-2017

这篇关于ALTER DATABASE SCOPED CONFIGURATION的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！