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 table data changes

Hi,

Is there any RDBMS concept ,If i do any DML operations in any of table i need to know how many rows are inserted/updated/deleted in particular table. I dont want write any trigger to get those information.

because the table count nearly 142.

Moving to Transact-SQL from SSIS.|||

Nope. Triggers are the only current method in 2005 and earlier.

You could pretty easily write a code generator using the system tables (sys.tables, sys.columns) once you determine how to do one of them, then just follow a common pattern.

|||

Yes..My last question. i have done work around solution.

just loading data into table using bulk insert concept. after that used substring function to fixed the problem.

Thanks - Phil Brammer.

Audit a Table

Hello,
How do I audit who is changing data in a table ? SQL 2000
We have a table and records keep getting deleted ...........
in a User Database.
Thanks
MaTTMatt,
you could create triggers which write these details to an audit table if you
want to do this continuously, or as a temporary measure you could run a tool
called Profiler and monitor the TSQL and Stored Procedure events.
Regards,
Paul Ibison|||Also there is a tool from Lumigent which will do what you wish...
www.lumigent.com
I think there may be a second vendor which can do this as well, but I don't
remember the name...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"matt" <matt.smith@.jacobsonco.com> wrote in message
news:eNkbMxsLEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> How do I audit who is changing data in a table ? SQL 2000
> We have a table and records keep getting deleted ...........
> in a User Database.
> Thanks
> MaTT
>

Attaching Database without ldf file?

Hi all,
I have deleted the .ldf file now i am having only the .mdf file. Is it possible to attach the database without shutdown the sql server.
Thanks.

you can make use of this,

sp_attach_single_file_db [ @.dbname= ] 'dbname' , [ @.physname= ] 'physical_name'but its not possible for multiple data files.....your db will not be accessible if ldf is deleted so you need to attach as said above and a new ldf file willbe created.........|||I tried this solution but i am getting error.

File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL\data\details_Log.LDF" may be incorrect.
The log cannot be rebuilt because the database was not cleanly shut down

I want to attch the database without restarting the sql server.

Thanks.|||

this article can help, if you can reading on russian language

http://www.sql.ru/faq/faq_topic.aspx?fid=123

|||

Have you bothered to look at the post ONLY 2 posts below yours?

It provides the solution you seek.

|||I didnt get the solution. I dont know Russian language.
|||

sp_attach_single_file_db this sp has lot of limitaiton. IF you have properly detached then only you can attachy the db using this System sp.And also it will not work if the db have multiple LOG files. i

You follow these step and see

(a) create a database with the same name in another directory as the one you're trying to attach
(b) re-create all filesgroups and files as necessary
(c) shutdown the server
(d) swap in the old mdf file and any ndf files
(e) bring up the server and let the database attempt to be recovered and then go into suspect mode
(f) put the database in single_user and emergency modes
(g) run DBCC CHECKDB (dbname, REPAIR_ALLOW_DATA_LOSS) which will rebuild the log and run full repair
(h) return database to online, multi_user mode

Madhu

And ofcourse you must get back and tell us whether this solved the prob.

|||Thanks Madhu. This is working fine. But i want to attach without shutdown or restarting the sql server thats very important.|||

its good to know that it solved the problem. if the issue is with restarting the server, then you can do all the steps in a standby server (which you can restart ) and once the database is only take the bakcup and restore it in the orginal server

Madhu

Attaching a Database

Hi Friends
Can i attach a database without having its LOG file. Unfortunately all LOG
backups and original log files are deleted from the server. I've the MDF file
only.
Kindly guide me.
Amit
Check out sp_attach_single_file_db in the BOL.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Amit-SQL-DBA" <AmitSQLDBA@.discussions.microsoft.com> wrote in message
news:4281944D-1714-4A69-8664-BFFACEC4649B@.microsoft.com...
Hi Friends
Can i attach a database without having its LOG file. Unfortunately all LOG
backups and original log files are deleted from the server. I've the MDF
file
only.
Kindly guide me.
Amit
|||Try Tom's suggestion first but if that doesn't work you can have a look
here:
http://www.sqlservercentral.com/scri...p?scriptid=599
Andrew J. Kelly SQL MVP
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23%23J1x%23$7EHA.3708@.TK2MSFTNGP14.phx.gbl.. .
> Check out sp_attach_single_file_db in the BOL.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> "Amit-SQL-DBA" <AmitSQLDBA@.discussions.microsoft.com> wrote in message
> news:4281944D-1714-4A69-8664-BFFACEC4649B@.microsoft.com...
> Hi Friends
> Can i attach a database without having its LOG file. Unfortunately all LOG
> backups and original log files are deleted from the server. I've the MDF
> file
> only.
> Kindly guide me.
> Amit
>

Attaching a Database

Hi Friends
Can i attach a database without having its LOG file. Unfortunately all LOG
backups and original log files are deleted from the server. I've the MDF fil
e
only.
Kindly guide me.
AmitCheck out sp_attach_single_file_db in the BOL.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Amit-SQL-DBA" <AmitSQLDBA@.discussions.microsoft.com> wrote in message
news:4281944D-1714-4A69-8664-BFFACEC4649B@.microsoft.com...
Hi Friends
Can i attach a database without having its LOG file. Unfortunately all LOG
backups and original log files are deleted from the server. I've the MDF
file
only.
Kindly guide me.
Amit|||Try Tom's suggestion first but if that doesn't work you can have a look
here:
http://www.sqlservercentral.com/scr...sp?scriptid=599
Andrew J. Kelly SQL MVP
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23%23J1x%23$7EHA.3708@.TK2MSFTNGP14.phx.gbl...
> Check out sp_attach_single_file_db in the BOL.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> "Amit-SQL-DBA" <AmitSQLDBA@.discussions.microsoft.com> wrote in message
> news:4281944D-1714-4A69-8664-BFFACEC4649B@.microsoft.com...
> Hi Friends
> Can i attach a database without having its LOG file. Unfortunately all LOG
> backups and original log files are deleted from the server. I've the MDF
> file
> only.
> Kindly guide me.
> Amit
>

Attaching a Database

Hi Friends
Can i attach a database without having its LOG file. Unfortunately all LOG
backups and original log files are deleted from the server. I've the MDF file
only.
Kindly guide me.
AmitCheck out sp_attach_single_file_db in the BOL.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Amit-SQL-DBA" <AmitSQLDBA@.discussions.microsoft.com> wrote in message
news:4281944D-1714-4A69-8664-BFFACEC4649B@.microsoft.com...
Hi Friends
Can i attach a database without having its LOG file. Unfortunately all LOG
backups and original log files are deleted from the server. I've the MDF
file
only.
Kindly guide me.
Amit|||Try Tom's suggestion first but if that doesn't work you can have a look
here:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
--
Andrew J. Kelly SQL MVP
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23%23J1x%23$7EHA.3708@.TK2MSFTNGP14.phx.gbl...
> Check out sp_attach_single_file_db in the BOL.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> "Amit-SQL-DBA" <AmitSQLDBA@.discussions.microsoft.com> wrote in message
> news:4281944D-1714-4A69-8664-BFFACEC4649B@.microsoft.com...
> Hi Friends
> Can i attach a database without having its LOG file. Unfortunately all LOG
> backups and original log files are deleted from the server. I've the MDF
> file
> only.
> Kindly guide me.
> Amit
>