This can be useful in identifying the host AND the program connecting to you SQL Server database.

In Query Analyzer execute

exec sp_who2

Note the "PorgramName" column.

Alternatively you can use the following select to obtain the hostname of the SQL Server.

SELECT   SERVERPROPERTY('ServerName') as 'Server Name';

and the query below will provide you with further useful SQL Server...

This is a great start! How can other DBA's/SQL Developers contribute more "TiVo for DBA's"?

What tools were used to capture and record the administrative tasks demonstrated in the video? And...

Short answer: No. You cannot use SQL Server & the SA account to retrieve the Windows 2003 Server Administrator account password.

You can, however, overwrite or reset the Administrator with a...

If you have administrative access to the Windows server SQL Server is installed on do this:

SQL Server sa account password lost

Login to the SQL Server computer as the Administrator of...