Viewing 15 posts - 3,586 through 3,600 (of 7,609 total)
January 24, 2018 at 7:11 am
January 24, 2018 at 7:10 am
Other than the use of cte, I don't see any fundamental difference between your code and what I posted earlier, although I admit I haven't thoroughly reviewed it, since I'm...
January 23, 2018 at 4:04 pm
January 23, 2018 at 3:44 pm
January 23, 2018 at 2:57 pm
Does YYYY-MM-00 -- not to mention YYYY-00-00 -- raise 1NF / atomicity issues? Does the column represent an atomic date or a range of dates? Is the range somehow deemed...
January 23, 2018 at 2:24 pm
January 23, 2018 at 11:43 am
My (strong) preference is instead to use EXECUTE AS on the CREATE TRIGGER:
ALTER TRIGGER [SchemaChange_LogInTable_DDL]
ON ALL SERVER
WITH EXECUTE AS 'big_cheese_login'
FOR ...
...
January 23, 2018 at 9:43 am
I think you can use NOT:
IF NOT UPDATE(col19) AND NOT UPDATE(col20)
January 23, 2018 at 9:41 am
Have you considered instead of binding them just running a:
sp_refreshview
across all the...
January 23, 2018 at 9:36 am
Have you considered instead of binding them just running a:
sp_refreshview
across all the views when a base table changes? (or across all views that could possibly be affected, if...
January 23, 2018 at 9:27 am
January 23, 2018 at 7:00 am
Not necessarily. You can use CONTEXT_INFO() to pass a "flag" to the trigger to "tell" it not to update. You might also look into replication.
Below is a sample...
January 22, 2018 at 3:05 pm
January 22, 2018 at 2:47 pm
Viewing 15 posts - 3,586 through 3,600 (of 7,609 total)