Viewing 15 posts - 4,951 through 4,965 (of 13,877 total)
November 3, 2017 at 2:23 pm
November 3, 2017 at 2:21 pm
Alternatively, why not something like
IF TRY_CAST(Column1 as INT) is NULL
BEGIN
--Write to error log
END?
Though you would have to do this as part of the FETCH loop,...
November 3, 2017 at 12:27 pm
That issue/error is obnoxious. There is a three part name earlier in the procedure,...
November 3, 2017 at 12:05 pm
This does not get caught at design time. You have to open the cursor to invoke the error handling, as follows:DECLARE @test-2 TABLE
(
column1 VARCHAR(256)
November 3, 2017 at 11:39 am
November 3, 2017 at 11:16 am
Sue_H - Friday, November 3, 2017 10:22 AMMaybe try adding a reference to the master database?
Sue
Thanks, Sue, but MSDB and...
November 3, 2017 at 10:34 am
November 3, 2017 at 8:18 am
November 3, 2017 at 6:08 am
November 3, 2017 at 5:44 am
Writing to the Event Log is also possible using Powershell, I believe ... did you consider that avenue?
November 3, 2017 at 5:42 am
November 3, 2017 at 5:40 am
Viewing 15 posts - 4,951 through 4,965 (of 13,877 total)