Category: SQL Server

SQL Server Error Code – 11543 set statistics xml on and set statistics

In this blog post, you’ll learn more about the SQL Server Error Code 11543 and the error message description that is shown SQL Server Error Code 11543 SQL Server Error Description for the Code :11543 SET STATISTICS XML ON and SET STATISTICS PROFILE ON are not allowed inside any procedure or batch that executes through an EXECUTE statement that has a WITH RESULT SETS clause.

SQL Server Error Code – 13726 setting system_versioning to on failed b

In this blog post, you’ll learn more about the SQL Server Error Code 13726 and the error message description that is shown SQL Server Error Code 13726 SQL Server Error Description for the Code :13726 Setting SYSTEM_VERSIONING to ON failed because history table ‘%.*ls’ is referenced by one or more BLOCK security predicates. Consider removing the BLOCK security predicates referencing this table and trying again.

SQL Server Error Code – 15337 caution: sys.sql_dependencies shows that

In this blog post, you’ll learn more about the SQL Server Error Code 15337 and the error message description that is shown SQL Server Error Code 15337 SQL Server Error Description for the Code :15337 Caution: sys.sql_dependencies shows that other objects (views, procedures and so on) are referencing this object by its old name. These objects will become invalid, and should be dropped and re-created…