Viewing 15 posts - 31 through 45 (of 211 total)
They're not identical, but they are the same in terms of the problem being addressed here. Ie, the second one is left with the same problems. Well, actually the problem...
February 5, 2017 at 7:38 pm
That's the same schema and suffers the same problem: It is possible for an execution answer to specify a questionnaire that is different from its execution header.
January 21, 2017 at 10:43 am
Lynn Pettis (11/8/2016)
I may be wrong, but you might be able to use the Audit to trigger the polling of the data.
Yep yep, that's how I interpreted your suggestion.
November 9, 2016 at 4:40 pm
The audit events that would arguably useful for data change would have to be database level audits and thus would require alteration to the nominally proprietary database, although I can't...
November 7, 2016 at 9:47 pm
Ah, that makes sense.
Yeah, I think I would prefer to avoid debug events... especially since updates alone are not suffcient and, assuming there are similar insert and delete events, I...
November 7, 2016 at 6:52 pm
Hm, neither my SQL instance nor google seems to have heard of table_update_code_path.
November 7, 2016 at 4:15 pm
I've used extended events sparingly for admin purposes, but never as a normal developer resource. I wasn't even aware there was a "data change" type of extended event - unless...
November 6, 2016 at 11:32 pm
2012, standard on some instances, enterprise on others. A solution that works for standard edition would of course be preferable.
I have yet to look at 2016 features, if there's some...
November 6, 2016 at 11:08 pm
Two quick checks. First, is the query actually against the databsae to which the user has been granted permission? Second, does the select involve a cross database query? For example,...
December 8, 2015 at 5:23 pm
SQLKnowItAll (12/7/2015)
Not sure about CDC, but that makes sense because of its purpose. However, Transactional Replication does not care about the value staying the same, as that is not its...
December 7, 2015 at 3:01 pm
After much (intermittent) hair pulling I was about to suggest we go to premier support with this but decided to do one more round of googling. I finally found a...
December 6, 2015 at 8:02 pm
Useful findings. If I understand you correctly, those observations seem to be related to the fact that more columns were included but not specifically due to additional pages being included....
December 6, 2015 at 3:28 pm
SoHelpMeCodd (12/3/2015)
Use it where? Do you mean from a workstation whose credentials srv_integration does not trust (in my first quote), or elsewhere? Please elaborate if elsewhere:)
From any third party through...
December 3, 2015 at 8:12 pm
curious_sqldba (12/3/2015)
December 3, 2015 at 5:34 pm
curious_sqldba (12/2/2015)
did you make changes to the account in AD?
Do you mean changes immediately prior to the failure that may have cause it? Nope. It's also the same account as...
December 2, 2015 at 10:47 pm
Viewing 15 posts - 31 through 45 (of 211 total)