Quick Search

Advanced Search »

Discuss (0) History

syscategories System Table - SQL Server 2000

RSS

Modified on Fri, May 01, 2009, 10:52 AM by Administrator Categorized as SQL Server System Tables

Contains the categories used by SQL Server Enterprise Manager to organize jobs, alerts, and operators. This table is stored in the msdb database

Column name	Data type	Description
category_id	int	ID of the category
category_class	int	Type of item in the category: 1 = Job; 2 = Alert; 3 = Operator
category_type	tinyint	Type of category: 1 = Local; 2 = Multiserver; 3 = None
name	sysname	Name of the category

Jasinski Technical Wiki