Command to check last time stored proc was recompiled
I was asked this question today...what's the command to check the date of the last time a stored proc was recompiled. I thought it was sp_recompile. It's not..
Is there a command?
Is there a command?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Cool. I had tried CROSS APPLY and was getting some error. Forget what it was now. Thought it was a limit of sys.dm_exec_sql_text()
:)
cool bananas... sql 2005 is so much better
ASKER
it's sql 2000 but they use sql2005 management to look at sql2000. They dont use enterprise manager.
i guessed that from your other questions
ASKER
I guess our client needs to clear the cache.