about Alert

Hi all:
I want to create a Alert,which can email to me when
my log file is attach to 90% full.
How can I do?
Is there Any samples?
Thank you!!
ArronHi:
Follow the list steps, you can create the alert:
1. Start the Enterprize Manager
2. Browser the server you want to create alert
3. Browser the "Management" and right click "Alert"
4. Select "New Alert" to start the alert
5. Change the Types: to "Sql Server perfermence condition alert"
6. Change the objcet to "Sql Server:Databases"
7. Change the counter to "Percentage Log Used"
8. Set the other value as you expect
9. Switch to Response tab
10. Click the "New Operator" and set the e-mail adress
After these steps, the alert should be OK
Best Wishes
Wei Ci Zhou|||Before that, please check if you set the mail profile|||Setting up the mail profile is documented in SQL books online... It requires
that Outlook be installed on the SQL Server... If you may not, or do not
wish to install Outlook, you may go to www.sqldev.com and there is a mail
dll, and sample stored procedures that will allow you to do SMTP
mail...(instead of MAPI mail).
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Arron" <9144492@.pchome.com.tw> wrote in message
news:578601c3e56a$804b52e0$a001280a@.phx.gbl...

quote:

---

> Hi all:
> I want to create a Alert,which can email to me when
> my log file is attach to 90% full.
> How can I do?
> Is there Any samples?
> Thank you!!
> Arron

---