Category: SQL Server
SQL Server Error Code – 45218 @encryptor_type, and @encryptor_name mus
In this blog post, you’ll learn more about the SQL Server Error Code 45218 and the error message description that is shown SQL Server Error Code 45218 SQL Server Error Description for the Code :45218 @encryptor_type, and @encryptor_name must be specified if @encryption_algorithm is not set to ‘NO_ENCRYPTION’
SQL Server Error Code – 8537 this transaction was aborted by kernel t
In this blog post, you’ll learn more about the SQL Server Error Code 8537 and the error message description that is shown SQL Server Error Code 8537 SQL Server Error Description for the Code :8537 This transaction was aborted by Kernel Transaction Manager (KTM).
How to find the duplicate records on certain fields in SQL Server ?
You can use the group by and having clause in your T-SQL query to find out the duplicate records from the table. How to find the duplicate records on certain fields in SQL Server ? Lets have a look at the query that uses the group by and having clause on the Person table in the AdventureWorks database. The firstname column is used as the…
SQL Server Error Code – 6636 unable to read the compressed showplan x
In this blog post, you’ll learn more about the SQL Server Error Code 6636 and the error message description that is shown SQL Server Error Code 6636 SQL Server Error Description for the Code :6636 Unable to read the compressed showplan xml because it was made with a newer version of SQL server.
SQL Server Error Code – 8143 parameter ‘%.*ls’ was supplied multiple
In this blog post, you’ll learn more about the SQL Server Error Code 8143 and the error message description that is shown SQL Server Error Code 8143 SQL Server Error Description for the Code :8143 Parameter ‘%.*ls’ was supplied multiple times.
SQL Server Error Code – 8155 no column name was specified for column
In this blog post, you’ll learn more about the SQL Server Error Code 8155 and the error message description that is shown SQL Server Error Code 8155 SQL Server Error Description for the Code :8155 No column name was specified for column %d of ‘%.*ls’.
SQL Server Error Code – 46644 external tables for sharded data
In this blog post, you’ll learn more about the SQL Server Error Code 46644 and the error message description that is shown SQL Server Error Code 46644 SQL Server Error Description for the Code :46644 external tables for sharded data
SQL Server Error Code – 2387 %scannot have both ?type? and ?ref? attr
In this blog post, you’ll learn more about the SQL Server Error Code 2387 and the error message description that is shown SQL Server Error Code 2387 SQL Server Error Description for the Code :2387 %sCannot have both ?type? and ?ref? attributes. Location: ?%ls?.
SQL Server Error Code – 5133 directory lookup for the file “%ls” fail
In this blog post, you’ll learn more about the SQL Server Error Code 5133 and the error message description that is shown SQL Server Error Code 5133 SQL Server Error Description for the Code :5133 Directory lookup for the file “%ls” failed with the operating system error %ls.
SQL Server Error Code – 35207 connection attempt on availability group
In this blog post, you’ll learn more about the SQL Server Error Code 35207 and the error message description that is shown SQL Server Error Code 35207 SQL Server Error Description for the Code :35207 Connection attempt on availability group id ‘%ls’ from replica id ‘%ls’ to replica id ‘%ls’ failed because of error %d, severity %d, state %d.
SQL Server Error Code – 13168 service broker
In this blog post, you’ll learn more about the SQL Server Error Code 13168 and the error message description that is shown SQL Server Error Code 13168 SQL Server Error Description for the Code :13168 Service Broker
SQL Server Error Code – 35384 the statement failed because column ‘%.*
In this blog post, you’ll learn more about the SQL Server Error Code 35384 and the error message description that is shown SQL Server Error Code 35384 SQL Server Error Description for the Code :35384 The statement failed because column ‘%.*ls’ on table ‘%.*ls’ is a lob column. Non clustered index with lob column as included column cannot co-exist with clustered columnstore index.
SQL Server Error Code – 41826 stored procedure ‘%.*ls’ tried to set a
In this blog post, you’ll learn more about the SQL Server Error Code 41826 and the error message description that is shown SQL Server Error Code 41826 SQL Server Error Description for the Code :41826 Stored procedure ‘%.*ls’ tried to set a lower limit to the user memory quota. The operation failed because the user memory consumption is larger than the specified target, delete some…
SQL Server Error Code – 8740 the row is too large to be shuffled betw
In this blog post, you’ll learn more about the SQL Server Error Code 8740 and the error message description that is shown SQL Server Error Code 8740 SQL Server Error Description for the Code :8740 The row is too large to be shuffled between distributions. Row Size in Bytes: %d: Max Allowed Row Size in Bytes: %d. Please contact support for assistance.
SQL Server Error Code – 15524 columns of the specified user data type
In this blog post, you’ll learn more about the SQL Server Error Code 15524 and the error message description that is shown SQL Server Error Code 15524 SQL Server Error Description for the Code :15524 Columns of the specified user data type had their rules unbound.
SQL Server Error Code – 17108 password policy update was successful.
In this blog post, you’ll learn more about the SQL Server Error Code 17108 and the error message description that is shown SQL Server Error Code 17108 SQL Server Error Description for the Code :17108 Password policy update was successful.
SQL Server Error Code – 33004 the password of login ‘%.*ls’ is invalid
In this blog post, you’ll learn more about the SQL Server Error Code 33004 and the error message description that is shown SQL Server Error Code 33004 SQL Server Error Description for the Code :33004 The password of login ‘%.*ls’ is invalid. A new password should be set for this login without specifying the old password.
SQL Server Error Code – 40526 ‘%.*ls’ rowset provider not supported in
In this blog post, you’ll learn more about the SQL Server Error Code 40526 and the error message description that is shown SQL Server Error Code 40526 SQL Server Error Description for the Code :40526 ‘%.*ls’ rowset provider not supported in this version of SQL Server.
SQL Server Error Code – 9736 an error occurred in dialog transmission
In this blog post, you’ll learn more about the SQL Server Error Code 9736 and the error message description that is shown SQL Server Error Code 9736 SQL Server Error Description for the Code :9736 An error occurred in dialog transmission: Error: %i, State: %i. %.*ls
SQL Server Error Code – 35361 the statement failed. a clustered column
In this blog post, you’ll learn more about the SQL Server Error Code 35361 and the error message description that is shown SQL Server Error Code 35361 SQL Server Error Description for the Code :35361 The statement failed. A clustered columnstore index cannot be created over referencing column ‘%.*ls’ on table ‘%.*ls’.