Error: Login failed for login <Login Name> due to trigger execution. Changed database context to ‘master’. Changed language setting to us_english. (Microsoft SQL Server, Error: 17892) Resolution: Search for the trigger via: If you see a server level trigger that might be responsible for the login issues, then you can drop it with: Instead of... » read more
Temporal tables (also known as system-versioned temporal tables) are a database feature that brings built-in support for providing information about data stored in the table at any point in time, rather than only the data that is correct at the current moment in time. Example: Employee (System-Versioned) Sources: https://docs.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables?view=sql-server-ver15
Please open the below link https://aka.ms/getTSS 2. Copy the zip file to the Server 3. Unzip the contents of tss_tools.zip to a folder 4. Open PowerShell as Administrator 5. Change to the directory where the files were extracted 6. Run the following command: .\get-psSDP.ps1 Cluster In case if this command does not work please try .\tss... » read more
Error: Cluster Log: Cluster resource ‘xxxxxx’ of type ‘SQL Server Availability Group’ in clustered role ‘xxxx’ failed. Based on the failure policies for the resource and role, the cluster service may try to bring the resource online on this node or move the group to another node of the cluster and then restart it. Check... » read more
Error: Cannot bring the Windows Server Failover Clustering (WSFC) resource (ID ‘xxxxxxxxxxxxx’) online (Error code 5942). The WSFC service may not be running or may not be accessible in its current state, or the WSFC resource may not be in a state that could accept the request. For information about this error code, see “System... » read more
Issue: The operation could not be performed because OLE DB provider “MSOLEDBSQL” for linked server “XXXXXX” was unable to begin a distributed transaction. Fix: There has been a lot of times where we can encounter this error – “The operation could not be performed because OLE DB provider “SQLNCLI11” for the linked server was unable to... » read more
Step 1 – Validate SQL Server Database Mail First test to see if the system is able to send email using the Database Mail profile in SQL Server Management Studio by navigating to Management > Database Mail, then right clicking on Database Mail and selecting the “Send Test E-Mail…” option. Once the interface loads, select... » read more
If the database can do with just a simple backup/recovery model, then… Change database from “Full” recovery model to “Simple” recovery model (Database Properties -> Options) Shrink database log file (Tasks -> Shrink -> Files -> Shrink Log Files)
Issue: Unable to see a list of past job history. Only see the most recent. Default settings limits to last 1000 records overall and last 100 records per job. Fix: Make sure the Limit size of job history log is not enabled. Else you will not be able to see older jobs history. SQL Agent... » read more
Issue: Unable to access database because it lacks a quorum of nodes for high availability try the operation again later. Fix: Restart failover cluster.