Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

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 nameData typeDescription
category_idintID of the category
category_classintType of item in the category: 1 = Job; 2 = Alert; 3 = Operator
category_typetinyintType of category: 1 = Local; 2 = Multiserver; 3 = None
namesysnameName of the category

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2018, Patrick Jasinski.