Is there a way to see when and who changed a SQL View?
If so how?
Is there a way to see when and who changed a SQL View?
If so how?
you can see when a query was changed by right clicking on a query and selecting properties. But this will not tell you who.
If you want complete control of the process you would need to manage the creation and maintenance of queries through code (i.e. build your own query builder)
When i go to the Properties of a SQL View, I only see created date. Trying to at least find modified dates.
I said
you can see when a query was changed by right clicking on a query and selecting properties. But this will not tell you who.
that is the query object, not the sql contained therein
And I have stated that I'm looking to see if there's a way to view the changes on a SQL View and that I only see created date when I right-click Properties.
Nothing to do with a Query here ...
Ok - well perhaps they have removed some properties in 2013. So since you are referring to the sql view, the answer is no, there is no way to see when and who changed a SQL View.
@aellistechsupport
changed a SQL View?It sounds like you are talking about a View in SQL Server/Express.Nothing to do with a Query here ...
If you mean a View in SQL Server, you are correct - there is only the "Creation Date" available. No "Modified Date" property that I could find.
Hi,
the modification date can easily be found with:
To get more info, you can put a trace in SQL server on the object events object:alteredCode:select create_date, modify_date from sys.views where [name] = 'name of the view'
kind regards
NG