Click here to Skip to main content
15,398,211 members
Home / Discussions / Database
   

Database

 
AnswerRe: Isolation Level Pin
Eddy Vluggen15-Jan-15 9:56
professionalEddy Vluggen15-Jan-15 9:56 
GeneralRe: Isolation Level Pin
Member 1137363815-Jan-15 17:15
MemberMember 1137363815-Jan-15 17:15 
GeneralRe: Isolation Level Pin
Eddy Vluggen16-Jan-15 7:58
professionalEddy Vluggen16-Jan-15 7:58 
QuestionAudit Tables for Many-Many Relationships Pin
Matt U.13-Jan-15 3:40
MemberMatt U.13-Jan-15 3:40 
AnswerRe: Audit Tables for Many-Many Relationships Pin
Eddy Vluggen13-Jan-15 7:49
professionalEddy Vluggen13-Jan-15 7:49 
GeneralRe: Audit Tables for Many-Many Relationships Pin
Matt U.13-Jan-15 10:00
MemberMatt U.13-Jan-15 10:00 
GeneralRe: Audit Tables for Many-Many Relationships Pin
Eddy Vluggen13-Jan-15 12:49
professionalEddy Vluggen13-Jan-15 12:49 
AnswerRe: Audit Tables for Many-Many Relationships Pin
Mycroft Holmes13-Jan-15 11:42
professionalMycroft Holmes13-Jan-15 11:42 
As much as I loathe triggers spit audit is the one area where they are the right tool for the job.

We have a Modified and ModifiedBy field on EVERY table and use that in the trigger to identify the culprit. We also do not use EF or windows authentication, our apps use app specific credentials to connect to the database.
Never underestimate the power of human stupidity
RAH

Questionhelp me ..plz share me database Contact.mdf microsoft Pin
Nguyen Jay12-Jan-15 21:16
MemberNguyen Jay12-Jan-15 21:16 
QuestionRe: help me ..plz share me database Contact.mdf microsoft Pin
ZurdoDev13-Jan-15 5:33
professionalZurdoDev13-Jan-15 5:33 
AnswerRe: help me ..plz share me database Contact.mdf microsoft Pin
Nguyen Jay13-Jan-15 5:40
MemberNguyen Jay13-Jan-15 5:40 
AnswerRe: help me ..plz share me database Contact.mdf microsoft Pin
ZurdoDev13-Jan-15 5:44
professionalZurdoDev13-Jan-15 5:44 
GeneralRe: help me ..plz share me database Contact.mdf microsoft Pin
Nguyen Jay13-Jan-15 5:53
MemberNguyen Jay13-Jan-15 5:53 
AnswerRe: help me ..plz share me database Contact.mdf microsoft Pin
ZurdoDev13-Jan-15 6:00
professionalZurdoDev13-Jan-15 6:00 
GeneralRe: help me ..plz share me database Contact.mdf microsoft Pin
Nguyen Jay13-Jan-15 6:03
MemberNguyen Jay13-Jan-15 6:03 
GeneralRe: help me ..plz share me database Contact.mdf microsoft Pin
ZurdoDev13-Jan-15 6:06
professionalZurdoDev13-Jan-15 6:06 
GeneralRe: help me ..plz share me database Contact.mdf microsoft Pin
Richard Deeming13-Jan-15 6:29
mveRichard Deeming13-Jan-15 6:29 
GeneralRe: help me ..plz share me database Contact.mdf microsoft Pin
Nguyen Jay13-Jan-15 7:17
MemberNguyen Jay13-Jan-15 7:17 
QuestionMySQL Database Tables Pin
sudevsu12-Jan-15 8:29
Membersudevsu12-Jan-15 8:29 
AnswerRe: MySQL Database Tables Pin
RUs12313-Jan-15 2:13
MemberRUs12313-Jan-15 2:13 
GeneralRe: MySQL Database Tables Pin
sudevsu14-Jan-15 8:53
Membersudevsu14-Jan-15 8:53 
QuestionGrouping From & To continuous dates in SQL Server Pin
Ashokraja V7-Jan-15 17:34
MemberAshokraja V7-Jan-15 17:34 
AnswerRe: Grouping From & To continuous dates in SQL Server Pin
Mycroft Holmes7-Jan-15 20:58
professionalMycroft Holmes7-Jan-15 20:58 
GeneralRe: Grouping From & To continuous dates in SQL Server Pin
Ashokraja V7-Jan-15 21:13
MemberAshokraja V7-Jan-15 21:13 
GeneralRe: Grouping From & To continuous dates in SQL Server Pin
Mycroft Holmes7-Jan-15 21:20
professionalMycroft Holmes7-Jan-15 21:20 

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.