Thursday, 15 August 2013

ssms - Removing all templates from SQL Server Management Studio -



ssms - Removing all templates from SQL Server Management Studio -

so in ssms, template browser has of these preloaded templates never use. i'd rather clear out can start own structure, however, everytime delete them from:

c:\users[user]\appdata\roaming\microsoft\sql server management studio\11.0\templates

and reboot ssms, magically reappear. templates in there more or less worthless me, out of saving query projects or quick templates folder , set them in here organization , ease. there's no settings can find causes behavior wondering if had thought how disable feature.

any help appreciated!

if want remove default templates completely, need delete files , folders under both of next folders:

64-bit sql server:

%programfiles(x86)%\microsoft sql server\110\tools\binn\managementstudio\sqlworkbenchprojectitems\sql c:\users\<user>\appdata\roaming\microsoft\sql server management studio\11.0\templates\sql\

32-bit sql server:

%programfiles%\microsoft sql server\110\tools\binn\managementstudio\sqlworkbenchprojectitems\sql c:\users\<user>\appdata\roaming\microsoft\sql server management studio\11.0\templates\sql\

sql-server-2012 ssms

No comments:

Post a Comment