Viewing 15 posts - 1 through 15 (of 26 total)
Agree with Jeff. from BOL:
Requires membership in the sysadmin fixed server role or membership in the public fixed database role in the master database with EXECUTE permission...
July 17, 2020 at 1:47 pm
I'm afraid none of the answers are correct.
as it stands, it would only work if there was a database with the date as part of the name, which would write...
March 16, 2020 at 5:01 am
There are actually 2 different, but related, errors:
The date is included in the literal;
the time contains a letter "p" that is not recognised;
therefore, answers 2 and 3 are equally valid
January 9, 2020 at 6:44 am
The 2nd and 4th answers appear to be the same?
November 27, 2019 at 9:06 am
Methinks there is a minor fail.
no options correct?
Good question, execution not so much
May 2, 2019 at 5:07 am
Nice question, thanks Kendra
Had to field something similar fairly recently.
A developer wrote all his tables, views & procs im model, but could not understand why new databases contained...
March 4, 2019 at 11:35 pm
Brilliant..
Nice one to start the week on, thanks Evgeny
July 22, 2018 at 11:02 pm
and here i thought - am i losing my marbles?
the space after the coma in the delimiter will surely cause an error...
glad i'm not the only one who...
July 8, 2018 at 11:25 pm
This is great, exactly what I was looking for....
July 3, 2018 at 1:48 am
Trying to explain this to a junior dba who believes he knows everything about everything.
talk about an uphill battle - he believes that because the server only hosts one...
June 20, 2018 at 2:55 am
This is a good question, Junior
just a bit confused about the answer
Correct answer: | Only data files |
Explanation: | ... |
February 7, 2017 at 10:17 pm
Good question about an interesting functionality, thanks, Steve
Just a minor fail regarding the options - select 3, yet only 2 accepted as correct?
June 28, 2016 at 11:09 pm
Viewing 15 posts - 1 through 15 (of 26 total)