CREATE FUNCTION dbo.[fnGetMonthDays1]

(

@DATE DATE

)

RETURNS INT

AS

BEGIN

RETURN DAY(DATEADD(DAY,-1,DATEADD(MONTH,1,CONVERT(DATE,@DATE,101))))

END

will not work, check:

SELECT dbo.fnGetMonthDays1(CONVERT(DATE,'31 Jan 2012'))

You repeat explanation of "Consider Using a Foreign Key in the Search Key of the Clustered Index" in "Consider Having Included Columns in your Indexes " 😉

I think it is better to put "s.database_id = db_id()" in join statement

... INNER JOIN SYS.INDEXES AS I ON I.[OBJECT_ID] = S.[OBJECT_ID] AND I.INDEX_ID = S.INDEX_ID and S.database_id =...

I try, of course.

When I try to make subscription, if set only servername\instancename, wizard can not to connect to this instance, but when put servername\instancename, port - it send...

Cool,

It is nice solution, and with some modification, it can be usefully.