Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR: “The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)” EXPLANATION: You may encounter an …
Read More »
MSSQL
Tip: “sp_validatelogins” and “sp_change_users_login”(Orphaned Users in SQL Server)
Detect Orphaned Windows Logins(sp_validatelogins) With this system SP, you can identify Windows Logins that have been deleted from Active Directory on a SQL Server Instance. …
Read More »Cannot insert the value NULL into column ‘owner_sid’, table ‘msdb.dbo.sysjobs’; column does not allow nulls. INSERT fails.
ERROR: “Cannot insert the value NULL into column ‘owner_sid’, table ‘msdb.dbo.sysjobs’; column does not allow nulls. INSERT fails.” EXPLANATION: Because a server will be …
Read More »ORA-01591 lock held by in-doubt distributed transaction
With the DB link, you can get an ORA-01591 error if you join the tables in the queried database with the tables in a …
Read More »How To Set Filegroup As Readonly
For more information about Filegroup, please read the article “How to Create a Database on SQL Server“. Especially in large and partitioned databases, we …
Read More »Proxy (1) is not allowed for subsystem “SSIS” and user “xxxUser”
ERROR: Proxy (1) is not allowed for subsystem “SSIS” and user “xxxUser”. Grant permission by calling sp_grant_proxy_to_subsystem or sp_grant_login_to_proxy. EXPLANATION: In fact, the content of …
Read More »Error authenticating proxy DOMAIN\USER
ERROR: Unable to start execution of step 1 (reason: Error authenticating proxy DOMAIN\USER, system error: ConnGetProxyPassword). The step failed. EXPLANATION: I encountered this error …
Read More »Cannot insert the value NULL into column ‘permission path’, table ‘@temp’; column does not allow nulls
ERROR: Msg 515, Level 16, State 2, Procedure sp_validate_user, Line 19 Cannot insert the value NULL into column ‘permission path’, table ‘@temp’; column does …
Read More »User ‘dbo’ could not execute stored procedure ‘master.dbo.sp_enable_sql_debug’ on SQL Server
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 »