How can I see who is "subscribed" to a specific thread (i.e.getting email notifications)?  I'm HOST, but I can't find the mechanism.  Maybe I need an SQL report?

Here are two stored procedures I created for this very reason. The first pulls everyone tracking a specific thread. The second pulls everyone tracking a specific forum.

CREATE PROCEDURE {databaseOwner}[{objectQualifier}Forum_UserTracking_GetThread] ( @ThreadID INT ) AS SELECT TT.ThreadID, P.Subject, U.UserID, U.Email, TT.CreatedDate, U.Username FROM {databaseOwner}{objectQualifier}Forum_TrackedThreads TT INNER JOIN {databaseOwner}{objectQualifier}Users U ON TT.UserID = U.UserID INNER JOIN {databaseOwner}{objectQualifier}Forum_Posts P ON TT.ThreadID = P.ThreadID WHERE TT.ThreadID = @ThreadID ORDER BY U.Email GO

CREATE PROCEDURE {databaseOwner}[{objectQualifier}Forum_UserTracking_GetForum] ( @ForumID INT ) AS SELECT TF.ForumID, F.NAME, U.UserID, U.Email, TF.CreatedDate, U.Username FROM {databaseOwner}{objectQualifier}Forum_TrackedForums TF INNER JOIN {databaseOwner}{objectQualifier}Users U ON TF.UserID = U.UserID INNER JOIN {databaseOwner}{objectQualifier}Forum_Forums F ON TF.ForumID = F.ForumID WHERE TF.ForumID = @ForumID ORDER BY U.Email GO

---

Chris Paterra

Get direct answers to your questions in the Community Exchange.