sql server 2016 复制表格时显示此信息,希望得到各位解决
Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException
HResult=0x80131500
Message=Failed to retrieve data for this request.
Source=Microsoft.SqlServer.Management.Sdk.Sfc
StackTrace:
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.SqlMgmt.PermissionsData.PermissionState.GetGrantedOrDeniedPermissions(Securable securable, Principal principal, PermissionStateCollection permissionStates)
at Microsoft.SqlServer.Management.SqlMgmt.PermissionsData.PermissionState.GetPermissionStates(Securable securable, Principal principal)
at Microsoft.SqlServer.Management.SqlMgmt.PermissionsData.PermissionState.PopulatePermissionStates(Securable securable, Principal principal)
at Microsoft.SqlServer.Management.SqlMgmt.PermissionsData.Principal.GetPermissionStates(Securable securable)
at Microsoft.SqlServer.Management.SqlMgmt.PermissionsDetailsGrid.GetPermissionStateCollection()
at Microsoft.SqlServer.Management.SqlMgmt.PermissionsDetailsGrid.RefreshGrid()
at Microsoft.SqlServer.Management.SqlMgmt.PermissionsDetailsGrid.set_Principal(Principal value)
at Microsoft.SqlServer.Management.SqlMgmt.PermissionsPrincipalSelector.RefreshGrid()
at Microsoft.SqlServer.Management.SqlMgmt.PermissionsPrincipalSelector.InitializePrincipalsGrid()
at Microsoft.SqlServer.Management.SqlMgmt.PermissionsPrincipalSelector.OnHandleCreated(EventArgs e)
at System.Windows.Forms.Control.WmCreate(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.UserControl.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
建议换成navicat 更好用,或者检查一下你的SQLServer版本是否和服务器的SQLServer版本一致,
数据需要复制表格数据的话,可以使用导入、导出功能