SQL Server 2005 Tidbit 027

Happy SQL Express User

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.