Need recommendation on simple auditing product.

(SQL Server 2000, SP3a)
Hello all!
A while ago (2 years?) I downloaded a freeware auditing utility called SQLLog:
http://www.rlpsoftware.com/SQLLog.asp
It doesn't appear as if the freeware version is available from this site any more, so I
was hoping to solicit some opinions on a similar utility that would help audit database
deletions.
That old SQLLog utility basically put triggers on the desired tables, and squirted XML
into a blob field that would enumerate the fields and their original contents and any
changed data. It was pretty straightforward and simple to integrate with an existing
database.
If anyone knows of anything that might be applicable, I'd sure be grateful!
John Peterson
I've used SQLAudit and it works well. It basically places triggers on the
tables for you.
SQLAudit
http://www.redmatrix.com/default.asp?section=sqlaudit
I've heard good reports on Lumigent Entegra, but I haven't evaluated that
yet - it's on my to-do list!
http://www.lumigent.com/products/entegra/entegra.htm
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23gxhuLLKEHA.2456@.TK2MSFTNGP12.phx.gbl...
> (SQL Server 2000, SP3a)
> Hello all!
> A while ago (2 years?) I downloaded a freeware auditing utility called
SQLLog:
> http://www.rlpsoftware.com/SQLLog.asp
> It doesn't appear as if the freeware version is available from this site
any more, so I
> was hoping to solicit some opinions on a similar utility that would help
audit database
> deletions.
> That old SQLLog utility basically put triggers on the desired tables, and
squirted XML
> into a blob field that would enumerate the fields and their original
contents and any
> changed data. It was pretty straightforward and simple to integrate with
an existing
> database.
> If anyone knows of anything that might be applicable, I'd sure be
grateful!
> John Peterson
>
|||Thanks for the reply, Mark! I was checking out ApexSQL Log as well -- so this will be
nice to be able to compare/contrast. I see that Apex's solutions work by reading the
transaction log -- so no additional triggers need be in place. That seems like a pretty
clean solution.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:urpHFLQKEHA.1264@.TK2MSFTNGP12.phx.gbl...
> I've used SQLAudit and it works well. It basically places triggers on the
> tables for you.
> SQLAudit
> http://www.redmatrix.com/default.asp?section=sqlaudit
> I've heard good reports on Lumigent Entegra, but I haven't evaluated that
> yet - it's on my to-do list!
> http://www.lumigent.com/products/entegra/entegra.htm
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
>
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:%23gxhuLLKEHA.2456@.TK2MSFTNGP12.phx.gbl...
> SQLLog:
> any more, so I
> audit database
> squirted XML
> contents and any
> an existing
> grateful!
>

Need recommendation on simple auditing product.

(SQL Server 2000, SP3a)
Hello all!
A while ago (2 years?) I downloaded a freeware auditing utility called SQLLog:
http://www.rlpsoftware.com/SQLLog.asp
It doesn't appear as if the freeware version is available from this site any more, so I
was hoping to solicit some opinions on a similar utility that would help audit database
deletions.
That old SQLLog utility basically put triggers on the desired tables, and squirted XML
into a blob field that would enumerate the fields and their original contents and any
changed data. It was pretty straightforward and simple to integrate with an existing
database.
If anyone knows of anything that might be applicable, I'd sure be grateful!
John PetersonI've used SQLAudit and it works well. It basically places triggers on the
tables for you.
SQLAudit
http://www.redmatrix.com/default.asp?section=sqlaudit
I've heard good reports on Lumigent Entegra, but I haven't evaluated that
yet - it's on my to-do list!
http://www.lumigent.com/products/entegra/entegra.htm
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23gxhuLLKEHA.2456@.TK2MSFTNGP12.phx.gbl...
> (SQL Server 2000, SP3a)
> Hello all!
> A while ago (2 years?) I downloaded a freeware auditing utility called
SQLLog:
> http://www.rlpsoftware.com/SQLLog.asp
> It doesn't appear as if the freeware version is available from this site
any more, so I
> was hoping to solicit some opinions on a similar utility that would help
audit database
> deletions.
> That old SQLLog utility basically put triggers on the desired tables, and
squirted XML
> into a blob field that would enumerate the fields and their original
contents and any
> changed data. It was pretty straightforward and simple to integrate with
an existing
> database.
> If anyone knows of anything that might be applicable, I'd sure be
grateful!
> John Peterson
>|||Thanks for the reply, Mark! I was checking out ApexSQL Log as well -- so this will be
nice to be able to compare/contrast. I see that Apex's solutions work by reading the
transaction log -- so no additional triggers need be in place. That seems like a pretty
clean solution.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:urpHFLQKEHA.1264@.TK2MSFTNGP12.phx.gbl...
> I've used SQLAudit and it works well. It basically places triggers on the
> tables for you.
> SQLAudit
> http://www.redmatrix.com/default.asp?section=sqlaudit
> I've heard good reports on Lumigent Entegra, but I haven't evaluated that
> yet - it's on my to-do list!
> http://www.lumigent.com/products/entegra/entegra.htm
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
>
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:%23gxhuLLKEHA.2456@.TK2MSFTNGP12.phx.gbl...
> > (SQL Server 2000, SP3a)
> >
> > Hello all!
> >
> > A while ago (2 years?) I downloaded a freeware auditing utility called
> SQLLog:
> >
> > http://www.rlpsoftware.com/SQLLog.asp
> >
> > It doesn't appear as if the freeware version is available from this site
> any more, so I
> > was hoping to solicit some opinions on a similar utility that would help
> audit database
> > deletions.
> >
> > That old SQLLog utility basically put triggers on the desired tables, and
> squirted XML
> > into a blob field that would enumerate the fields and their original
> contents and any
> > changed data. It was pretty straightforward and simple to integrate with
> an existing
> > database.
> >
> > If anyone knows of anything that might be applicable, I'd sure be
> grateful!
> >
> > John Peterson
> >
> >
>

