Click here to Skip to main content
12,244,322 members (37,905 online)
   

Database

 
AnswerExecution plan Pin
David Mujica4-Oct-12 11:25
memberDavid Mujica4-Oct-12 11:25 
GeneralRe: Execution plan Pin
cjb1104-Oct-12 21:58
membercjb1104-Oct-12 21:58 
GeneralRe: Execution plan Pin
David Mujica8-Oct-12 9:54
memberDavid Mujica8-Oct-12 9:54 
GeneralRe: Execution plan Pin
cjb1109-Oct-12 0:41
membercjb1109-Oct-12 0:41 
GeneralRe: Execution plan Pin
David Mujica9-Oct-12 4:12
memberDavid Mujica9-Oct-12 4:12 
GeneralRe: Execution plan Pin
cjb1109-Oct-12 5:34
membercjb1109-Oct-12 5:34 
GeneralHigh CPU Pin
David Mujica9-Oct-12 10:13
memberDavid Mujica9-Oct-12 10:13 
GeneralRe: High CPU Pin
cjb11010-Oct-12 22:30
membercjb11010-Oct-12 22:30 
GeneralRe: High CPU Pin
cjb11011-Oct-12 0:15
membercjb11011-Oct-12 0:15 
QuestionMySQL Server timestamp changed! Pin
jrahma2-Oct-12 22:53
memberjrahma2-Oct-12 22:53 
AnswerRe: MySQL Server timestamp changed! Pin
Shameel3-Oct-12 5:05
memberShameel3-Oct-12 5:05 
QuestionConnection String for Ms access 2010 to Windows 7 64 Bit Pin
Satyam Tripathi2-Oct-12 22:33
memberSatyam Tripathi2-Oct-12 22:33 
AnswerRe: Connection String for Ms access 2010 to Windows 7 64 Bit Pin
Richard MacCutchan2-Oct-12 23:00
mvpRichard MacCutchan2-Oct-12 23:00 
QuestionBackup/Recover of row data in a multi-Company database Pin
DeDawg2-Oct-12 11:35
memberDeDawg2-Oct-12 11:35 
We have a web application using SQL Server 2008 R2 that contains data for tracking time that another company has expressed interest in using, we initially set up the database such that all end-user tables have a foreign key to what company that row belongs to. Is there a good way to backup/restore the data for a specific company across the tables, such that if the new company says tomorrow that they want their data restored to yesterday; it can be restored without impacting all the other companies data as well? I'm trying to avoid writing some form of stored procedure that selects and then have to do an insert/update/delete to put the data back. Thanks for any insight.
Dennis Daugherty

