Viewing 15 posts - 1 through 15 (of 41 total)
I agree the backup statement is incorrect.
This will work:
DECLARE @d NVARCHAR(MAX) = 'AdventureWorks2012'
DECLARE @n NVARCHAR(MAX)
SELECT @n = @d + '_' + CAST(CAST(SYSDATETIME() AS DATE) AS nvarchar(20)) + '.trn'
BACKUP LOG @d...
March 16, 2020 at 9:06 am
How about outputing data to a table?
February 28, 2020 at 11:33 am
October 2, 2018 at 1:25 am
I guessed that would be the case. Not very up to speed on R
February 1, 2018 at 4:19 am
Yep, bit of a head scratcher. Confess got it right by a guess. 😉
January 16, 2018 at 2:12 am
December 14, 2017 at 1:42 am
Thanks, and it prompted me to revise the new date formats
October 10, 2017 at 1:34 am
Drat! Read it totally wrong and wanted to select 3 answers, then picked the wrong 2.
September 5, 2017 at 1:26 am
Discounted CEILING totally as the question was specific to round down.
August 22, 2017 at 7:18 am
Drat, I did it too fast and only picked one
March 31, 2017 at 3:00 am
But isn't that what READ COMMITTED SNAPSHOT Isolation is supposed to allow, i.e. read committed data without locking it?
March 9, 2017 at 1:24 am
My understanding of READ COMMITTED SNAPSHOT isolation was obviously wrong I thought the opposite, that it prevented locking errors. Doh!
March 8, 2017 at 1:33 am
I got it wrong, I was convinced it that although the default for Tempdb was OFF it could still be turned on. Doh!
February 13, 2017 at 1:09 am
Viewing 15 posts - 1 through 15 (of 41 total)