Why is the LAST_ALTERED datetime column in INFORMATION_SCHEMA.ROUTINES NOT
changing when I perform a ALTER PROCEDURE statement?
When would it change?
tia,
Chris
It's not fully implemented yet in sql2k. Expect to see such audit in sql2k5.
-oj
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:6E5F64BE-3373-4107-99C7-A54D48FA026D@.microsoft.com...
> Why is the LAST_ALTERED datetime column in INFORMATION_SCHEMA.ROUTINES
> NOT
> changing when I perform a ALTER PROCEDURE statement?
> When would it change?
> tia,
> Chris
Friday, March 30, 2012
INFORMATION_SCHEMA.ROUTINES LAST_ALTERED not changing
Labels:
alter,
changing,
column,
database,
datetime,
information_schema,
information_schemaroutines,
last_altered,
microsoft,
mysql,
notchanging,
oracle,
perform,
procedure,
routines,
server,
sql,
statementwhen
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment