DATABASE

How to Set a Trace Flag for SQL Server

July 6, 20210

The User Data directory in the registry is not valid. Verify DefaultData key under the instance hive points to a valid directory.

April 28, 20210

SQL: Error Locating Server/Instance Specified [xFFFFFFFF]

April 28, 20210

How to Find SQL Server Configuration Changes History

April 6, 20210

[SQL Server]The server principal “USER” is not able to access the database “SID” under the current security context.

March 28, 20210

[SQL Server]Cannot alter the server role ‘sysadmin’, because it does not exist or you do not have permission.

March 28, 20210

How to Configure the MSSQL Backup Compression as Default Option

March 11, 20210

How to Identify SAP HANA is Single or Multi Container Mode

March 4, 20210

SQL Attach DB: Could not open new database. CREATE DATABASE is aborted.

February 14, 20211

How to Obtain the MSSQL Transaction Log Used Space

January 30, 20210

SAP HANA Alias Commands for sidadm User

November 2, 20200

How to Enable/Unlock “sa” SQL User

October 27, 20200

How to Check if Restart is Required after Modifying HANA Parameter

October 20, 20200

[SQL] Login failed for user. Reason: The account is disabled

September 26, 20200

SQL: Cannot open backup device (OS Error 5 – Access is denied)

September 23, 20200