Database Engine Tuning Advisor cannot find stored procedures


  • I'm running the Advisor off of a SQL Profiler table and am getting a ton of :

    E000    exec my_sp         1    [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'my_sp'.

    This is happening for multiple sproc's that do indeed exist in the database.  I see them in SSMS connecting via the same login.  All proc's are dbo owned.  I'm connecting via the 'sa' in the Advisor.
    Friday, November 17, 2006 4:08 AM

All replies

  • Would it matter that the trace table includes procs / sql statements run against two different databases?
    Friday, November 17, 2006 5:31 AM