SQL Server Performance

ssrs 2008 sql

Discussion in 'SQL Server 2008 General Developer Questions' started by jassie, Feb 28, 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 at
    sysobjects?
    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. ismailadar New Member

    Hi
    you can use sys.object view in order to find out modify date of an object here is the query:
    SELECT * FROM sys.objects WHERE type IN ('FN', 'IF', 'TF','P','V')
    P means proc v mesan view and others mean functions.

Share This Page