Category: SQL Server

SQL Server Error Code – 35310 the statement failed because columnstore

In this blog post, you’ll learn more about the SQL Server Error Code 35310 and the error message description that is shown SQL Server Error Code 35310 SQL Server Error Description for the Code :35310 The statement failed because columnstore indexes are not allowed on table types and table variables. Remove the column store index specification from the table type or table variable declaration.

SQL Server Error Code – 46521 queries over external tables are not sup

In this blog post, you’ll learn more about the SQL Server Error Code 46521 and the error message description that is shown SQL Server Error Code 46521 SQL Server Error Description for the Code :46521 Queries over external tables are not supported with the current service tier or performance level of this database. Consider upgrading the service tier or performance level of the database.

SQL Server Error Code – 20624 the value specified for the @login param

In this blog post, you’ll learn more about the SQL Server Error Code 20624 and the error message description that is shown SQL Server Error Code 20624 SQL Server Error Description for the Code :20624 The value specified for the @login parameter is not valid. User ‘%s’ is not a user in database ‘%s’. Add the user account to the database before attempting to execute…

SQL Server Error Code – 5228 table error: object id %d, index id %d,

In this blog post, you’ll learn more about the SQL Server Error Code 5228 and the error message description that is shown SQL Server Error Code 5228 SQL Server Error Description for the Code :5228 Table error: object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), page %S_PGID, row %d. DBCC detected incomplete cleanup from an online index build…