October 20, 2006 at 3:51 pm
Microsoft SQL Server 2000
For some reason some of the stored procedures I'm running from my client application (Power Builder) are being handled as Ad-Hoc..
This is an example of what I'm getting from master.dbo.syscacheobjects...
--------------ROW 1-----------------
cacheobjtype : Compiled Plan
objtype : Adhoc
sql :execute dbo.up_OrderToAciSQL;1 @OrderRecordId = 3146092
--------------ROW 2 -----------------
cacheobjtype : Compiled Plan
objtype :Adhoc
sql :execute dbo.up_OrderToAciSQL;1 @OrderRecordId = 3446528
Any Idea how could I correct this?
Thanks
October 23, 2006 at 8:00 am
This was removed by the editor as SPAM
October 26, 2006 at 4:47 am
I think, and it's a long time since I saw this, that the client wraps the proc call into an executable string, sql server then sees this as an ad-hoc query. In real terms if it's being re-used then I doubt its likely to be a problem - if it doesn't get reused then it might need further research.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply