I love articles like this. Great job, thank you!

I agree, sort of. In tests on SQL 2005, seems to me the proc call needs to be in TRY/CATCH else control does not flow down to the PRINT...

Thanks, works great!

Maybe you meant this, which jibes with your earlier posts:

If you do not include this, then when the sproc is executed, it's executed with the rights of the user that...

With all due respect, Steve, that just cannot be right. The vast majority of our procs were compiled with no "AS principal", and they are all run by users...

The PS referenced text in earlier 7/1/2009 reply to the original post. That reply is why I

first posted here today, I keep having it quoted to me.

Since I can't...

Thanks for the clarification, Steve. But I want to be sure.... When we don't specify this, and we usually don't, is the default "AS <owner>"?

I've almost...

I think the first part of sanderstad's reply is correct. But "So in other words it grants the user to give other users the same permission" is not, or...

We used certs because we did not want to have to worry about managing passwords in source code, or in config files, etc. By using certs, our development team...

Now I'm confused. You're the one who originally posted this. Are you now able to resolve your problem w/out resorting to DBCC?

Well spoken, good points. I appreciate your input. But I think you're assuming that the cause of the problem is a "bad plan" in the classical sense of that...

I hear you guys, but it seems like you're making recommendations from an ivory tower. Are you speaking from experience with this precise problem? Or just general knowledge?...

I have similar problem, posted in more detail at . We've tried a few different DBCCs like this, and were concerned about negative performance impact of clearing out cache....

I have exactly same issue on a few different servers, all with completely different hardware/configuration/workloads. The only thing they have in common is SQL 2005 sp2 v3042 or sp2+...

Agreed. We have write-cache enabled, similar situation, no problems.