Viewing 15 posts - 1,126 through 1,140 (of 49,571 total)
bmg002 - Thursday, July 13, 2017 12:07 PMI imagine you'd want to disable the trigger, do the insert, enable the trigger.
Yup. This...
July 13, 2017 at 12:20 pm
Is there a trigger on that table?
July 13, 2017 at 11:40 am
July 13, 2017 at 11:05 am
Yup, clustering and replication are independent.
July 13, 2017 at 6:25 am
Sure, make them a member of the sysadmin role, but then you may as well just go back to using the Administrator account, as that's essentially what you'll have done.
July 13, 2017 at 4:56 am
Looks like you've got a logon trigger in the system.
Try running this in the DB OurDatabaseNameGRANT EXECUTE ON getalertsgetalerts TO <put the DB...
July 13, 2017 at 4:08 am
Thanks Thom. I'm sitting in a training course, so I have bits of 'free' time.
That's the Customers table, now just need the OP to do the same for...
July 13, 2017 at 3:25 am
Can you please post CREATE TABLE statements, and some sample data as INSERT statements?
I want to be able to test answers.
p.s. Many people distrust random excel/word documents.
July 13, 2017 at 3:05 am
There's a few ways to do this.
Can you post CREATE TABLE statements and some sample data?
How many customers are there, and on average how many rows of...
July 13, 2017 at 1:44 am
July 12, 2017 at 9:41 am
July 12, 2017 at 8:32 am
July 12, 2017 at 8:27 am
Viewing 15 posts - 1,126 through 1,140 (of 49,571 total)