2005 DB Engine Tuning Advisor Error

Hi,
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
NT 5.2 (Build 3790: Service Pack 2)
For many valid table names, the Tuning Advisor gives this error:
[Microsoft][SQL Native Client][SQL Server]Invalid object name '<table_name>'
I am 100% certain that the correct database is selected and that these
tables exist. The same queries that give the error in Tuning Advisor,
return the expected results from a standard query window in the SQL Server
Mgmt tool.
I would greatly appreciate any insight or advice on this matter.
Thanks,
Jim
this kind of error in my practice is thrown if I ecamine something that
creates a temporary teble.
Do you have any temp tables there by any chance?
Thanks, Liliya
|||Thank you for the response, Liliya. There are a very large number of
queries in question. Having reviewed a lot of them, I see no creation of
temporary tables. Perhaps temp table creation is done in a small number of
the queries (which I have not yet reviewed). So, I think that my issue is
not based in temp tables.
"Liliya Huff" <LiliyaHuff@.discussions.microsoft.com> wrote in message
news:66EADD72-05F1-4C61-9830-06FA3B419857@.microsoft.com...
> this kind of error in my practice is thrown if I ecamine something that
> creates a temporary teble.
> Do you have any temp tables there by any chance?
> --
> Thanks, Liliya
>
>

2005 DB Engine Tuning Advisor Error

Hi,
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
NT 5.2 (Build 3790: Service Pack 2)
For many valid table names, the Tuning Advisor gives this error:
[Microsoft][SQL Native Client][SQL Server]Invalid object name '<table_name>'
I am 100% certain that the correct database is selected and that these
tables exist. The same queries that give the error in Tuning Advisor,
return the expected results from a standard query window in the SQL Server
Mgmt tool.
I would greatly appreciate any insight or advice on this matter.
Thanks,
Jimthis kind of error in my practice is thrown if I ecamine something that
creates a temporary teble.
Do you have any temp tables there by any chance?
--
Thanks, Liliya|||Thank you for the response, Liliya. There are a very large number of
queries in question. Having reviewed a lot of them, I see no creation of
temporary tables. Perhaps temp table creation is done in a small number of
the queries (which I have not yet reviewed). So, I think that my issue is
not based in temp tables.
"Liliya Huff" <LiliyaHuff@.discussions.microsoft.com> wrote in message
news:66EADD72-05F1-4C61-9830-06FA3B419857@.microsoft.com...
> this kind of error in my practice is thrown if I ecamine something that
> creates a temporary teble.
> Do you have any temp tables there by any chance?
> --
> Thanks, Liliya
>
>