Log Reading.. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Log Reading..

Author

Topic

Arijit
Starting Member

25 Posts

Posted - 2006-01-02 : 04:43:33

Hi All,
I have a query regarding reading SQL Log.
Suppose I have a table called TabSample1.
Whenever I am updating any data in TabSample1
that new record should be logged in the Log file
as well as the previous data should also exist in log .
But I want to see the both records from the Log file.
Is there any way to expore this from SQL Server end.
Thanks
Arijit

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2006-01-02 : 05:42:43

There are lots of tools available in market like Lumigent- LOG EXPLORER. They help you to read log files.

Regards
Sachin

Don't sit back because of failure. It will come back to check if you still available. -- Binu

Frank Kalis
Constraint Violating Yak Guru

413 Posts

Posted - 2006-01-02 : 05:44:56

...however, if you like it a bit more cryptic, you can use the undocumented DBCC LOG command.

--
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt? http://www.insidesql.de/blogs

Arijit
Starting Member

25 Posts

Posted - 2006-01-02 : 05:47:56

Thanks Sachin,
Is there any axact way to read the log from query analyzer end?
Because I need to read the data from query analyzer and on that basis it should be stored in some other table.. Can you please put some lights on this..?
Regards
Arijit

Frank Kalis
Constraint Violating Yak Guru

413 Posts

Posted - 2006-01-02 : 05:49:32

Sounds like you should investigate triggers and the inserted and deleted pseudotables in BOL.

--
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt? http://www.insidesql.de/blogs

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2006-01-02 : 05:55:24

Yes trigger can help u in this. Set a trigger in Delete event and everytime a delete command is executed it will record the details on a User defined table lets say "Action_Log". Then you can check this tables for details.

Regards
Sachin

Don't sit back because of failure. It will come back to check if you still available. -- Binu

Arijit
Starting Member

25 Posts

Posted - 2006-01-02 : 06:01:33

Hi Frank,
I don't find any command called "DBCC LOG" in sql server 2000 help.
Can you plzz mention some hints..
Regards
Arijit

Frank Kalis
Constraint Violating Yak Guru

413 Posts

Posted - 2006-01-02 : 06:17:08

I think, I've mentioned that it's undocumented. Therefore you cannot find it in BOL. However, if you google, you'll find plenty of useful links.

--
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt? http://www.insidesql.de/blogs

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2006-01-02 : 06:19:15

Arjit,

This is one of the command which is not documented by Microsoft.

Check the link below for more details.

http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.asp

Regards
Sachin

Don't sit back because of failure. It will come back to check if you still available. -- Binu

Arijit
Starting Member

25 Posts

Posted - 2006-01-02 : 06:34:30

Thanks Everyone,
I am really greatful for your help.
Regards
Arijit

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources