Thanks For reply Lowell. I know we can use sp_ in any database context, but I had to use that function in a select statement(select clause), so this probably won't...

Hi Gail

I can't doubt your words. Thats why despite MSDN saying it, I posted for confirmation again. Thanks for confirming it.

Are there any links which specifically address this topic and...

I dont think you can call a proc from inside a function except extended procs.

So it concludes that there is no simple work around expect if I can find that...

As per my understading when I do a backup and restore of a database, all statistics are restored as it is. So how come updating the stats helped here?

Are the patches that has been applied on prod and staging same?

Grant

I believe DBCC freeproccache (<guid>). will work on 2008 only....

Is it returning same data on both machines? I mean are u using same parameters on both machines?

You may drop and recreate the proc or use the "with recompile" option.

By the way , in Index ScanDensity and Logical fregmentation

, there is some creativity from my side as well 🙂

Sorry, I surely should have mentioned that....

I picked these queries from net from different sources with some modification here and there from my side.

I really dont remember what exactly the...

Thats okay Gail/Dave.....it does happen....

Sure it was a thanks with all my sincerity..Thats my poor writing skills if I appeared sarcastic anywhere 🙂

Thanks for a long followup Gail....

Actually a part of it is happening in REAL and a part of it just came to my mind. Whats real is my application is calling some proc and the...

Dave/Gail, whetever you guys said is true. SQL Server doesn't record history of tranactions and in second session i can only see the last statementran by 1st sesson.

But what surprises...