Re: Security log?

Hi,

SQL Server logs all the data modification commands,and schema change
commands in transaction log file, not in tables
You need 3rd party apps like lumigent log explorer to view the log file.
Using sql profiler you will not be able to find out what the user has done
on the database
but you can find out what the user is doing at the moment.

Regards
VT
Knowledge is power, share it....
http://oneplace4sql.blogspot.com/
<kain.vma@xxxxxxxxx> wrote in message
news:1181655156.902260.39000@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi all!
I'm writing you to ask something about security of sql server 2000.

I want to know if SQL server 2000 logs every kind of command that a
user does (for examlpe a query or an update) and if yes where...I'm
trying to discover what a single user has done on a db.

There is a table that sql server uses for logging this kind of info?
or the only method is to use the sql server profiler?

Thanks!

p.s.: sorry for my english



.

Relevant Pages

  • Re: 3 Simple Security SQL Statements
    ... If you run the SELECT in a query window, it generates the list of commands ... There is procedure called sp_executesql that will take a string and execute ... Kalen Delaney, SQL Server MVP ... Builds a list of text commands. ...
    (microsoft.public.sqlserver.security)
  • Re: newbie problem: updating an access db
    ... modifying the code to use SQL Server it still exhibited the same ... changed the path to the supplied access .mdb file in the web.config ... the delete and update commands, so now they just test whether Adnum= ?. ... get this code to work, I don't want to start modifying it to use MSSQL, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: A desperate plea for help....
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... app in which collects data from a wedge scanner via barcodes. ... I have created the sql connection, data adapter, and data set as ... and DELETE commands with the text strings. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: multiple sql statements in OLE DB command
    ... > when 2 commands are used. ... > OwnerID INTEGER IDENTITY NOT NULL, ... > I used SQL Server Enterprise Manager to get the starting point for the ... The following code works when you exeecute 2 separate ...
    (microsoft.public.access.queries)
  • Re: CmdExec DTS -- Fails
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... which should have permissions to run commands. ...
    (microsoft.public.sqlserver.dts)