Viewing 15 posts - 3,391 through 3,405 (of 7,609 total)
May 9, 2018 at 7:40 am
Unless you pre-build a combined table of all the sys.objects 'FN' entries for each db, you won't be able to do this. AFAIK, you can't get the object type and...
May 8, 2018 at 2:43 pm
May 8, 2018 at 11:30 am
CREATE TRIGGER [trg_srv_audit_DDL_Event]
ON ALL SERVER
WITH EXECUTE AS '<login_name>' /* replace with your own login_name with authority to write to audit table, etc. */
May 8, 2018 at 10:13 am
Yeah, you must use colons instead of dots in the time. I'm used to seeing either one ... but SQL isn't.
SELECT CAST('20180326 05:00:00' as datetime2)
May 7, 2018 at 3:58 pm
There must be a trigger(s) on the table that is incorrectly handling a date string (?).
May 7, 2018 at 3:49 pm
Get rid of the dashes in the date, they can cause issues.
UPDATE T_MYTABLE SET dateTransferred = '20180326 05.00.00' where id = 1223
May 7, 2018 at 3:35 pm
In any contiguous 28-day period, there will always be exactly 20 non-weekend dates and 8 weekend dates.
May 7, 2018 at 1:21 pm
May 7, 2018 at 1:19 pm
You can directly search for "Backup" "failed" messages without having to pull the entire log file first, viz:
EXEC sys.xp_readerrorlog @ArchiveID, 1, N'Backup', N'failed'
May 7, 2018 at 11:44 am
Viewing 15 posts - 3,391 through 3,405 (of 7,609 total)