I am going to use the sp_add_category system procedure to define a peformance category.
<span style="color: #008000;">-- Add a custom category for alerts
@name=N'[Alert By Performance]' ;
-- Show Alert categoryes
EXEC msdb.dbo.sp_help_category @class=N'ALERT'
The sp_add_alert […]
Today, I am going to talk about setting up alerts for system error messages that might occur with your SQL server database. Since alerts have been around for […]
SQL Server supports the notification of administrators through operators. Operators are aliases for users or groups that can receive notifications when jobs complete or alerts have been raised. Each SQL Server instance can have its own set of defined operators.
Today, I am going to walk you thru the following tasks in Transaction SQL.
Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine. It is very important to configure mail on any server that you manage. Error and performance alerting as well as SQL agent job outcomes depend upon this service for notifications.
I am going to copy a paragraph […]
Today, I am going to start writing another topic thread for Database Administration (DBA). I do alot of DBA work among many other things at my current job. I am going to cheat a little by copying a list from a renown SQL Server MVP named Paul Randal. This list was published […]
Cloud TagsALTER TABLE ALTER TRIGGER BEGIN CREATE DATABASE create function create procedure CREATE TABLE create trigger create view database administrator database developer DATEPART date time functions DDL DECLARE DELETE DROP TRIGGER DROP VIEW EXISTS FORMAT free code IF INSERT ISNULL John F. Miner III math function PASS Presentation PRINT REPLACE SELECT sp_help sp_helptext SQL Server SQL Server Management Studio SSMS. string function sys.objects TRIGGERS TRUNCATE TABLE TSQL UPDATE User Group vb script while