sql 2008 query templates missing after upgrade to sql 2012 ssms - by Ranga1

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 776629 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 1/15/2013 1:23:22 PM
Access Restriction Public


All of the sql 2008 query templates created by me missing, in ssms 2012, see all the new templates from sql 2012.
Sign in to post a comment.
Posted by Gordon Bell on 3/17/2014 at 12:17 PM
You may find your custom 2008 SQL Templates here:

Copy From:
C:\Users\USERID\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates\Sql
C:\Users\USERID\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\Templates\Sql
Posted by Ranga1 on 2/6/2013 at 7:02 AM
To repro this:
create a bunch of query templates in sql 2008 SSMS.

now upgrade to sql 2012 ssms.

From the menu check to see if the query templates create in sql 2008 still shows up!

As an addition, the registered servers also disappear after upgrade from sql 2008 to sql 2012

Posted by Microsoft on 2/5/2013 at 4:27 PM
Hi!, thanks for writing in to Microsoft.

The description you have provided in the bug is unclear. Please provide repro steps for the problem you are seeing to help us triage this bug and we will try & incorporate this request when we revisit this functionality in a future release of SSMS.

Sanjay Nagamangalam, SQL Server Manageability