Als ik kies voor de top 1000 rijen op GLAccountsBulk:
dan krijg ik:
Het gaat om:
| SQL Server Management Studio | 15.0.18386.0 | |||||
|---|---|---|---|---|---|---|
| SQL Server Management Objects (SMO) | 16.100.46437.65 | |||||
| Microsoft Analysis Services Client Tools | 15.0.19618.0 | |||||
| Microsoft Data Access Components (MDAC) | 10.0.17763.4492 | |||||
| Microsoft MSXML | 3.0 6.0 | |||||
| Microsoft .NET Framework | 4.0.30319.42000 | |||||
| Operating System | 10.0.17763 |
Ook met release 24.1.133-BETA treedt dit probleem nog op in combinatie met SQL Server Management Studio 18.
Onder SQL Server Server Management Studio 21 werkt dit nu wel:
Het falende SQL-statement is:
SELECT
clmns.name AS [Name]
FROM
sys.tables AS tbl
INNER JOIN sys.all_columns AS clmns ON clmns.object_id=tbl.object_id
WHERE
(CAST(clmns.is_sparse AS bit)=@_msparam_0 and (ISNULL(clmns.graph_type, 0)=@_msparam_1 or ISNULL(clmns.graph_type, 0)=@_msparam_2 or ISNULL(clmns.graph_type, 0)=@_msparam_3 or ISNULL(clmns.graph_type, 0)=@_msparam_4))and((tbl.name=@_msparam_5 and SCHEMA_NAME(tbl.schema_id)=@_msparam_6))
ORDER BY
clmns.column_id ASC
Onder versie 25.0.33 treedt met SQL Server Management Studio bij rechtsklik op een view op:
TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: Your request has been blocked. This could be due to several reasons.
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
itgengpr015: Unknown table ‘SYS.ALL_VIEWS’. Possible valid alternatives: JobGroups, StockCounts. (Microsoft SQL Server, Error: 49012)
For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-49012-database-engine-error
Het SQL Server-statement dat niet herkend wordt is:
SELECT<LF>clmns.name<SPACE>AS<SPACE>[Name]<LF>FROM<LF>sys.all_views<SPACE>AS<SPACE>v<LF>INNER<SPACE>JOIN<SPACE>sys.all_columns<SPACE>AS<SPACE>clmns<SPACE>ON<SPACE>clmns.object_id=v.object_id<LF>WHERE<LF>(CAST(clmns.is_sparse<SPACE>AS<SPACE>bit)=@_msparam_0<SPACE>and<SPACE>(ISNULL(clmns.graph_type,<SPACE>0)=@_msparam_1<SPACE>or<SPACE>ISNULL(clmns.graph_type,<SPACE>0)=@_msparam_2<SPACE>or<SPACE>ISNULL(clmns.graph_type,<SPACE>0)=@_msparam_3<SPACE>or<SPACE>ISNULL(clmns.graph_type,<SPACE>0)=@_msparam_4))and((v.type<SPACE>=<SPACE>@_msparam_5)and(v.name=@_msparam_6<SPACE>and<SPACE>SCHEMA_NAME(v.schema_id)=@_msparam_7))<LF>ORDER<SPACE>BY<LF>clmns.column_id<SPACE>ASC
Een vergelijkbare foutmelding treedt op bij tabellen:
TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: Your request has been blocked. This could be due to several reasons.
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
itgengpr015: Unknown table ‘SYS.TABLES’. Possible valid alternatives: Currencies, Receivables, Profiles, Messages, VatSystems, Assets, Schedules. (Microsoft SQL Server, Error: 49012)
For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-49012-database-engine-error
Het bijbehorende SQL Server-statement dat niet herkend wordt is:
SELECT<LF>clmns.name<SPACE>AS<SPACE>[Name]<LF>FROM<LF>sys.tables<SPACE>AS<SPACE>tbl<LF>INNER<SPACE>JOIN<SPACE>sys.all_columns<SPACE>AS<SPACE>clmns<SPACE>ON<SPACE>clmns.object_id=tbl.object_id<LF>WHERE<LF>(CAST(clmns.is_sparse<SPACE>AS<SPACE>bit)=@_msparam_0<SPACE>and<SPACE>(ISNULL(clmns.graph_type,<SPACE>0)=@_msparam_1<SPACE>or<SPACE>ISNULL(clmns.graph_type,<SPACE>0)=@_msparam_2<SPACE>or<SPACE>ISNULL(clmns.graph_type,<SPACE>0)=@_msparam_3<SPACE>or<SPACE>ISNULL(clmns.graph_type,<SPACE>0)=@_msparam_4))and((tbl.name=@_msparam_5<SPACE>and<SPACE>SCHEMA_NAME(tbl.schema_id)=@_msparam_6))<LF>ORDER<SPACE>BY<LF>clmns.column_id<SPACE>ASC