Results 1 to 8 of 8
  1. #1
    aellistechsupport is offline Competent Performer
    Windows 7 32bit Access 2013
    Join Date
    Apr 2014
    Posts
    410

    See when and who changed a SQL View?

    Is there a way to see when and who changed a SQL View?


    If so how?

  2. #2
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    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)

  3. #3
    aellistechsupport is offline Competent Performer
    Windows 7 32bit Access 2013
    Join Date
    Apr 2014
    Posts
    410
    When i go to the Properties of a SQL View, I only see created date. Trying to at least find modified dates.

  4. #4
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    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

  5. #5
    aellistechsupport is offline Competent Performer
    Windows 7 32bit Access 2013
    Join Date
    Apr 2014
    Posts
    410
    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 ...

  6. #6
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    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.

  7. #7
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    @aellistechsupport
    changed a SQL View?
    Nothing to do with a Query here ...
    It sounds like you are talking about a View in SQL Server/Express.

    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.

  8. #8
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi,

    the modification date can easily be found with:

    Code:
      select create_date, modify_date from sys.views where [name] = 'name of the view'
    To get more info, you can put a trace in SQL server on the object events object:altered

    kind regards
    NG

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 03-05-2015, 01:10 PM
  2. Replies: 6
    Last Post: 05-09-2014, 09:03 AM
  3. Replies: 2
    Last Post: 03-09-2014, 03:21 PM
  4. Replies: 8
    Last Post: 04-29-2013, 11:23 AM
  5. Replies: 7
    Last Post: 05-29-2009, 04:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums