Posted by Erland Sommarskog on 07/24/05 11:54

akej via SQLMonster.com (forum@SQLMonster.com) writes:
> Is there way to check what were the last modifys to specified database??
>
> I mean the last insertion, deletion ........... .. and in which tables.

No, there is no built-in support for this. Options to tackle this:

1) Your own autiding code.
2) Use Profiler.
3) Use a third-party product that works from the transaction log,
see www.lumigent.com and www.logpi.com for examples.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Linking SQL Server 2000 to DB2 Connect 8.x
• Prev in forum: Re: How to check the last modifys in database
• Thread view: Re: How to check the last modifys in database

[Reply to this message]