August 21, 2013 at 8:04 am
I would like to get info database objects like procedure ,views, table valued functions modified by info across all databases on a server.
Is there any sys table or catalog view get to "modify by" information ?
I don't like to use DDL trigger on db and DDL on aLL server don't provide such info in its events.
August 21, 2013 at 8:09 am
There is the default trace, which gives some information, but if you are looking for some storage history of who modified which objects, this isn't really tracked by SQL Server.
August 21, 2013 at 8:17 am
Can you please elaborate this default trace.
August 21, 2013 at 8:21 am
It's too much for me to write about. Basically a trace that's running and rolling over all the time. You can search for more info and read about it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply