SQL Server 无法在SSMS中打开托管示例数据库的属性选项卡

9gm1akwq 于 2022-11-21 发布在其他

关注(0)|答案(1)|浏览(101)

我正在使用Azure托管示例执行某些迁移任务。我在中有多个数据库，所有数据库都运行正常。但当我尝试打开名为GCDCalculation的数据库的属性时，我收到以下错误：-

整个错误是：-

Cannot show requested dialog.
 
===================================
 
Cannot show requested dialog. (SqlMgmt)
 
------------------------------
Program Location:
 
   at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider, CDataContainer dc)
   at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
   at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
   at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolMenuItemHelper.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
   at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()
 
===================================
 
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. (.Net SqlClient Data Provider)
 
------------------------------
For help, click: https://learn.microsoft.com/sql/relational-databases/errors-events/mssqlserver-512-database-engine-error
 
------------------------------
Server Name: my-project-database.database.windows.net, 3342
Error Number: 512
Severity: 16
State: 1
Line Number: 7
 

------------------------------
Program Location:
 
   at Microsoft.SqlServer.Management.SqlManagerUI.DBPropGeneralData.InitProp()
   at Microsoft.SqlServer.Management.SqlManagerUI.DBPropGeneralData..ctor(CDataContainer context)
   at Microsoft.SqlServer.Management.SqlManagerUI.DBPropGeneral..ctor(CDataContainer dataContainer, DatabasePrototype prototype)
   at Microsoft.SqlServer.Management.SqlManagerUI.DBPropSheet.Init(CDataContainer dataContainer)
   at Microsoft.SqlServer.Management.SqlManagerUI.DBPropSheet..ctor(CDataContainer context)

所有其他数据库运行良好。
除此之外，我还想知道，当我们尝试打开属性选项卡（或任何其他选项卡）时，是否会在后端触发特定查询。

sql-server

来源：https://stackoverflow.com/questions/73119717/cannot-open-the-properties-tab-in-ssms-for-managed-instance-database

1条答案

按热度按时间

r1zk6ea11#

备份出现问题。请运行此查询并将数据库名称更新为最新的名称。

create table #tempbackup (database_name nvarchar(128), [type] char(1), backup_finish_date datetime)
insert into #tempbackup 
select database_name, [type], max(backup_finish_date) from msdb..backupset where [type] = 'D' or [type] = 'L' or [type]='I' group by database_name, [type]

SELECT
(select backup_finish_date from #tempbackup where type = 'D' and db_id(database_name) = dtb.database_id)

AS [LastBackupDate]
FROM
master.sys.databases AS dtb
WHERE
(dtb.name='Your Database Name')

drop table #tempbackup

赞(0）回复(0）举报 2022-11-21

我来回答

SQL Server 无法在SSMS中打开托管示例数据库的属性选项卡

1条答案

相关问题

热门标签

最新问答