Auditing Tool

The department here is looking for a 3rd party auditing tool that can monito
r
the SQL 2000 data base for changed, deleted or added records. One utility
available is Apex SQL
Log that costs about $700.00. Anyone know of this or any other such utility
?
Thanks for everyone being there to help.Hi,
See Logexplorer from www.Lumigent.com
Thanks
Hari
SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:86F241F5-03E4-4491-ACEF-5AC5943628D8@.microsoft.com...
> The department here is looking for a 3rd party auditing tool that can
> monitor
> the SQL 2000 data base for changed, deleted or added records. One utility
> available is Apex SQL
> Log that costs about $700.00. Anyone know of this or any other such
> utility?
> Thanks for everyone being there to help.
>

Auditing Tool

The department here is looking for a 3rd party auditing tool that can monitor
the SQL 2000 data base for changed, deleted or added records. One utility
available is Apex SQL
Log that costs about $700.00. Anyone know of this or any other such utility?
Thanks for everyone being there to help.
Hi,
See Logexplorer from www.Lumigent.com
Thanks
Hari
SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:86F241F5-03E4-4491-ACEF-5AC5943628D8@.microsoft.com...
> The department here is looking for a 3rd party auditing tool that can
> monitor
> the SQL 2000 data base for changed, deleted or added records. One utility
> available is Apex SQL
> Log that costs about $700.00. Anyone know of this or any other such
> utility?
> Thanks for everyone being there to help.
>

Auditing Tool

The department here is looking for a 3rd party auditing tool that can monitor
the SQL 2000 data base for changed, deleted or added records. One utility
available is Apex SQL
Log that costs about $700.00. Anyone know of this or any other such utility?
Thanks for everyone being there to help.Hi,
See Logexplorer from www.Lumigent.com
Thanks
Hari
SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:86F241F5-03E4-4491-ACEF-5AC5943628D8@.microsoft.com...
> The department here is looking for a 3rd party auditing tool that can
> monitor
> the SQL 2000 data base for changed, deleted or added records. One utility
> available is Apex SQL
> Log that costs about $700.00. Anyone know of this or any other such
> utility?
> Thanks for everyone being there to help.
>

Auditing Reports

We have a many reports in many folders. We are now at the point that we need
some kind of tool to audit all these reports for following:
Security
connectionStrings
Data Sources
ReportLocations
I saw in ReportServer database there are all kind of tables which has all of
these information, but I was wondering if there is a solution out there to
query those tables to achive this goal.
Thanks
VipulHi,
Ofcourse you can use those system tables, but with care. each table is
useful for collecting information. Infact the table name are self explanatory
and you can query it for info.
Amarnath
"Vipul Shah" wrote:
> We have a many reports in many folders. We are now at the point that we need
> some kind of tool to audit all these reports for following:
> Security
> connectionStrings
> Data Sources
> ReportLocations
> I saw in ReportServer database there are all kind of tables which has all of
> these information, but I was wondering if there is a solution out there to
> query those tables to achive this goal.
> Thanks
> Vipul
>|||Do you know of any available sample queries to query those tables?
"Amarnath" wrote:
> Hi,
> Ofcourse you can use those system tables, but with care. each table is
> useful for collecting information. Infact the table name are self explanatory
> and you can query it for info.
> Amarnath
>
> "Vipul Shah" wrote:
> > We have a many reports in many folders. We are now at the point that we need
> > some kind of tool to audit all these reports for following:
> > Security
> > connectionStrings
> > Data Sources
> > ReportLocations
> >
> > I saw in ReportServer database there are all kind of tables which has all of
> > these information, but I was wondering if there is a solution out there to
> > query those tables to achive this goal.
> >
> > Thanks
> > Vipul
> >

audit tool

hello, i listen that exists many tools for register all the changes
made to the tables, for audit purpouses, can somebody recommend to me
what options exists... ? exists free option?but english broken kiks
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1133366598.263720.93150@.f14g2000cwb.googlegroups.com...
> hello, i listen that exists many tools for register all the changes
> made to the tables, for audit purpouses, can somebody recommend to me
> what options exists... ? exists free option?
>|||sorry, i don't understand... what i want its a tool that track all the
insert, update, delete made in the tables,... and register them in
other database... this tools exists?|||a tool diferent to sql profiler... more eficient...|||SQL Server does have built-in audit modes (C2 auditing), but I've never
actually turned it on. You might want to read up on that a bit.
I believe Idera's SQL Compliance Manager does this kind of thing, as well.
I'm not aware of any free options.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1133366598.263720.93150@.f14g2000cwb.googlegroups.com...
> hello, i listen that exists many tools for register all the changes
> made to the tables, for audit purpouses, can somebody recommend to me
> what options exists... ? exists free option?
>|||thanks, and sorry for my english... i talk spanish... bye|||De nada.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1133368401.530605.263290@.g43g2000cwa.googlegroups.com...
> thanks, and sorry for my english... i talk spanish... bye
>|||its better idera than log pi? (www.logpi.com)|||That's not really the same kind of tool. LogPI, Log Explorer, and Log
Rescue can't really report on what happened -- they're used by DBAs after
problems occur to try to undo the damage.
What do you really need to do with a tool? Report for compliance purposes
to management, or fix problems?
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1133369158.956440.322830@.g47g2000cwa.googlegroups.com...
> its better idera than log pi? (www.logpi.com)
>|||hongo32 wrote:
> its better idera than log pi? (www.logpi.com)
>
If you're only interested in update, delete, and inserts on user tables
then use triggers to manage the audit trail. However, if you're
interested in schema changes then you cannot create triggers on system
tables and will need to find a different solution.
However, if you're using SQL Server 2005 you can create database
triggers to track these changes for auditing.

