Kevin Remde's IT Pro Weblog
IT Pro Resources
TechNet EventsMicrosoft Security Response CenterTechNet IT Manager Community HubMicrosoft Virtual AcademyKevin’s Evaluation Download Center
IT Pro Evangelist Blogs
Blain Barton Blain Barton's Blog@BlainBar
Brian LewisMy Thoughts on IT...@BrianLewis_
Dan Stolts IT Pro Guru Blog@ITProGuru
Jennelle Crothers TechBunny@jkc137
Keith MayerIT Pros ROCK!@KeithMayer
Kevin Remde Full of I.T.@KevinRemde
Matt Hester Matthew Hester's WebLog@MatthewHester
Tommy PattersonVirtually Cloud 9@Tommy_Patterson
Yung Chou Yung Chou on Hybrid Cloud@YungChou
SQL Server 2005 Tidbit 027
This tidbit comes as an answer to a really good question asked at a recent TechNet Event:
“In your demo of integrated log viewers, you showed looking at the SQL and NT Event logs on the database server you were managing. Can you integrate and view IIS Log information from a remote IIS Server?”
This question is a good one. I can see why you’d like to see what’s gone on on the SQL Server at the same time as on the IIS Server where the web application that is using it is running.
However, in the log viewer in SQL Server 2005, you’re only looking at the logs on the one server. You can open up two log windows side-by-side (for other servers), but you won’t be able to see it on the same timeline.
A solution is to EXPORT the log from one machine, and IMPORT them into the log viewer currently looking the other. Or export from both and import into the same console. This functionality IS supported on the Log File Viewer.
Got an IT question? Give me a comment, or contact me.