Any body knows how to retrieve a specific record's histories from SQL data base?

Question

SQL Experts Please answer! I want to retrieve a specific record's transaction histories from a table in SQL data base in C# or VB Please!? I don't want to write a transaction log code for each transaction. I think that it should be possible to get such a data from backup log file or so. Please if you think that there is such a way advice me. Or if there is a resource that may help!
Thanks!
R.K.Shandiz

Answer 1

You won't be able to access the contents of the log files because those files are designed to be machine readable and are not designed for querying.



The normal solution in this situation is to log the transactions. This could be at a code level through insert statements or triggers on the tables that track the changes and then create entries in a log table

Answer 2

Have you made any stored procedures that you can call in your code? Here is an example in classic ASP in VBScript.



If Act = "add" Then

sSQL = "lg_JewelryCategoriesAdd "

Button = "Add"

ElseIf Act = "update" Then

sSQL = "lg_JewelryCategoriesUpdate " &_

"@jewelercategoriesid=" & sq(ID) & ","

Button = "Update"

End If



The sSQL is the stored procedure that does the function. The @ is the column that it looks at. The ID is the variable being used. Here is what the stored procedure looks like.



CREATE PROCEDURE [dbo].lg_JewelryCategoriesUpdate

@jewelercategoriesid INT

, @description VARCHAR(50)

, @system BIT

AS

UPDATE lg_JewelerCategories SET

[description]=@description

, [system]=@system

WHERE

jewelercategoriesid=@jewelercategoriesid

GO



Let me know if you need anymore help.

Answer 3

In an outstanding way the "loss of sense of Humour" would be led to by applying loss of sturdy solar in the eyes. Serotonin ranges would be better by applying better exposure to easy, in accordance to Greg Danzig, president of lonair Co. "easy and antidepressants like Prozac help. yet researchers say unfavourable ions would additionally advance innovations ranges of serotonin." it many times happens during the iciness. A much less ordinary style of unhappy ("Seasonal Affective disease" additionally talked approximately as: Seasonal melancholy, Seasonal temper disease) happens in the summertime. nutrients for the temper is the guideline, consume extra end result and vegetables and much less fat and candies to stabilize moodiness, in accordance to scrumptious online, an internet magazine. Magnesium, nutrition B6, nutrition C, and folic acid are ingredients you additionally can choose to contemplate . severe intake of alcohol, caffeine and nicotine and further stress, additionally are discouraged while you're plagued by applying the wintertime melancholy. on an well-known basis walks or workout exercises are inspired. that's yet one among quite a few reasons... did you already know that the united statesD.A.'s "cautioned nutritional Allowance" for supplements and minerals substitute into to maintain you from getting Scurvy and had not something to do with keeping solid well-being? did you already know which you would be able to not proceed to exist on processed ingredients and not applying a multi-nutrition at present through fact the soil is so depleated. did you already know that if the supplements at the instant are not water soluible the physique can not use them, and maximum at the instant are not? ME! Mahatma Gamdhi as you already know, walked barefoot a great form of the time, which produced an innovations-blowing set of calluses on his ft. He additionally ate little or no, which made him extremely frail and along with his outstanding eating habitual, he suffered from undesirable breath. This made him (oh, guy, that's so undesirable, it somewhat is solid) ... a great-calloused fragile mystic hexed by applying halitosis. .