audit tool

hello, i listen that exists many tools for register all the changes
made to the tables, for audit purpouses, can somebody recommend to me
what options exists... ? exists free option?
but english broken kiks
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1133366598.263720.93150@.f14g2000cwb.googlegro ups.com...
> hello, i listen that exists many tools for register all the changes
> made to the tables, for audit purpouses, can somebody recommend to me
> what options exists... ? exists free option?
>
|||sorry, i don't understand... what i want its a tool that track all the
insert, update, delete made in the tables,... and register them in
other database... this tools exists?
|||a tool diferent to sql profiler... more eficient...
|||SQL Server does have built-in audit modes (C2 auditing), but I've never
actually turned it on. You might want to read up on that a bit.
I believe Idera's SQL Compliance Manager does this kind of thing, as well.
I'm not aware of any free options.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1133366598.263720.93150@.f14g2000cwb.googlegro ups.com...
> hello, i listen that exists many tools for register all the changes
> made to the tables, for audit purpouses, can somebody recommend to me
> what options exists... ? exists free option?
>
|||thanks, and sorry for my english... i talk spanish... bye
|||De nada.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1133368401.530605.263290@.g43g2000cwa.googlegr oups.com...
> thanks, and sorry for my english... i talk spanish... bye
>
|||its better idera than log pi? (www.logpi.com)
|||That's not really the same kind of tool. LogPI, Log Explorer, and Log
Rescue can't really report on what happened -- they're used by DBAs after
problems occur to try to undo the damage.
What do you really need to do with a tool? Report for compliance purposes
to management, or fix problems?
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1133369158.956440.322830@.g47g2000cwa.googlegr oups.com...
> its better idera than log pi? (www.logpi.com)
>
|||hongo32 wrote:
> its better idera than log pi? (www.logpi.com)
>
If you're only interested in update, delete, and inserts on user tables
then use triggers to manage the audit trail. However, if you're
interested in schema changes then you cannot create triggers on system
tables and will need to find a different solution.
However, if you're using SQL Server 2005 you can create database
triggers to track these changes for auditing.

audit tool

hello, i listen that exists many tools for register all the changes
made to the tables, for audit purpouses, can somebody recommend to me
what options exists... ? exists free option?but english broken kiks
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1133366598.263720.93150@.f14g2000cwb.googlegroups.com...
> hello, i listen that exists many tools for register all the changes
> made to the tables, for audit purpouses, can somebody recommend to me
> what options exists... ? exists free option?
>|||sorry, i don't understand... what i want its a tool that track all the
insert, update, delete made in the tables,... and register them in
other database... this tools exists?|||a tool diferent to sql profiler... more eficient...|||SQL Server does have built-in audit modes (C2 auditing), but I've never
actually turned it on. You might want to read up on that a bit.
I believe Idera's SQL Compliance Manager does this kind of thing, as well.
I'm not aware of any free options.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1133366598.263720.93150@.f14g2000cwb.googlegroups.com...
> hello, i listen that exists many tools for register all the changes
> made to the tables, for audit purpouses, can somebody recommend to me
> what options exists... ? exists free option?
>|||thanks, and sorry for my english... i talk spanish... bye|||De nada.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1133368401.530605.263290@.g43g2000cwa.googlegroups.com...
> thanks, and sorry for my english... i talk spanish... bye
>|||its better idera than log pi? (www.logpi.com)|||That's not really the same kind of tool. LogPI, Log Explorer, and Log
Rescue can't really report on what happened -- they're used by DBAs after
problems occur to try to undo the damage.
What do you really need to do with a tool? Report for compliance purposes
to management, or fix problems?
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1133369158.956440.322830@.g47g2000cwa.googlegroups.com...
> its better idera than log pi? (www.logpi.com)
>|||hongo32 wrote:
> its better idera than log pi? (www.logpi.com)
>
If you're only interested in update, delete, and inserts on user tables
then use triggers to manage the audit trail. However, if you're
interested in schema changes then you cannot create triggers on system
tables and will need to find a different solution.
However, if you're using SQL Server 2005 you can create database
triggers to track these changes for auditing.|||i'm looking for other solutions... because this solution offer better
performance than a trigger... that i want is an audit tool... i ask for
logPI because someone toll me about it... thanks for your commentaries

attaching a database to sql express

I'm trying to attach a database to sql express with the following code from the management tool. I keep getting an error message. An someone explain what I'm doing wrong.

Msg 102, Level 15, State 1, Line 9

Incorrect syntax near '<'.

IF NOT EXISTS(

SELECT *

FROM sys.databases

WHERE name = N'<northwind.mdb, I4V0Y6\SQLEXPRESS, northwind>'

)

CREATE DATABASE <database_name, sysname, your_database_name>

ON PRIMARY (FILENAME = '<c:\my documents\my webs\myweb3,,C:\Program files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\northwind.MDF>')

FOR ATTACH

GO

Ira

You have to substitute the value in the <> signs with your actual values. SO it should evaluate to something like:

CREATE DATABASE Archive
ON (FILENAME = 'C:\Program files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\northwind.MDF')
FOR ATTACH

The BOL has more samples about that.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de