Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR: User ‘dbo’ could not execute stored procedure ‘master.dbo.sp_enable_sql_debug’ on SQL Server EXPLANATION: You may experience this error if you try to debug a …
Read More »An invalid schema or catalog was specified for the provider “SQLNCLI” for linked server “server name”
ERROR: An invalid schema or catalog was specified for the provider “SQLNCLI” for linked server “server name” EXPLANATION: Suppose you have a linked server …
Read More »Rman ORA-27086 unable to lock file – already in use
When you try to get a backup with Rman, if you get errors like ORA-27086, ORA-01580, the first place you should check is nfs …
Read More »FileGroup Backup and FileGroup Restore Operations On SQL Server(Partial Backup-Restore)
We perform FileGroup Backup and Restore operations in databases that are usually large and have more than one filegroup, while some of the filegroups are …
Read More »Invalid attempt to GetBytes on column
ERROR: An error occurred while executing batch. Error message is: Invalid attempt to GetBytes on column ‘xxx’. The GetBytes function can only be used …
Read More »An invalid schema or catalog was specified for the provider “Local Server” for linked server “(null)”.
ERROR: “An invalid schema or catalog was specified for the provider “Local Server” for linked server “(null)”.” EXPLANATION: I received this error message when …
Read More »Login failed. The login is from an untrusted domain and cannot be used with Windows authentication
ERROR: “Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: xxx.35.1.26] Error: 18452, Severity: 14, State: …
Read More »The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service
ERROR: The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. …
Read More »The package is encrypted with a password. The password was not specified, or is not correct.
ERROR: Description: The package is encrypted with a password. The password was not specified, or is not correct. End Error Could not load package …
Read More »Property ErrorLogFile is not available for JobServer ‘server_name’. This property may not exist for this object.
ERROR: Property ErrorLogFile is not available for JobServer ‘server_name’. This property may not exist for this object. EXPLANATION: In SQL Server Management Studio, you …
Read More »