Monitor/alert single user mode on SQL 2005

[Ben Derr]

I see that there is a db engine rule that alerts on event id 18461, which is
triggered by starting the db instance in single user mode, but only for SQL
2000 db engine objects. Is this not a rule in SQL 2005?

[Anders Bengtsson]

Hi Ben,

You will have to look in the SQL MP guide and see if there is any information
about this. You can also export the MP and search the XML file for 18461.

-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se


BD> I see that there is a db engine rule that alerts on event id 18461,
BD> which is triggered by starting the db instance in single user mode,
BD> but only for SQL 2000 db engine objects. Is this not a rule in SQL
BD> 2005?
BD>

[Ben Derr]

I previously did, and I did not find anything, which brings me back to here.

Post by Anders Bengtsson
Hi Ben,
You will have to look in the SQL MP guide and see if there is any information
about this. You can also export the MP and search the XML file for 18461.
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
BD> I see that there is a db engine rule that alerts on event id 18461,
BD> which is triggered by starting the db instance in single user mode,
BD> but only for SQL 2000 db engine objects. Is this not a rule in SQL
BD> 2005?
BD>

[Anders Bengtsson]

Hi Ben,

Ok, if you cant find anything about it, even after you have export the MP
and search the XML file. Then maybe you need to create a new rule on your
own to monitor that event.

-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se


BD> I previously did, and I did not find anything, which brings me back
BD> to here.
BD>
BD> "Anders Bengtsson" wrote:
BD>

Post by Anders Bengtsson
Hi Ben,
You will have to look in the SQL MP guide and see if there is any
information about this. You can also export the MP and search the XML
file for 18461.
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
BD> I see that there is a db engine rule that alerts on event id 18461,
BD> which is triggered by starting the db instance in single user mode,
BD> but only for SQL 2000 db engine objects. Is this not a rule in SQL
BD> 2005?
BD>