Viewing 15 posts - 1,111 through 1,125 (of 26,490 total)
Please do not double post. It can fragment answers.
Please post answers here: https://www.sqlservercentral.com/Forums/1991338/Is-it-possible-to-retrieve-names-of-SSIS-packages-that-have-an-Exec-SQL-task-that-executes-a-specifi
August 23, 2018 at 2:23 pm
August 22, 2018 at 1:16 pm
August 21, 2018 at 11:24 pm
August 21, 2018 at 7:16 pm
August 21, 2018 at 6:49 pm
Without researching this more myself, I would say this is expected as the ALTER TABLE is actually executed even though the column doesn't exist.
August 21, 2018 at 6:46 pm
August 21, 2018 at 2:31 pm
Looks to me that your choices are exactly those you have said you don't want: a trigger or a scalar function in a constraint.
August 21, 2018 at 12:37 pm
It really should be a...
August 21, 2018 at 9:31 am
August 21, 2018 at 9:00 am
Sergiy - Tuesday, August 21, 2018 4:42 AMApart from that- change all your literal constants from 'String' to N'String'
Careful, Sergiy, someone (not...
August 21, 2018 at 8:50 am
Please defend your use of the NOLOCK hint. You do realize that this can be bad.
August 20, 2018 at 5:00 pm
August 20, 2018 at 4:56 pm
Viewing 15 posts - 1,111 through 1,125 (of 26,490 total)