This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
A padlocked iron gate across a loading bay lit by one amber wall lamp

SQL SERVER – Error 33222, Level 16 – Audit ‘MyAudit’ Failed to Start

March 31, 2017
Pinal Dave
SQL Tips and Tricks
SQL Audit, SQL Error Messages, SQL Scripts, SQL Server

Error 33222 says only that the audit failed to start. Reproduced on SQL Server 2025: where the real reason hides, and why CREATE succeeded.

Read More
Diagram of an availability group and a Windows Server Failover Cluster: when the lease renewal fails, error 19407 appears and the group moves from PRIMARY_NORMAL and SECONDARY_NORMAL to RESOLVING_NORMAL

Error 19407: The Lease Between the Availability Group and the Cluster Expired

March 27, 2017
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL High Availability, SQL Server, SQL Server Cluster

Error 19407 means the lease between an availability group and the Windows Server Failover Cluster has expired, and the group goes to Resolving. Here is what each ERRORLOG line says and what to look at first.

Read More
Gouache painting of two nearly identical jigsaw puzzle pieces on a table that look alike but do not interlock, one cream and one vermilion

Error 468: Could Not Use View sysdac_instances Because of Binding Errors

March 25, 2017
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Error Messages, SQL Scripts, System Database

Error 468 appeared as soon as we right clicked a database in SQL Server Management Studio. The view msdb.dbo.sysdac_instances could not be used because of binding errors. A collation mismatch between master and msdb caused it, and rebuilding the system databases fixed it.

Read More
Results window showing SELECT * FROM MyTable.

SQL SERVER – Jump in Identity Column After Restart

March 24, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Identity, SQL Scripts, SQL Server, SQL Server Configuration, TraceFlags

A change in SQL Server 2012 can cause a jump in identity column values after a restart. Here are the steps to reproduce it and what you can do about it.

Read More
Remote Registry disabled.

SQL SERVER – Microsoft.SqlServer.Management.Sdk. Sfc.EnumeratorException: Failed to Retrieve Data for This Request

March 18, 2017
Pinal Dave
SQL Tips and Tricks
Registry, SQL Error Messages, SQL Server

Installing a service pack on a clustered instance failed with EnumeratorException: Failed to retrieve data for this request. Detail.txt showed the cause.

Read More
Gouache painting of two server groups with one database card missing from the second group

SQL SERVER – Availability Group Missing or Deleted Automatically?

March 17, 2017
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL High Availability, SQL Server

Investigate an availability group missing from SSMS by comparing SQL metadata, replica state and cluster logs before choosing a recovery procedure.

Read More
SQL SERVER - Maintenance Plan - Could not load type 'Microsoft.SqlServer.Dts. Runtime.Wrapper. IDTSPackageSigning100' from Assembly

SQL SERVER – Maintenance Plan – Could not load type ‘Microsoft.SqlServer.Dts. Runtime.Wrapper. IDTSPackageSigning100’ from Assembly

March 15, 2017
Pinal Dave
SQL Tips and Tricks
Maintenance Plan, SQL Error Messages, SQL Server, SQL Server Management Studio

Fix the maintenance plan error in SSMS, could not load type IDTSPackageSigning100, when existing plans run fine but you cannot modify them.

Read More
Previous 1 … 52 53 54 55 56 57 58 … 117 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com