This looks really good...now, I need to understand what infomation I have here...still looking.

THANKS!

C

Looks great.

When I try to connect to a remote db, I get this error:
Any one know why?

TITLE: Connect to server
------------------------------

Invalid object name 'sys.database_files'. (Microsoft SQL Server, Error: 208)

Donavon,

What version of SQL Server are you trying to connect to? The tool only works with SQL Server 2005/2008.

Danny

This is sweet. No more DBCC Page commands for me!

As an aside, does Kalen Delaney know about this tool yet? She might find it quite interesting, since she's person that many of us learned the internals from in the first place.

A couple of changes that I'd like to see made in the tool in a future release:

1. The application is listed as ".Net SqlClient Data Provider". Would prefer to see it's actual application name listed when I do an sp_who2.
2. The distribution database is listed as a user database rather than a system database. I would like to see it listed as a system database.

I received the following error:

TITLE: SQL Internals Viewer
------------------------------

An unhandled exception has occurred.

Please report this error to issues@sqlinternalsviewer.com to help improve this application.

------------------------------
ADDITIONAL INFORMATION:

Index was outside the bounds of the array. (SqlInternalsViewer)

------------------------------
Program Location:

   at SqlInternalsViewer.UI.AllocationUnitsLayer.GenerateLayers(Database database, BackgroundWorker worker)
   at SqlInternalsViewer.ApplicationForm.AllocUnitbackgroundWorker_DoWork(Object sender, DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)