SQL Server Performance

t-sql when sql is changed

Discussion in 'SQL Server 2008 General Developer Questions' started by jassie, Mar 1, 2011.

  1. jassie New Member

    I would like to know the following:1. What t-sql can I use to see if a stored procedure has changed? I want to see the last modified date? Would I look atsysobjects?2. What t-sql would I use to see if a view and function changed. I would like to see the last modified date? Would I look at
    sysview?


  2. FrankKalis Moderator

    You can have a look at sys.objects (sys.views is basically just a subset of sys.objects). However, the modified_date there is only updated when the objects change via an ALTER statement. If it is dropped and recreated, the create_date will be equal to the modified_date.
  3. satya Moderator

    IF the server is not restarted then simply use SSMS reports by looking at SCHEMA CHANGES report.

Share This Page