Re: How can I tell if a view has been modified?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: David Gugick (davidg-nospam_at_imceda.com)
Date: 11/10/04 

Date: Wed, 10 Nov 2004 15:52:50 -0500

Aaron [SQL Server MVP] wrote:
> SQL Server doesn't track this information (though it is on the list of
> features being added for SQL Server 2005 -- both a working "modified
> date" column, and the ability to add your own triggers to DDL events).
>
> In the meantime, you will need auditing software, or very specialized
> profiler traces...
> http://www.aspfaq.com/2495
> http://www.microsoft.com/technet/security/prodtech/dbsql/sql2kaud.mspx
>
>
> "Tennis" <Tennis@discussions.microsoft.com> wrote in message
> news:622E237E-490C-4534-AE19-492E594FAE3F@microsoft.com...
>> How can I tell if a view has been modified/updated? This does not
>> mean dropping and recreating, but modifying it through Enterprise
>> Manager. I expected the crdate field in sysobjects to change but it
>> didn't.
>>
>> Thanks
>> --
>> Tennis Player

Or a change manager tool to comare it to a snapshot of the production
database schema. 

-- 
David Gugick
Imceda Software
www.imceda.com

Relevant Pages

  • Re: How can I tell if a view has been modified?
    ... >> Or a change manager tool to comare it to a snapshot of the production ... >> database schema. ... enterprise object store (a SQL Server database that is shared by all IDE ...
    (microsoft.public.sqlserver.server)
  • Re: Table Permissions
    ... As long as he is connected to SQL Server as the same user in both cases, ... SQL Server MVP ... the ability to delete a record is all or ... I'm assuming that its possible to restrict a user to read-only access for ...
    (microsoft.public.sqlserver.security)
  • Req: Senior .Net Software Engineer required
    ... Conduct technical studies and evaluations of business area ... Ability to handle multiple projects, ... Technical Skills: ... and cardinality with a focus on MS SQL Server. ...
    (comp.os.linux.setup)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... hopefully he can expedite processing your full subscription. ... SQL Server MVP ... Columnist, SQL Server Professional ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... hopefully he can expedite processing your full subscription. ... SQL Server MVP ... Columnist, SQL Server Professional ... Please reply to the newsgroup. ...
    (microsoft.public.sqlserver.programming)