Author |
Topic |
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-05-31 : 13:31:43
|
Hi GurusI have a request from client which want to check when the last update or deletion was made.Can we read the log files in someway?Please helpRegardsNitin |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-31 : 13:40:01
|
Yes, but you need to purchase a third party tool to do it. I know of two such tools. One is made by Lumigent and the other by Red Gate Software. Go to their web sites to check them out. I believe the tools are under 500 bucks each.Tara Kizeraka tduggan |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-05-31 : 13:54:45
|
Tarai understand this third party tool.i searched for dbcc log in the books online.i am running DBCC log (dbname,type=3)but the output is too confusing.Have you seen this dbcc log?RegardsNitin |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-31 : 13:56:48
|
Yes I have, but I am unable to decipher it.Tara Kizeraka tduggan |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-05-31 : 14:01:02
|
hmmmmm....same here...Anywayz thanks TaraActually some data was updated by my client.Nowhe wants to check when this data was updatedand wants me to read the log fileRegards |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-31 : 21:02:14
|
also, you can only read the log file if it hasn't been truncated yet, it's in full recovery model and you haven't backed it up yet--------------------keeping it simple... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-31 : 22:54:38
|
I thought with these 3rd party tools you could read transaction log backups too. Is that not the case?Tara Kizeraka tduggan |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-06-01 : 08:58:27
|
quote: Originally posted by nitin1353 Hi GurusI have a request from client which want to check when the last update or deletion was made.
From your post, I think you just want to view the last (latest) update then, correct me if I'm wrong but I think you are using 2005? If that's the case then you can use the Output clause to copy the rows affected by the the user's action (delete, update or insert) to another table then just read the changes from that table.This is only for 2005RegardsNThe revolution won't be televised! |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-06-01 : 19:25:27
|
Hi how can i used Output clause to copy the rows affected by the the user's action to another table?i could nt get it?Regards |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-01 : 19:29:14
|
quote: Originally posted by nitin1353 Hi how can i used Output clause to copy the rows affected by the the user's action to another table?i could nt get it?Regards
Are you not familiar with Google or other Internet searching sites? I typed in "output clause SQL Server 2005" and found this as the first link:http://blogs.msdn.com/sqltips/archive/2005/06/13/OUTPUT_clause.aspxTara Kizeraka tduggan |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-06-01 : 19:59:14
|
Tarai got ur point.Actually i know about the output clause but i couldnt get what norwich was exactly saying.Thanks for making me understandThanks for the link anywayzRegardsNitin |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-01 : 22:10:52
|
wow, output is cool...however in your case you will need a log reader since output is an audit trail 'object' similar to triggersjust download apexsql, it's free upto certain features, if you need more than the basic, then you need to purchase it--------------------keeping it simple... |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-06-02 : 07:46:36
|
quote: Originally posted by jen wow, output is cool...however in your case you will need a log reader since output is an audit trail 'object' similar to triggers
I got the impression that he's looking for something to use as an audit trail. quote: ]Originally posted by nitin1353Hi GurusI have a request from client which want to check when the last update or deletion was made.
Output should will work fine for this.The revolution won't be televised! |
|
|
|