Hi Mark,

Nice article on forecasting using T-SQL! I know it's been a while since you wrote this article but wanted to know if you think this technique would...

Sorry, I should have been more specific. The index structure is not being updated, but the statistics about the index would be updated. My point really was that...

Okay, just be clear I work with SQL Server 2005 right now so I went to 2005 BOL by default. My thoughts were not meant to be shallow, but...

Got this wrong but... found in BOL 2005 the following remarks.

Updates information about the distribution of key values for one or more statistics groups (collections) in the specified...

This worked for me.

General:

ResultSet - None

ConnectionType - ADO.NET

SQLSourceType - Direct input

SQL Statement - exec dbo.proc_Name '2011-04-30','2011-04-30','2011-04-30'

IsQueryStoredProcedure - False

Parameter Mapping:

Variable Name Direction ...

Hi Jay, I say your post about what can cause a cyclic loop between a table trigger and a replication trigger.  We seem to be having this problem because we...