Thanks Lynn and Jared.

What gets me is that the function definitions are virtually the same in 3.0 and the 4.0 system. The nested calls are the same. The number...

Does not seem to be. I have included the def in the attachement.

Thanks.

Jared,

I typically try to do my homework. There was something about a timezone change with Windows around the year 2008 for Daylight savings time but I doubt that this is...

There are many things that should be rewritten as the filteredviews are drastically slower than native table calls. There are support and contractual issues that are outside the realm of...

Jared,

Here is the function DDL. I am not allowed to mod that call as that is used in the filteredview itself.

thanks.

Sure. As a background, I've actually compared multiple runs on the basic select top 10000 * against the filtered query for the "Contact" entity. I've done this with many variations...

Jared,

I can see it on the Quest Spotlight Console for History. That particular SPID is holding-up a bunch of other SPIDs.

Thanks.

Thanks for your input guys!

Sorry about that. I'll make this more concrete. Given a parent table A and a child table B, I can see multiple FKs defined for B referencing A on the...

Is there a known value to redundant FKs would be the question?

Sorry about that contradicting post. I was sort of in a migration bind. I installed SQL Server on a new machine and restored a database that was being replicated via...

Thanks guys. I'll do a bit more research too.

Unchecking the checkbox for transactional replication yields:

No active open transactions.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

I think that I'm good now. Thank you all!!!

Thanks Gail! I appreciate the help. I'll let you know what happens.

Hi Carolyn,

That's interesting. I'll check it out as well.

Thanks.