Viewing 15 posts - 26,551 through 26,565 (of 39,793 total)
I don't think any of the data in the backup file is visible natively. SQLCompare (Red Gate) can do this, comparing with a backup file and can likely pull the...
October 24, 2008 at 10:36 am
Please watch the forums in which you post. Moved to SSRS.
No idea why this doesn't run. Are the SSRS and SSIS on the same server?
October 24, 2008 at 10:34 am
You'd still have to join in data somehow. Your joins don't necessarily have to relate to each other, meaning that you just have to qualify which rows you want from...
October 24, 2008 at 10:32 am
THanks for the note. I'll get someone to check it out.
October 24, 2008 at 10:23 am
Peter, interesting comments.
I think some of the issues aren't just that it's government, but that it's often there's not enough transparency and accountability. Not enough of the desire to really...
October 24, 2008 at 10:19 am
Interesting comments. It's funny to see how many people look at different things.
And I think it's fine to not have any absolutes. I try to have few, mostly guidelines though...
October 24, 2008 at 10:05 am
It's doable, and depending on how large the site is, it's possible that you could deploy this hour to the front page, next to the account management, next to something...
October 22, 2008 at 12:23 pm
I'd look at a trace, grab just insert/update/delete events to a table.
Then roll those up periodically to another table and delete them from the trace table.
October 22, 2008 at 12:12 pm
Or buy a log reader tool (ApexSQL, Lumigent) to read through the logs to undo the deletion.
October 22, 2008 at 11:04 am
Uninstall, reinstall client tools. You have a problem with the tools.
October 22, 2008 at 10:44 am
You can setup a role that has deny permission for insert/update/delete and then add users to this along with the other roles. That should cause those SPs that change data...
October 22, 2008 at 10:43 am
I'd think it would be the same, but I've never messed with it enough to know if it really matters.
October 22, 2008 at 10:42 am
I agree with Gail. You really want to back up the log every hour or so. I bet if you told you boss that if we had an issue at...
October 22, 2008 at 10:42 am
It's not a bad idea, especially if you want to keep track of discussion on it. We have adding a discussion to the briefcase on the list, but it's a...
October 22, 2008 at 10:40 am
Viewing 15 posts - 26,551 through 26,565 (of 39,793 total)