how to find object modified date

17 Aug 2006 1:43 PM

FARRUKH

today when I come to work, I noticed someone had modified and deleted few
columns n a table.
Is there any way I can find out when and who modified and deleted columns?
is there any scripts i can run?

thanks

Farrukh

17 Aug 2006 2:01 PM

Tibor Karaszi

What version of SQL Server?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"FARRUKH" <farrscorpi***@hotmail.com> wrote in message
news:DD53ED9A-0375-40FA-A585-889EBE7429F4@microsoft.com...
> today when I come to work, I noticed someone had modified and deleted few
> columns n a table.
> Is there any way I can find out when and who modified and deleted columns?
> is there any scripts i can run?
>
> thanks
>
> Farrukh

17 Aug 2006 2:16 PM

FARRUKH

I am using SQL Server 2000

Show quote

"Tibor Karaszi" wrote:

> What version of SQL Server?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "FARRUKH" <farrscorpi***@hotmail.com> wrote in message
> news:DD53ED9A-0375-40FA-A585-889EBE7429F4@microsoft.com...
> > today when I come to work, I noticed someone had modified and deleted few
> > columns n a table.
> > Is there any way I can find out when and who modified and deleted columns?
> > is there any scripts i can run?
> >
> > thanks
> >
> > Farrukh
>
>

17 Aug 2006 5:28 PM

Tibor Karaszi

SQL Server 2000 doesn't store modified date of an object structure. You would have to have had a
profiler trace running while the modification was performed to see when and who did it.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"FARRUKH" <farrscorpi***@hotmail.com> wrote in message
news:628A127C-1FD2-494B-B4CD-5B5E7B6C4B93@microsoft.com...
>I am using SQL Server 2000
>
> "Tibor Karaszi" wrote:
>
>> What version of SQL Server?
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>>
>> "FARRUKH" <farrscorpi***@hotmail.com> wrote in message
>> news:DD53ED9A-0375-40FA-A585-889EBE7429F4@microsoft.com...
>> > today when I come to work, I noticed someone had modified and deleted few
>> > columns n a table.
>> > Is there any way I can find out when and who modified and deleted columns?
>> > is there any scripts i can run?
>> >
>> > thanks
>> >
>> > Farrukh
>>
>>