Great post as always Louis.

I think I found what I was looking for. The query below gives a good indication of what isn't being replicated:

SELECT * FROM sys.objects so

WHERE object_id NOT IN (SELECT...

Grant, I didn't write this code but I'm not seeing a WHERE clause against the multi-statement table valued function.

As for updating stats, stats have been updated and indexes have been...

I'm glad I can say I didn't write it. Yes, it's a mess. The function returns approximately 30,000 records. But why is it that after I run...

And the table valued function:

CREATE FUNCTION [dbo].[fnInflationMonitorData]

(

@SnapshotID int,

@SnapKind char(1),

@BaseYear int

)

RETURNS

@RepData...

Here is the stored proc:

CREATEPROCEDURE [dbo].[usp_rpt_InflMon]

@OrganizationID Int=NULL,

@PlantID Int=NULL,

@CommodityManagerGroupID Int=NULL,

...

Were you able to find a resolution to this? We are seeing something similar.

I'm having this exact same issue. We're running Windows Server 2008 R2 64 bit and 64 bit SQL Server 2008 Standard SP1 CU8. We upgraded to CU8 last...

This has been occurring on our production server of late, Windows Server 2008 R2 64 bit with 64 bit SQL Server 2008 SP1 CU8. Where is it stated that...

Yesterday, we recompiled most of our stored procedures to drop any #tables as there were a number of stored procedures that didn't do this and the temporary tables were apparently...

Thanks for the quick reply. But with tempdb set to SIMPLE recovery shouldn't it maintain the log file rather than it continue to grow? The way it is...

We resolved it by recycling sql server after manually editing the registry.

Thank you for the quick response. I have the registry entry for DisallowAdHocAccess set to 0 and the advanced options configured correctly but still getting this error.

This file is sent to us so we don't get to choose the identifiers. Although we are putting a call out to those that produce the file to see...

That was exactly it. Thanks for pointing me in the right direction.