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