Category: SQL Server

SQL Server Error Code – 33508 column ‘%.*ls’ cannot be passed as a par

In this blog post, you’ll learn more about the SQL Server Error Code 33508 and the error message description that is shown SQL Server Error Code 33508 SQL Server Error Description for the Code :33508 Column ‘%.*ls’ cannot be passed as a parameter for a BLOCK security predicate because the column definition contains an expression using a window function. Modify the BLOCK security predicates for…

SQL Server Error Code – 3272 the ?%ls? device has a hardware sector s

In this blog post, you’ll learn more about the SQL Server Error Code 3272 and the error message description that is shown SQL Server Error Code 3272 SQL Server Error Description for the Code :3272 The ?%ls? device has a hardware sector size of %d, but the block size parameter specifies an incompatible override value of %d. Reissue the statement using a compatible block size.

SQL Server Error Code – 35266 always on availability groups connection

In this blog post, you’ll learn more about the SQL Server Error Code 35266 and the error message description that is shown SQL Server Error Code 35266 SQL Server Error Description for the Code :35266 Always On Availability Groups connection with %S_MSG database established for %S_MSG database ‘%.*ls’ on the availability replica ‘%.*ls’ with Replica ID: {%.8x-%.4x-%.4x-%.2x%.2x-%.2x%.2x%.2x%.2x%.2x%.2x}. This is an informational message only. No user…

SQL Server Error Code – 20611 cannot add the article. publications tha

In this blog post, you’ll learn more about the SQL Server Error Code 20611 and the error message description that is shown SQL Server Error Code 20611 SQL Server Error Description for the Code :20611 Cannot add the article. Publications that allow transformable subscriptions with Data Transformation Services (DTS) can only include tables and indexed views that are published as tables.

SQL Server Error Code – 41636 fabric service ‘%ls’ (partition id ‘%ls’

In this blog post, you’ll learn more about the SQL Server Error Code 41636 and the error message description that is shown SQL Server Error Code 41636 SQL Server Error Description for the Code :41636 Fabric Service ‘%ls’ (partition ID ‘%ls’) is unable to enqueue a work item for the database restart of ‘%ls’ database (ID %d). The administrator may have exhausted all available resources. …

How to get the Size of all tables in a SQL Server ?

In SQL Server 2014 Management Studio , you can get the size of all tables in a SQL Server from the Object explorer details window. How to get the Size of all tables in a SQL Server ? 1. In SQL Management Studio 2014 , navigate to the Object explorer details screen from View -> Object explorer details menu or by simply pressing the F7…