Index tuning advisor errors. cannot find stored procedure

Question

Index tuning advisor errors. cannot find stored procedure

AKP

SSCommitted

Points: 1753
More actions
September 30, 2010 at 8:32 am

#224572

Hi GUys,
I am getting following errors while working with DTA.
E000 [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure . In trace file, there is no login column and am running the DTA with sql login having db_owner/Showplan permissions to target database. Also have select permission to MSDB database.
When I checked to database the stored proc is there.
Plz help me out.
Thanks
AKP

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398679 More actions · Answer 1

It sounds like the DTA is not connecting to the right database. That would explain why it's getting that error.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

AKP SSCommitted Points: 1753 More actions · Answer 2

I set the database to right one. Still that error comes.

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 3

@AKP

Can you post exact error ?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

AKP SSCommitted Points: 1753 More actions · Answer 4

Here is the exact error message:

E000exec Test_SP @Test_SYSID=93,@Test_SALE_SYSID=NULL,@Test_SALE_YEAR=NULL,@CODE=NULL,@DESCRIPTION=NULL 1[Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'Test_SP'.

I have more than 50 messages like this for different store procedures.

Thanks

AKP

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 5

AKP (10/4/2010)
Could not find stored procedure 'Test_SP'.

Are you sure these SP exist?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Grant Fritchey SSC Guru Points: 398679 More actions · Answer 6

I'm still of the opinion that you are either not connecting to the correct database, or your security doesn't allow you to see those procs. It's also possible that they're not there. It has to be one of these things. It just has to be.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

@SQLFRNDZ SSCrazy Eights Points: 9095 More actions · Answer 7

you told you can see in database you told right.

So why don't you just open it as script as and right click on query analyzer and select tune with DTA.

Simple!

[font="Tahoma"]
--SQLFRNDZ[/url]
[/font]