Need recommendation on simple auditing product.

(SQL Server 2000, SP3a)
Hello all!
A while ago (2 years?) I downloaded a freeware auditing utility called SQLLo
g:
http://www.rlpsoftware.com/SQLLog.asp
It doesn't appear as if the freeware version is available from this site any
more, so I
was hoping to solicit some opinions on a similar utility that would help aud
it database
deletions.
That old SQLLog utility basically put triggers on the desired tables, and sq
uirted XML
into a blob field that would enumerate the fields and their original content
s and any
changed data. It was pretty straightforward and simple to integrate with an
existing
database.
If anyone knows of anything that might be applicable, I'd sure be grateful!
John PetersonI've used SQLAudit and it works well. It basically places triggers on the
tables for you.
SQLAudit
http://www.redmatrix.com/default.asp?section=sqlaudit
I've heard good reports on Lumigent Entegra, but I haven't evaluated that
yet - it's on my to-do list!
http://www.lumigent.com/products/entegra/entegra.htm
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23gxhuLLKEHA.2456@.TK2MSFTNGP12.phx.gbl...
> (SQL Server 2000, SP3a)
> Hello all!
> A while ago (2 years?) I downloaded a freeware auditing utility called
SQLLog:
> http://www.rlpsoftware.com/SQLLog.asp
> It doesn't appear as if the freeware version is available from this site
any more, so I
> was hoping to solicit some opinions on a similar utility that would help
audit database
> deletions.
> That old SQLLog utility basically put triggers on the desired tables, and
squirted XML
> into a blob field that would enumerate the fields and their original
contents and any
> changed data. It was pretty straightforward and simple to integrate with
an existing
> database.
> If anyone knows of anything that might be applicable, I'd sure be
grateful!
> John Peterson
>|||Thanks for the reply, Mark! I was checking out ApexSQL Log as well -- so th
is will be
nice to be able to compare/contrast. I see that Apex's solutions work by re
ading the
transaction log -- so no additional triggers need be in place. That seems l
ike a pretty
clean solution.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:urpHFLQKEHA.1264@.TK2MSFTNGP12.phx.gbl...
> I've used SQLAudit and it works well. It basically places triggers on the
> tables for you.
> SQLAudit
> http://www.redmatrix.com/default.asp?section=sqlaudit
> I've heard good reports on Lumigent Entegra, but I haven't evaluated that
> yet - it's on my to-do list!
> http://www.lumigent.com/products/entegra/entegra.htm
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
>
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:%23gxhuLLKEHA.2456@.TK2MSFTNGP12.phx.gbl...
> SQLLog:
> any more, so I
> audit database
> squirted XML
> contents and any
> an existing
> grateful!
>

need me one them database thingies

my boss said i need to put all of my spreadsheets into a database.

is this hard?

do databases have an import utility or am I going to have to retype everything?

Is SQL harder than Excel or is it just about the same thing only fancier?

Do you forsee any problems with this approach?the only problem i foresee is that you're in the wrong forum

you want to be looking at Access, not SQL Server

other than that, it's a cakewalk|||i have to admit something kind sir. this is really homework for my 400 level systems srchitecture class this semester.

would you happen to have one of these ERD thingies and a complete project plan I can hand in on Monday. I was supposed to start on this in August, but me and the frat brothers have just been drinking every night and seducing frshmen girls. Been busy.|||Tell your boss that this is unnecessary. Excel is an excellent database itself, and more flexible since it does not impose any "rules" or "constraints" on the data. He'll see the sense in this, I'm sure. ;)|||ah a slow day troll

Maybe Lotus1-2-3|||You guys know that somebody is bound to take you seriously, and might even try to make sense of this drivel.

-PatP|||Well, an ERD (or Entity relationship Diagram) just shows how entities relate to each other. This is really just a family tree kind of concept. Google around for a copy of Thomas Jefferson's family tree, and use that for your assignment. As for the project plan, hardly anyone uses those in the "real world" it seems. it is unlikely that your professor has actually seen one outside of an academic setting. The one thing you need to know about making a project plan is that all project plans have one thing in common. A PowerPoint presentation. This one has been popular for some time, and should get you the grade you deserve in this class:

http://norvig.com/Gettysburg/sld001.htm|||So does that mean that ERDs are inherantly more complex in Kentucky?

If I build a project plan with only one step, failure, is that complete or is a prelimnary step required in a project plan?

Sooo many decisions! Now I see why those data guys get paid so much.

-PatP|||Easy... Print off your spreadsheets on to paper and file them away in your filing cabinet. That's just and old skool database, isn't it! You'll probably get high marks for research and originality for that one.|||You guys know that somebody is bound to take you seriously, and might even try to make sense of this drivel.

-PatP

don't be a hater, people are trying to help!

;)|||So does that mean that ERDs are inherantly more complex in Kentucky?

bwahahahaha|||Hmm...did someone in here just get a second monitor?

http://www.dilbert.com/comics/dilbert/archive/dilbert-20071016.html