Click here to Skip to main content
15,568,965 members
Home / Discussions / Database
   

Database

 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201121-May-12 21:11
jojoba201121-May-12 21:11 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen22-May-12 1:52
professionalEddy Vluggen22-May-12 1:52 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201122-May-12 4:22
jojoba201122-May-12 4:22 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen22-May-12 9:50
professionalEddy Vluggen22-May-12 9:50 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201123-May-12 0:24
jojoba201123-May-12 0:24 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen23-May-12 1:16
professionalEddy Vluggen23-May-12 1:16 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201123-May-12 4:37
jojoba201123-May-12 4:37 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen23-May-12 9:23
professionalEddy Vluggen23-May-12 9:23 
jojoba2011 wrote:
hi dear

I'd like to suggest a more neutral greeting.

jojoba2011 wrote:
See can u give me something like that

No, because the structure of the ldf-file isn't public. You'd still need to talk to Microsoft if you want to read the ldf-file. Or try and lull the company into handing you some help.

jojoba2011 wrote:
I know that u can do that cause ur expert in SQL.

Nope; I can only give some options -

  • You can do a real audit in Sql Server, not Sql Express
  • You can trace, but that doesn't show the "old" values
  • You can insert without update. Sounds wrong, but is often the best solution, since your table is the most optimized structure to hold that type of data.
  • You could create triggers to copy both old and new values to some other table, which would be the complex version of the point above, without too much added value.
  • You can change the datalayer of the code talking to your server, and have it log there.
  • Talk to Microsoft

Bastard Programmer from Hell Suspicious | :suss:

AnswerRe: How to get delete/Update row + SQL Pin
Mycroft Holmes20-May-12 13:55
professionalMycroft Holmes20-May-12 13:55 
AnswerRe: How to get delete/Update row + SQL Pin
Corporal Agarn21-May-12 1:49
professionalCorporal Agarn21-May-12 1:49 
GeneralRe: How to get delete/Update row + SQL Pin
Eddy Vluggen21-May-12 4:45
professionalEddy Vluggen21-May-12 4:45 
GeneralRe: How to get delete/Update row + SQL Pin
Corporal Agarn21-May-12 4:51
professionalCorporal Agarn21-May-12 4:51 
GeneralRe: How to get delete/Update row + SQL Pin
Eddy Vluggen21-May-12 5:27
professionalEddy Vluggen21-May-12 5:27 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton21-May-12 14:04
JohnPayton21-May-12 14:04 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201121-May-12 21:08
jojoba201121-May-12 21:08 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton21-May-12 21:25
JohnPayton21-May-12 21:25 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201121-May-12 21:34
jojoba201121-May-12 21:34 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton21-May-12 21:51
JohnPayton21-May-12 21:51 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201121-May-12 22:22
jojoba201121-May-12 22:22 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton22-May-12 13:52
JohnPayton22-May-12 13:52 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201122-May-12 18:58
jojoba201122-May-12 18:58 
Questiondata base system Pin
sajid ali laghari18-May-12 21:30
sajid ali laghari18-May-12 21:30 
AnswerRe: data base system Pin
Eddy Vluggen19-May-12 1:39
professionalEddy Vluggen19-May-12 1:39 
QuestionHow to sort result if data fields contains both numeric and character value Pin
Rupesh Kumar Swami17-May-12 22:20
Rupesh Kumar Swami17-May-12 22:20 
AnswerRe: How to sort result if data fields contains both numeric and character value Pin
Eddy Vluggen19-May-12 1:32
professionalEddy Vluggen19-May-12 1:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.