Posted by Erland Sommarskog on 05/03/06 10:35

Dimitri Furman (dfurman@cloud99.net) writes:
> Well, of course this function uses not one but two indexed views...

Ohoh! Then it's essential that ARITHABORT is ON. If it is not, SQL Server
will disregard the view and read from the base tabels.

> If that doesn't work, I think I can create a dummy table, reference it in
> the function, and call sp_recompile on that table prior to calling the
> procedure.

Ouch! That's a kludge!



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Syntax Help!
• Prev in forum: Transactional Replication over the Internet
• Thread view: Re: Stuck execution plan?

[Reply to this message]