Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR: “Internal I/O request 0x4BD9EAE8: Op: Write, pBuffer: 0x05350000, Size: 983040, Position: 369629696, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0x16081A00, OffsetHigh: 0x0, m_buf: 0x05350000, …
Read More »
Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission.
ERROR: “Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do …
Read More »The database principal owns a schema in the database, and cannot be dropped.
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 » 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 »