Posted by LaMoRt on 11/22/07 09:29

On Nov 22, 6:13 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> BerndB (be...@fernuni-hagen.de) writes:
> > How about DDL triggers in SQL 2005
>
> With all sorts of triggers you can capture a lot - but only if you plan
> ahead. I understoof the original question as that what shouldn't happen
> had already happened.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


Yes, it is a data that has been updated and i want to track back the
person
who did the transaction. Any way to find it in this kind of situation.
I'm using SQL2000 actually. So anything that can help me for this?

Thanks.

• Next in forum: SQL Server Express 2005 @@SPID
• Prev in forum: Re: sqlcmd and escape characters
• Thread view: Re: Finding the user who do update in Query Analyser?

[Reply to this message]