THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

John Paul Cook

Windows 7 Problem Steps Recorder

The Windows 7 Problem Steps Recorder is yet another reason to upgrade to Windows 7. It records what the user actually did, not what the user claims to have done. I used it to record the attached session of running an invalid T-SQL query in SSMS. When the recording was made, there was a step I added that’s not completely obvious from the recorded output. Notice that the query I executed was highlighted. I did a Control-C to copy the query into the past buffer. The Control-C event was recorded as User keyboard input in "Microsoft SQL Server Management Studio" [... Ctrl ... Ctrl-C]. The query was pasted into the Comment dialog box (not shown in the output – you’ll see it when you run the tool and select Add Comment), which left a textual version of the query in the record. I recommend using this approach when capturing a session. This provides the person analyzing the report a textual copy of the query instead of just the screen capture version of it.

image

Figure 1. One of the screen captures from the Problem Steps Recorder.

To start the Problem Steps Recorder, type psr in the Search programs and files box to find the psr.exe program. Run the psr.exe program.

image

Figure 2. Finding and running the PSR.

Complete output is in the attached file.

Try it out – it’s very simple to use. Once you use it, I’m sure you’ll  recommend it to others.

Published Saturday, November 21, 2009 4:16 PM by John Paul Cook

Attachment(s): div0.zip

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

About John Paul Cook

John Paul Cook is a Technology Solutions Professional for Microsoft's data platform and works out of Microsoft's Houston office. Prior to joining Microsoft, he was a Microsoft SQL Server MVP. He is experienced in Microsoft SQL Server and Oracle database application design, development, and implementation. He has spoken at many conferences including Microsoft TechEd and the SQL PASS Summit. He has worked in oil and gas, financial, manufacturing, and healthcare industries. John is also a Registered Nurse who graduated from Vanderbilt University with a Master of Science in Nursing Informatics and is an active member of the Sigma Theta Tau nursing honor society. He volunteers as a nurse at safety net clinics. Contributing author to SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement