microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Portal Content search based Notifications

Subject: Re: Portal Content search based Notifications
From: "kate"
Date: 22 Feb 2006 04:18:51 -0800
Newsgroups: microsoft.public.sqlserver.notificationsvcs
which one you use probably depends which you are more comfortable with.
the submission SP's are easy to use if you are calling from TSQL.
However, with the sort of iterative processing you are going to have to
do to search out all your keywords, it may be better to call from an
assembly either as a stored proc or outside the sqlserver and use the
EventLoader class.

the best approach to parsing would be to use the built-in sql indexing
to do the bulk of the work for you and then interrogate the indexing.
obviously it would make sense to remove duplicate passes for the same
keyword from different users. Have a look on BOL about the sql indexing
component ...

kate


<Prev in Thread] Current Thread [Next in Thread>