Friday , November 22 2024

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

Tag Archives: AFTER DELETE

SQL Server Database Mail History Cleanup and Prevent msdb Database From Growing

Faruk Erdem October 24, 2019 MSSQL 0

If you are using SQL Server Database Mail, your msdb database can grow undesirably. We can use the msdb.dbo.sysmail_delete_mailitems_sp procedure to clear Database Mail History. …

SQL Server Trigger Types

dbtut July 2, 2018 MSSQL 0

Trigger is used to trigger another event when an event occurs in the database server. There are 3 types of trigger. 1) DML(Data Manipulation Language) …