Identifying the Logs

Hi All,
We almost have 30 developers in our project and we do have
admin user rights for a username and that is being given to all the the
users,
My issue is somebody deletes one object [ tables, SP]
How will i track it down [ who has deleted it], is there anything that
i will be able to find in the logs.
thanks in advance
thomsonHi,
From logs u can identify all the activities that happend to the database. U
can use the third party tool like 'Lumigent log explorer', which i think is
the best tool for dealing with the logs.
Regards Lara
"thomson" <saintthomson@.yahoo.com> wrote in message
news:1129615680.263276.53610@.o13g2000cwo.googlegroups.com...
> Hi All,
> We almost have 30 developers in our project and we do have
> admin user rights for a username and that is being given to all the the
> users,
> My issue is somebody deletes one object [ tables, SP]
> How will i track it down [ who has deleted it], is there anything that
> i will be able to find in the logs.
>
> thanks in advance
> thomson
>|||Hi,
Thanks for the information Do we have any open source tool to
manipulate these things.
Regards
thomson
Aneesh R wrote:
> Hi,
> From logs u can identify all the activities that happend to the database.
U
> can use the third party tool like 'Lumigent log explorer', which i think i
s
> the best tool for dealing with the logs.
> Regards Lara
>
> "thomson" <saintthomson@.yahoo.com> wrote in message
> news:1129615680.263276.53610@.o13g2000cwo.googlegroups.com...|||If all 30 people use that single user-name that has admin privs, then you
will not know who did what. The best thing is to restrict the permissions
and hand out accounts carefully.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"thomson" <saintthomson@.yahoo.com> wrote in message
news:1129615680.263276.53610@.o13g2000cwo.googlegroups.com...
> Hi All,
> We almost have 30 developers in our project and we do have
> admin user rights for a username and that is being given to all the the
> users,
> My issue is somebody deletes one object [ tables, SP]
> How will i track it down [ who has deleted it], is there anything that
> i will be able to find in the logs.
>
> thanks in advance
> thomson
>|||Hi
No, only expensive commercial tools.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"thomson" <saintthomson@.yahoo.com> wrote in message
news:1129618925.118960.27150@.g49g2000cwa.googlegroups.com...
> Hi,
> Thanks for the information Do we have any open source tool to
> manipulate these things.
>
> Regards
> thomson
>
> Aneesh R wrote:
>