AnswerRe: Backup/Recover of row data in a multi-Company database Pin
Mika Wendelius2-Oct-12 12:17
mvpMika Wendelius2-Oct-12 12:17 
GeneralRe: Backup/Recover of row data in a multi-Company database Pin
DeDawg2-Oct-12 12:22
memberDeDawg2-Oct-12 12:22 
GeneralRe: Backup/Recover of row data in a multi-Company database Pin
Mika Wendelius2-Oct-12 19:22
mvpMika Wendelius2-Oct-12 19:22 
AnswerRe: Backup/Recover of row data in a multi-Company database Pin
Mycroft Holmes3-Oct-12 8:39
memberMycroft Holmes3-Oct-12 8:39 
GeneralRe: Backup/Recover of row data in a multi-Company database Pin
DeDawg3-Oct-12 8:43
memberDeDawg3-Oct-12 8:43 
GeneralRe: Backup/Recover of row data in a multi-Company database Pin
Mycroft Holmes3-Oct-12 9:02
memberMycroft Holmes3-Oct-12 9:02 
Questioncannot find column Pin
sindhuan1-Oct-12 1:19
membersindhuan1-Oct-12 1:19 
AnswerRe: cannot find column Pin
Eddy Vluggen1-Oct-12 2:00
memberEddy Vluggen1-Oct-12 2:00 
QuestionHow to Recover Deleted rows from sql 2000 Database Pin
Robymon30-Sep-12 21:38
memberRobymon30-Sep-12 21:38 
AnswerRe: How to Recover Deleted rows from sql 2000 Database Pin
Eddy Vluggen1-Oct-12 1:57
memberEddy Vluggen1-Oct-12 1:57 
AnswerRe: How to Recover Deleted rows from sql 2000 Database Pin
Shameel3-Oct-12 6:46
memberShameel3-Oct-12 6:46 
QuestionWindows Run Command Pin
jojoba201129-Sep-12 0:08
memberjojoba201129-Sep-12 0:08 
AnswerRe: Windows Run Command Pin
Eddy Vluggen29-Sep-12 3:41
memberEddy Vluggen29-Sep-12 3:41 
AnswerRe: Windows Run Command Pin
Richard MacCutchan29-Sep-12 3:58
mvpRichard MacCutchan29-Sep-12 3:58 
AnswerRe: Windows Run Command Pin
jojoba201129-Sep-12 6:12
memberjojoba201129-Sep-12 6:12 
GeneralRe: Windows Run Command Pin
Richard MacCutchan29-Sep-12 7:09
mvpRichard MacCutchan29-Sep-12 7:09 
QuestionRe: Windows Run Command Pin
jojoba201129-Sep-12 10:26
memberjojoba201129-Sep-12 10:26 
AnswerRe: Windows Run Command Pin
Richard MacCutchan29-Sep-12 22:29
mvpRichard MacCutchan29-Sep-12 22:29 
GeneralRe: Windows Run Command Pin
jojoba201129-Sep-12 23:40
memberjojoba201129-Sep-12 23:40 
GeneralRe: Windows Run Command Pin
Richard MacCutchan30-Sep-12 2:01
mvpRichard MacCutchan30-Sep-12 2:01 
QuestionRe: Windows Run Command Pin
jojoba201130-Sep-12 5:58
memberjojoba201130-Sep-12 5:58 
AnswerRe: Windows Run Command Pin
Richard MacCutchan30-Sep-12 6:13
mvpRichard MacCutchan30-Sep-12 6:13 
QuestionRe: Windows Run Command Pin
Eddy Vluggen1-Oct-12 1:59
memberEddy Vluggen1-Oct-12 1:59 
QuestionRe: Windows Run Command Pin
Member 94738091-Oct-12 5:28
memberMember 94738091-Oct-12 5:28 
AnswerRe: Windows Run Command Pin
Eddy Vluggen1-Oct-12 6:09
memberEddy Vluggen1-Oct-12 6:09 
QuestionRe: Windows Run Command Pin
jojoba20111-Oct-12 23:09
memberjojoba20111-Oct-12 23:09 
AnswerRe: Windows Run Command Pin
Eddy Vluggen2-Oct-12 1:58
memberEddy Vluggen2-Oct-12 1:58 
QuestionRe: Windows Run Command Pin
jojoba20112-Oct-12 7:58
memberjojoba20112-Oct-12 7:58 
AnswerRe: Windows Run Command Pin
Eddy Vluggen2-Oct-12 9:08
memberEddy Vluggen2-Oct-12 9:08 
QuestionMySQL Question Pin
SQL Ed28-Sep-12 5:21
memberSQL Ed28-Sep-12 5:21 
AnswerRe: MySQL Question Pin
Eddy Vluggen29-Sep-12 3:38
memberEddy Vluggen29-Sep-12 3:38 
QuestionRemoving the updated row Pin
sindhuan28-Sep-12 2:48
membersindhuan28-Sep-12 2:48 
QuestionMySQL sql statement question Pin
jrahma27-Sep-12 10:28
memberjrahma27-Sep-12 10:28 
AnswerRe: MySQL sql statement question Pin
jschell27-Sep-12 11:12
memberjschell27-Sep-12 11:12 
GeneralRe: MySQL sql statement question Pin
jrahma27-Sep-12 12:08
memberjrahma27-Sep-12 12:08 
GeneralRe: MySQL sql statement question Pin
Eddy Vluggen29-Sep-12 3:42
memberEddy Vluggen29-Sep-12 3:42 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.160426.1 | Last Updated 30 Apr 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid