Viewing 15 posts - 166 through 180 (of 49,571 total)
No idea why it's getting in the log table twice (that trigger CANNOT insert two rows, so it must have fired twice), but that trigger is flawed.
A trigger fires...
April 27, 2018 at 11:05 am
On an unrelated note, I've started writing fiction again on my personal blog. At the moment it's limited to material related to an ongoing roleplaying campaign, but I hope to...
April 27, 2018 at 9:28 am
Is there a logon trigger on the server?
April 27, 2018 at 6:18 am
Is there some job that kills sessions that use too much TempDB space? Something another DBA put in place?
April 27, 2018 at 6:15 am
April 27, 2018 at 2:53 am
ejoell 66477 - Friday, April 20, 2018 8:26 AMBut why would the auto-generated script show the square brackets in the incorrect location?
It...
April 20, 2018 at 4:09 pm
You're going to have to figure out where the differences come from yourself. Look at the queries, look at the source data, trace down where the differences originate. I haven't...
April 19, 2018 at 12:41 pm
ejoell 66477 - Wednesday, April 18, 2018 7:03 AMNone of you people have identified the issue.
6 year old thread, and Lynn...
April 18, 2018 at 2:10 pm
April 18, 2018 at 12:59 pm
April 18, 2018 at 12:48 pm
April 18, 2018 at 12:45 pm
April 18, 2018 at 1:40 am
April 17, 2018 at 10:37 am
Create yourself a new login, add DB users and grant them absolutely no permissions, and then log in and see how visible the various metadata and security information is. That'll...
April 17, 2018 at 5:04 am
I have said, multiple times now, that I do not suggest removing permissions from public. I also don't recommend adding any permissions to public. Rather add permissions to user-defined roles...
April 17, 2018 at 4:31 am
Viewing 15 posts - 166 through 180 (of 49,571 total)