about set an alert that is about blocking

Hi Guys,
I wonder if there is a way that I can setup an alert when there are some
tables are blocking for a long time? That mean I can get email or call when
blocking is occurred. Thanks.
Iter
In SQL Server 2005
Execute Sp_configure blocked process threshold, 200
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
> Hi Guys,
> I wonder if there is a way that I can setup an alert when there are some
> tables are blocking for a long time? That mean I can get email or call
> when
> blocking is occurred. Thanks.
|||Thank you very much. Is there any solution in SQL server 2000?
"Uri Dimant" wrote:

> Iter
> In SQL Server 2005
> Execute Sp_configure ‘blocked process threshold’, 200
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
>
>

about set an alert that is about blocking

Hi Guys,
I wonder if there is a way that I can setup an alert when there are some
tables are blocking for a long time? That mean I can get email or call when
blocking is occurred. Thanks.Iter
In SQL Server 2005
Execute Sp_configure ?blocked process threshold?, 200
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
> Hi Guys,
> I wonder if there is a way that I can setup an alert when there are some
> tables are blocking for a long time? That mean I can get email or call
> when
> blocking is occurred. Thanks.|||Thank you very much. Is there any solution in SQL server 2000?
"Uri Dimant" wrote:
> Iter
> In SQL Server 2005
> Execute Sp_configure â'blocked process thresholdâ', 200
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
> > Hi Guys,
> > I wonder if there is a way that I can setup an alert when there are some
> > tables are blocking for a long time? That mean I can get email or call
> > when
> > blocking is occurred. Thanks.
>
>

about set an alert that is about blocking

Hi Guys,
I wonder if there is a way that I can setup an alert when there are some
tables are blocking for a long time? That mean I can get email or call when
blocking is occurred. Thanks.Iter
In SQL Server 2005
Execute Sp_configure blocked process threshold, 200
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
> Hi Guys,
> I wonder if there is a way that I can setup an alert when there are some
> tables are blocking for a long time? That mean I can get email or call
> when
> blocking is occurred. Thanks.|||Thank you very much. Is there any solution in SQL server 2000?
"Uri Dimant" wrote:

> Iter
> In SQL Server 2005
> Execute Sp_configure ‘blocked process threshold’, 200
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
>
>

about emailchannel?

I use email to notify my subscribers,but how to define my email format?

any idea?

thanks in advance

I'm not sure what exactly you mean by mail format...

If you are talking about "building" a custom email message with all data from your notification class, you need to create your custom content formatter.

If you have a Shyam Pather's book (2000 or 2005), which is a must-have for everyone working with SQL-NS, building your own custom content formatter is VERY easy if you just modify the sample from the book.

Also, you can use the built-in XSLT content formatter, but I personally found it much easier to build my own one, using C#. Just for your reference, creating a custom content formatter prototype took me just a few hours, so it's not as bad as it may sound...

about DTS

Where can i find DTS for my SQL server express edition?

Please email me at chi2king@.yahoo.com

Thanks.

Hi there,

The functionality you are looking for is not a part of SQL Server Express Edition.

You need to use one of the other SQL Server 2005 flavours (e.g. Enterpise, Developer Edition) in order to use SQL Server Integration Services (the successor to DTS in SQL Server 2005).

Also, no offense or unfriendliness meant, but it might be a good idea to refrain from requesting that people email you with answers. It's better for answers to be posted on these forums as others might be in your situation and have the same questions....If they come looking here & find the question but no answer, it disadvantages them somewhat.

Thanks & no offense meant,
Nate
|||

Thanks a lot.

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...
> 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

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

---