Author: Aaron Bertrand [MVP]Aaron Bertrand [MVP] Date: Nov 15, 2006 15:42
I assume it is in the database you selected in the tuning advisor. One
thing to try may be to edit the workload file and make sure that the object
is referenced using three-part naming database.owner/schema.object
"Otis Bricker" my-dejanews.com> wrote in message
news:Xns987C7CDDB9302obrickermydejanewsco@216.196.97.136...> After capturing some activity into a profile using the SQL2005 Profiler,
> The database Tuning wizard seems to be unable to locate one and only one
> of
> the stored Procedures that was called and gives me an E001 error/warning.
>
> I have tried recreating the SP it still reports it missing. Since it was
> run it is obviously there. It belongs to dbo and is called as such via
> ADO.
>
> Any advice on how to help the Tuning engine see it?
>
> Thanks.
>
> Otis Bricker
| 
