(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!
>
Showing posts with label downloaded. Show all posts
Showing posts with label downloaded. Show all posts
Monday, March 12, 2012
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
> >
> >
>
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!
>
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!
>
Wednesday, March 7, 2012
Need JDBC Driver for MS SQL 7.00.847
Hi
I just downloaded the Microsoft JDBC Driver for SQL Server 2000. Now it tells me SQL Server 7 is not supported. :o I already checked the JDBC Driver list on suns site. Its quite long and only states MS SQL Server without any version number. Can you recommend a particular driver? Preferrably without any cost. :D
Or am I better of with the jdbc/odbc bridge?
Thanks
ShabassaWe have multiple MS Sql Servers. Some are version 2000 (8). Is it possible to connect to such a server via jdbc and access the server with ms sql 7 using this server as a gateway?
I just downloaded the Microsoft JDBC Driver for SQL Server 2000. Now it tells me SQL Server 7 is not supported. :o I already checked the JDBC Driver list on suns site. Its quite long and only states MS SQL Server without any version number. Can you recommend a particular driver? Preferrably without any cost. :D
Or am I better of with the jdbc/odbc bridge?
Thanks
ShabassaWe have multiple MS Sql Servers. Some are version 2000 (8). Is it possible to connect to such a server via jdbc and access the server with ms sql 7 using this server as a gateway?
Subscribe to:
Posts (Atom)