SSMS Crash

I can reproduce an issue that causes SSMS to crash when selecting the "recommended" join between a table and a sub-select. For example, when typing the ON in the following SQL statement, SQL Assistant pops up a window with the recommended join fields (in this case "n.Loan_stage_ID = vas.loan_stage_id").

SELECT vas.loan_stage_id, vas.Deal, vas.Closed, n.Num AS Notes
FROM dbo.vwAllStages vas
INNER JOIN
(
SELECT n.Loan_stage_ID, COUNT(*) AS Num
FROM dbo.Notes n
WHERE NoteDate > '20100701'
GROUP BY n.Loan_stage_ID
)
AS n
ON n.Loan_stage_ID = vas.loan_stage_id

When I try to highlight the recommendation and press either TAB or ENTER to select it, it isn't insert as you'd expect. I can successfully, type "n." to the the intellisense to pop up and finish the ON myself. The crash occurs when double-clicking the recommended join. SSMS crashes with:

Description:
Stopped working

Problem signature:
Problem Event Name: APPCRASH
Application Name: Ssms.exe
Application Version: 2009.100.1600.1
Application Timestamp: 4bb679e7
Fault Module Name: SqlAssistPrefs.dll
Fault Module Version: 5.1.10.0
Fault Module Timestamp: 4c717385
Exception Code: c0000005
Exception Offset: 00218c56
OS Version: 6.1.7600.2.0.0.256.1
Locale ID: 1033

Would you please post the DDL for Notes and vwAllStages tables? I hope this DDL will allow us to reproduce and fix the issue.

The issue is reproducible on any join with a sub-select regardless of the schema. Pick any table you have and join it to a sub-select of itself and you'll see the problem.

5.1.10 Pro
SSMS

I just found this too. I was going to report it. Mine crashed on the double-click of the recommended join. Enter to select the join failed to insert.

I thought it was from instability after a recent Code Snippet edit, but perhaps not.

Thank you. I was able to reproduce this problem and logged a bug report.

Issue tracking # SA11504