In this blog, I would share the steps to identify and fix error – The account running SQL Server Setup does not have administrator rights on the computer.
ANSI_WARNINGS OFF: Why SQL Server Truncates Data Silently
With ANSI_WARNINGS OFF, SQL Server cuts a string to fit its column and reports no error. This post runs the same insert with the setting on and off, and shows what else changes: variables, divide by zero and filtered indexes. It also shows how to check which setting a session uses.
SQL SERVER – Error 15580 – Cannot Drop Master Key Because Dialog “GUID” is Encrypted by It
In this blog, I would share my knowledge about how to fix error 15580 – Cannot drop the master key because dialog “GUID” is encrypted by it.
SQL SERVER – Unable to Allocate Enough Memory to Start ‘SQL OS Boot’. Reduce Non-essential Memory Load or Increase System Memory
In this blog, I would share my learning about error “Unable to allocate enough memory to start ‘SQL OS Boot’. Let us learn the workaround.
Encrypted by Database Master Key: Fix the Always On Error
Adding a database to an availability group can fail with the message that the database is encrypted by database master key, even when TDE is off. This post finds the key, checks what depends on it and lists three ways to continue. A demo database shows the checks and the error that protects a key still in use.
SQL SERVER – Always On Listener Not Coming Online – Failed to Create New NBT Interface, Status 1450
I would share my learning about fixing error “Failed to create new NBT interface, status 1450 “in cluster log while creating the “IP Address” resource.
SQL SERVER – Linked Server Error – Msg 3910 – Transaction Context In Use By Another Session
In this blog, I would share my understanding and the solution of Linked Server Error – Msg 3910 – Transaction context in use by another session.