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 2:46 am
This was removed by the editor as SPAM
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.
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply