MSSQLTips

http://www.mssqltips.com/tip.asp?tip=1577

Very good topic. Good to know the internals and the fact that Micorsoft has increased the usage of SQL Server in many of its products.

Great Tip but I was unable to connect with (\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query) and result was:   "An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid) (.Net SqlClient Data Provider)"

Got it.  The instructions were missing one leading "\".     \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query