Posted by Erland Sommarskog on 01/14/06 00:41

serge (sergea@nospam.ehmail.com) writes:
> Anyhow there's a single place where if i add dbo. in front
> of the table this function which is being called from an SP,
> when i run the SP from the QA or from the ASP application
> it runs forever. As soon as i remove the dbo. again it runs
> in 6-8 seconds. Here's the thing this same table reference exists
> a few lines below in the 2nd UNION for example and
> having a dbo. in front doesn't cause any problems.

I assume that we can rule out that there are two tables with different
owners, and you are logged in as that owner when you try this? Of course,
since:

> Even more confusing if i add Databasename.dbo.TableName
> and run it again, i don't run into any problem.

it's not very likely at all.

But I'm afraid I don't have very many ideas. Did you study the query
plan to see if they were identical in both cases?

--
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

[Back to original message]