Viewing 15 posts - 2,551 through 2,565 (of 2,857 total)
Glad I could help 🙂
Sometimes all it takes is a fresh pair of eyes on the problem to get a solution. It's funny how many times I spend...
May 4, 2017 at 3:22 pm
I am assuming these are 2 different queries returning these. So you want a 3rd query then I presume?
How about using a CASE statement and COUNT()?
I'm...
May 4, 2017 at 1:36 pm
The original query didn't do it for me. It was giving odd results like saying a TimesExecuted is 2 but ExecutedBy lists 7 distinct users. That makes no sense. I...
May 3, 2017 at 10:17 am
April 26, 2017 at 12:50 pm
Another thing you could try is to load up profiler and see exactly what is being sent to the database. I would suggest extended events, but this is 2008 and...
April 26, 2017 at 10:25 am
April 26, 2017 at 10:22 am
Are you sure it is SQL that is cutting off the data and not your web process? I've seen oddities in websites where they had their email forms cutting off...
April 26, 2017 at 10:05 am
April 25, 2017 at 2:47 pm
Lynn Pettis - Monday, April 24, 2017 4:12 PMSorry I brought it up.
I'm glad you did. It was a fun contribution to...
April 24, 2017 at 4:15 pm
tcronin 95651 - Monday, April 24, 2017 2:34 PMmy bad the trigger will not work for multiple record deletes
You could make it...
April 24, 2017 at 2:39 pm
This may be a silly question but did you install the ACE drivers on the SQL Server instance machine or your local machine?
EDIT - never mind... saw your...
April 24, 2017 at 2:34 pm
That trigger looks right to me.
When you say that it fires for the first insert but not others, how many rows are being inserted at once? What does...
April 24, 2017 at 2:31 pm
Viewing 15 posts - 2,551 through 2,565 (of 2,857 total)