AUTOMATING ADMINISTRATION (Page 5)

RAISERROR You can raise error messages with the RAISERROR command which returns a user-defined error message and sets a system flag to record that an error has occurred. RAISERROR can either retrieve an entry from the sysmessages table or build a message dynamically with user-specified severity and state information. After the message is defined it …

Continue reading →

AUTOMATING ADMINISTRATION (Page 4)

Creating User-Defined Error Messages Microsoft SQL Server 2000 has a large number of pre-defined messages that are returned to the user when specific events occur. Each message has a severity level. Level 10 are simply for information purposes, whereas level 25 denotes a hardware failure. Some of these errors are written to the NT Event …

Continue reading →

AUTOMATING ADMINISTRATION (Page 3)

Jobs, Events and Alerts The SQL Server 2000 Scheduling engine is run by the SQLServerAgent service. It is very sophisticated and jobs can be specified with multiple inter-dependent steps with multiple complimentary schedules. Types of job Microsoft SQL Server 2000 can schedule a wide variety of jobs. Transact SQL statements. Any single line of Transact …

Continue reading →

AUTOMATING ADMINISTRATION (Page 2)

Testing SQLMail Once configured, you can test SQLMail be sending an email from Microsoft SQL Server 2000 to one of your Exchange Accounts One way of doing this is to use the extended stored procedure xp_sendmail xp_sendmail This extended stored procedure sends a message and a query result set attachment to the specified recipients. Syntax …

Continue reading →

AUTOMATING ADMINISTRATION (Page 1)

Automating Administration Topics in this Tutorials Automation overview Setting up SQLMail Setting up operators Jobs, events and alerts Types of job Creating user-defined error messages Setting up alerts Multi-server jobs Automation Overview Design Goal: Easier Administration One of SQL Server design goals has always been to make life easier for administrators. This includes a number …

Continue reading →

AUTOMATING ADMINISTRATION

Automating Administration Topics in this Tutorials Automation overview Setting up SQLMail Setting up operators Jobs, events and alerts Types of job Creating user-defined error messages Setting up alerts Multi-server jobs Automation Overview Design Goal: Easier Administration One of SQL Server design goals has always been to make life easier for administrators. This includes a number …

Continue reading →