May 22, 2014 at 12:04 am
The selection of answer should have been check boxes 🙂
May 22, 2014 at 12:05 am
Nice one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 22, 2014 at 12:05 am
Thanks for the question steve. The selection of answer should have been check boxes 🙂
apologies for the duplicate post
May 22, 2014 at 12:55 am
Thanks Steve for the question.
It has also been notice that Log file viewer is not displaying all the option at a time. If you open from SQL Server logs it will give you a few options, if you open from SQL Server Agent it will display some different logs, if you view log clicking data collection it will give different sets etc.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 22, 2014 at 1:07 am
Thanks for the question Steve.
However I think version of SQL server should be mentioned in question as Remote maintenance plans can not be accessed by Log file Viewer in SQL Server 2008.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
May 22, 2014 at 1:43 am
rhythmk (5/22/2014)
Thanks for the question Steve.However I think version of SQL server should be mentioned in question as Remote maintenance plans can not be accessed by Log file Viewer in SQL Server 2008.
+1 that caught me out 🙂
May 22, 2014 at 3:38 am
Thank you the post, SJ, simple one and nice.... but I did get it wrong.
I opened the LFV and saw these (with sub selection under each, except agent) "SQL Server", "SQL Server Agent", "Database Mail" and "Windows NT". I guess the list changes depending on the configuration or additional component installations, but the LVF has the support to log all the logs.
Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
Dec 28 2012 20:23:12
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
May 22, 2014 at 3:47 am
thanks for the question,
but why all answers say "only" at the end?? that's a bit confusing since no option has all the types listed in BOL. :w00t:
May 22, 2014 at 5:02 am
May 22, 2014 at 5:04 am
Koen Verbeeck (5/22/2014)
Nice one, thanks.
+1
Igor Micev,My blog: www.igormicev.com
May 22, 2014 at 7:34 am
Nice QOTD Steve.
May 22, 2014 at 9:40 am
pmadhavapeddi22 (5/22/2014)
The selection of answer should have been check boxes 🙂
No checkboxes as you need to decide if there are additional items for each list. That's why they end with "only"
May 22, 2014 at 9:40 am
free_mascot (5/22/2014)
Thanks Steve for the question.It has also been notice that Log file viewer is not displaying all the option at a time. If you open from SQL Server logs it will give you a few options, if you open from SQL Server Agent it will display some different logs, if you view log clicking data collection it will give different sets etc.
I can't cover all the possibilities of what's shown in different places. That also changes across versions.
I was just asking what is possible.
May 22, 2014 at 9:41 am
rhythmk (5/22/2014)
Thanks for the question Steve.However I think version of SQL server should be mentioned in question as Remote maintenance plans can not be accessed by Log file Viewer in SQL Server 2008.
Fair enough. I've corrected this to 2012. I've been working on 2012 and 2014 only for a few years, so I didn't think about back-checking to 2008.
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply