Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Log Files Expand / Collapse
Author
Message
Posted Thursday, May 22, 2014 5:02 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:41 PM
Points: 3,960, Visits: 2,970
Nice one, thanks.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1573511
Posted Thursday, May 22, 2014 5:04 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:35 AM
Points: 2,901, Visits: 2,927
Koen Verbeeck (5/22/2014)
Nice one, thanks.

+1




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1573512
Posted Thursday, May 22, 2014 7:34 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 4, 2014 9:03 AM
Points: 1,415, Visits: 796
Nice QOTD Steve.
Post #1573578
Posted Thursday, May 22, 2014 9:40 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:50 PM
Points: 33,072, Visits: 15,187
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"







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1573637
Posted Thursday, May 22, 2014 9:40 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:50 PM
Points: 33,072, Visits: 15,187
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1573639
Posted Thursday, May 22, 2014 9:41 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:50 PM
Points: 33,072, Visits: 15,187
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1573640
Posted Thursday, May 22, 2014 11:18 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, July 7, 2014 9:38 AM
Points: 1,780, Visits: 582
nice question steve.
Post #1573696
Posted Thursday, May 22, 2014 7:02 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:22 PM
Points: 2,205, Visits: 5,539
The link provided is for 2014 --
2012 as referenced in the question does not have the same list on MSDN
http://msdn.microsoft.com/en-us/library/dd206998(v=sql.110).aspx
Post #1573853
Posted Thursday, May 22, 2014 9:34 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 10:16 PM
Points: 2,922, Visits: 2,521
raulggonzalez (5/22/2014)
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.


+1

With the "only" at the end, I think all of the answers are wrong.

Plus, you can open other log files (.csv, .log files) - although you will need to make sure they have field that the log file viewer knows about



Post #1573870
Posted Friday, May 23, 2014 1:39 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 4, 2014 9:03 AM
Points: 1,415, Visits: 796
Steve Jones - SSC Editor (5/22/2014)
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.


From the options given I'd have thought it fair to say getting to the correct answer was reasonably easy, so why all the gripes?
Post #1573907
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse