Click here to Skip to main content
14,604,663 members
   

Database

 
QuestionUnable to create database programmatically Pin
Helfdane7-Mar-11 10:44
MemberHelfdane7-Mar-11 10:44 
AnswerRe: Unable to create database programmatically Pin
Wendelius7-Mar-11 11:56
mveWendelius7-Mar-11 11:56 
GeneralRe: Unable to create database programmatically Pin
Helfdane8-Mar-11 1:24
MemberHelfdane8-Mar-11 1:24 
GeneralRe: Unable to create database programmatically Pin
Wendelius8-Mar-11 8:21
mveWendelius8-Mar-11 8:21 
AnswerRe: Unable to create database programmatically Pin
PIEBALDconsult7-Mar-11 16:34
professionalPIEBALDconsult7-Mar-11 16:34 
AnswerRe: Unable to create database programmatically Pin
Roger Wright7-Mar-11 17:23
professionalRoger Wright7-Mar-11 17:23 
GeneralRe: Unable to create database programmatically Pin
Helfdane8-Mar-11 1:24
MemberHelfdane8-Mar-11 1:24 
QuestionAudit Trail : Single table for all users or multiple table per user Pin
eight6-Mar-11 22:35
Membereight6-Mar-11 22:35 
Hi,
I'm designing an audit trail database to log user's activities. Should I create a single table to log all user activities e.g:
Id(PK) | UserId(FK) | ActionTime | ActionTaken

or, multiple tables; each per user e.g:
Table Name : AuditTrail_UserId

Id(PK) | ActionTime | ActionTaken

I'd like to be able to do 2 kind of text search though,
1. Search single user activities
2. Search all user activities
AnswerRe: Audit Trail : Single table for all users or multiple table per user Pin
WoutL6-Mar-11 22:53
MemberWoutL6-Mar-11 22:53 
AnswerRe: Audit Trail : Single table for all users or multiple table per user Pin
musefan6-Mar-11 22:57
Membermusefan6-Mar-11 22:57 
GeneralRe: Audit Trail : Single table for all users or multiple table per user Pin
Dave Kerr6-Mar-11 23:03
mvaDave Kerr6-Mar-11 23:03 
GeneralRe: Audit Trail : Single table for all users or multiple table per user Pin
musefan6-Mar-11 23:36
Membermusefan6-Mar-11 23:36 
AnswerRe: Audit Trail : Single table for all users or multiple table per user Pin
Eddy Vluggen7-Mar-11 0:15
professionalEddy Vluggen7-Mar-11 0:15 
AnswerRe: Audit Trail : Single table for all users or multiple table per user Pin
Wendelius7-Mar-11 1:52
mveWendelius7-Mar-11 1:52 
QuestionUpgrading MSDE SP4 to SQL 2008 Express R2 Pin
Elsie6-Mar-11 19:46
MemberElsie6-Mar-11 19:46 
QuestionSQL Help - sum items based on max but also smaller than...? Pin
GlobX6-Mar-11 17:09
MemberGlobX6-Mar-11 17:09 
AnswerRe: SQL Help - sum items based on max but also smaller than...? Pin
Wendelius7-Mar-11 7:40
mveWendelius7-Mar-11 7:40 
GeneralRe: SQL Help - sum items based on max but also smaller than...? [modified] Pin
GlobX7-Mar-11 12:12
MemberGlobX7-Mar-11 12:12 
GeneralRe: SQL Help - sum items based on max but also smaller than...? Pin
Wendelius7-Mar-11 18:37
mveWendelius7-Mar-11 18:37 
AnswerRe: SQL Help - sum items based on max but also smaller than...? Pin
GlobX7-Mar-11 13:05
MemberGlobX7-Mar-11 13:05 
Questioncopy data from 1 table to another table Pin
bapu28895-Mar-11 6:07
Memberbapu28895-Mar-11 6:07 
AnswerRe: copy data from 1 table to another table Pin
Mycroft Holmes5-Mar-11 12:07
professionalMycroft Holmes5-Mar-11 12:07 
AnswerRe: copy data from 1 table to another table Pin
PIEBALDconsult5-Mar-11 14:48
professionalPIEBALDconsult5-Mar-11 14:48 
QuestionRe: copy data from 1 table to another table Pin
bapu28895-Mar-11 19:57
Memberbapu28895-Mar-11 19:57 
QuestionRead only ADO connection still allows writing to database? Pin
PJ Arends4-Mar-11 17:54
professionalPJ Arends4-Mar-11 17:54 

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.