Re: MSSQL 2000 Activity Logs

From: Uri Dimant (urid_at_iscar.co.il)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 13:58:12 +0200

Mario
You can run SQL Server Profile to capture those commands and save it to the
table.

As far as I know with SQL Server 2005 you will be able to define a trigger
on a table or even on a database ( I am not certain) for drop table events.

"Mario Splivalo" <majk@fly.srk.fer.hr> wrote in message
news:slrnc5tjfd.p0k.majk@fly.srk.fer.hr...
> On 2004-03-22, Hari Prasad <hari_prasad_k@hotmail.com> wrote:
> > Hi,
> >
> > I feel that SQL Server wont store any information of that sort by
default.
> >
> > If you keep enabled the profiler then you can see the command DROP
DATABASE
> > , by using that you can identify the user who has dropped it. But old
data
> > can not be retrived.
> >
>
> Yes, when I have the profiler running, then I can see what's going on.
But,
> most of the time, I don't keep the profiler up.
>
> Is there a way to tell SQL server 'do, please, keep logs of who and when
> created/dropped/attached/deatached databases'?
>
> Mike
> --
> "I can do it quick. I can do it cheap. I can do it well. Pick any two."
>
> Mario Splivalo
> msplival@jagor.srce.hr

Relevant Pages

  • Re: Problem altering table and adding a default
    ... SQL Server does not allow that - you can only add nullable ... > After you add a new column in Enterprise Manager, uncheck Allow Nulls, ... the ALTER TABLE statement above will pass to the SQL Server ... > 4) Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)
  • Re: Running profiler on busy 8-cpu Sql Server
    ... with SQL Server. ... Not only does the Profiler GUI's screen need to ... Server & places it on queues that the Profiler GUI picks up. ... / data columns & filters you define in a profiler trace, ...
    (microsoft.public.sqlserver.server)
  • Re: Problem altering table and adding a default
    ... ALTER TABLE dbo.Test_tbl ADD Notnull_col1 charNOT NULL ... SQL Server does not allow that - you can only add nullable columns. ... After you add a new column in Enterprise Manager, uncheck Allow Nulls, bind the uder- ... Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)
  • Re: Encrypt SQL Command to any SQL Server
    ... Just a small addition - if you really need good encryption of your objects, ... Dejan Sarka, SQL Server MVP ... > To add to the other responses, SQL Profiler will hide text that contains ... >> I'm a developer and in my applications I send commands to the SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: stress by profiler ?
    ... Are you running the Profiler on the same machine as SQL Server? ... The response time of DB access is also good. ... -- very low Disk Read ...
    (microsoft.public.sqlserver.server)