Posted by akej via SQLMonster.com on 07/24/05 15:36

Thanks for respone,

>2) Use Profiler.


can u plz explain me how to acomplish it using Profiler???

i'm newb and use for profiler only for checking for sp recompilation and so
on.

Thanks for help.



Erland Sommarskog wrote:
>> 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.
>

--
"Imagination is more important than knolwege" (Albert Einshtein)


Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200507/1

[Back to original message]