Alert script

can anyone help me with a script that the help desk can
run or execute that will page me if there is a problem
with one of the databases that I support. We are trying to
use the help desk as the middle man between the DBA and
the users. Instead of the users calling the DBA direct
they will have to open a ticket with the help desk which
will automatically page the DBA on call.
Thanks for any help.Have you looked at Alerts in SQL Server. These can mail you (If you setup mail) when certain things go wrong. As for user problems. You could have a ticket type of DB Problem and when the database receives that after being inputted by your help
desk it would trigger a mail. This could be through SQL Mail or perhaps your Helpdesk software has this capability.
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.orgsql