Looks like I modified the incorrect stored procedure.
Here are the two that make the difference:
GO
/****** Object: StoredProcedure [dbo].[Blog_ListEntriesByPortal] Script Date: 09/22/2009 09:03:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Blog_ListEntriesByPortal]
@PortalID int,
@BlogDate datetime = null,
@ShowNonPublic bit = 0,
@ShowNonPublished bit=0,
@MaxEntries int = 10
AS
If @BlogDate IS NULL SET @BlogDate = GetUTCDate()
SET rowcount @MaxEntries
SELECT
U.[UserID],
U.[Username],
U.[FirstName] + ' ' + U.[LastName] AS UserFullName,
E.[EntryID],
E.[BlogID],
E.[Title],
E.[Description],
E.[Entry],
E.[AddedDate],
E.[Published],
E.[Copyright],
E.[PermaLink],
IsNull(E.[AllowComments],B.[AllowComments]) As AllowComments,
B.[ParentBlogID],
B.[AllowAnonymous],
B.[Syndicated] AS BlogSyndicated,
B.[Public] AS BlogPublic,
B.[SyndicationEmail] as SyndicationEmail,
(Select Count(*) FROM dbo.Blog_Comments WHERE EntryID = E.EntryID AND (Approved = 1 OR Approved <> @ShowNonPublic)) As CommentCount
FROM dbo.Blog_Blogs B INNER JOIN
dbo.Blog_Entries E ON B.[BlogID] = E.[BlogID] INNER JOIN
dbo.Users U ON B.[UserID] = U.[UserID]
WHERE B.PortalID = @PortalID AND E.AddedDate <= DATEADD(day,1,@BlogDate)
AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished)
AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic)
ORDER BY E.AddedDate DESC
GO
/****** Object: StoredProcedure [dbo].[Blog_ListEntriesByBlog] Script Date: 09/22/2009 09:04:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Blog_ListEntriesByBlog]
@BlogID int,
@BlogDate datetime = null,
@ShowNonPublic bit = 0,
@ShowNonPublished bit=0,
@MaxEntries int =10
AS
If @BlogDate IS NULL SET @BlogDate = GetUTCDate()
SET rowcount @MaxEntries
SELECT
U.[UserID],
U.[Username],
U.[FirstName] + ' ' + U.[LastName] AS UserFullName,
E.[EntryID],
E.[BlogID],
E.[Title],
E.[Description],
E.[Entry],
E.[AddedDate],
E.[Published],
E.[Copyright],
E.[PermaLink],
IsNull(E.[AllowComments],B.[AllowComments]) As AllowComments,
(Select Count(*) FROM dbo.Blog_Comments WHERE EntryID = E.EntryID AND (Approved = 1 OR Approved <> @ShowNonPublic)) As CommentCount,
B.[PortalID] As BlogPortalID,
B.[ParentBlogID],
B.[Title] As BlogTitle,
B.[Description] As BlogDescription,
B.[Public] As BlogPublic,
B.[AllowComments] As BlogAllowComments,
B.[AllowAnonymous] As BlogAllowAnonymous,
B.[LastEntry] As BlogLastEntry,
B.[Created] As BlogCreated,
B.[Culture] As BlogCulture,
B.[ShowFullname] As BlogShowFullName,
B.[Dateformat] As BlogDateformat,
B.[TimeZone] As BlogTimeZone,
B.[Syndicated] As BlogSyndicated,
B.[SyndicateIndependant] As BlogSyndicateIndependant,
B.[SyndicationEmail] As SyndicationEmail
FROM dbo.Blog_Blogs B INNER JOIN
dbo.Blog_Entries E ON B.[BlogID] = E.[BlogID] INNER JOIN
dbo.Users U ON B.[UserID] = U.[UserID]
WHERE (B.[BlogID] = @BlogID OR B.[ParentBlogID] = @BlogID)
AND E.AddedDate <= DATEADD(day,1,@BlogDate)
AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished)
AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic)
ORDER BY E.AddedDate DESC