SYSCATEGORIES

Contains the Categories used by SQL Server Management studio to organize jobs,alerts,and operators this table is stored in the msdb Database

USE msdb
go
SELECT Category_ID,Category_Class,CategoryClassDescription=CASE WHEN Category_Class=1 then 'job'
WHEN Category_Class=2 then'Alert'
WHEN Category_Class=3 THEN 'Operator'END,
Category_Type,CategoryTypeDescription=CASE WHEN Category_Type=1 THEN 'Local'
WHEN Category_Type=2 THEN 'MultiServer'
WHEN Category_Type=3 THEN 'None'END,[Name]
FROM SYSCATEGORIES
ORDER BY Category_id

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server