Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In SQL Server 2005 and later versions, you can find the active node of SQL Server Failover Cluster using the following query. [crayon-673f76c34e8c3332857980/]
Read More »
When was the password for SQL Login changed?
What do you do if you need to know when the password of a SQL Login is changed? You can use the command below …
Read More »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, m_len: 983040, m_actualBytes: 0, m_errcode: 112, BackupFile:
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 »