SQL Express and Templates

SQL Express and Templates

• GMon

  Hi Flavelle,
  
  
  
  Could you file this issue on the MSDN Product Feedback site at http://lab.msdn.microsoft.com/productfeedback/default.aspx
  
  
  
  Mike Wachal
  
  SQL Express
  
  

• SebastienR

  Mike:
  
  Thanks, I know how to physically edit them, but what do they mean, how do they work, can I add items to them that will show up in the dialog (CTRL-SHIFT M), etc That's the type of information that I would like to find.
  
  Many thanks,
  
  Flavelle
  

• Charlie Schreiner

  Mike:
  
  Bug reported as requested.
  
  thanks,
  
  Flavelle
  

• jianshi

  Hi Flavelle,
  
  
  
  Yes, you can modify template as well as delete them and create new ones. This is all available on the context menu inside the Template Explorer. Just right-click on the template you want to modify and click Edit.
  
  
  
  Regards,
  
  Mike
  
  

• cconrad

  I may have found a small bug in SSME:
  
  1. If I edit a template (pick one of the Templates with (New Menu)) and save the changes, the template does look like the one that I saved, but that is not the one that is used when I try to execute the template.
  
  2. If I do a search in Windows XP (use (New Menu) as the search criteria), there are at least two copies:
   - one which is in my Application directory
   - the other is in the C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\Ssmsee Templates\SQL\...
  
  3. It appears that the template that gets actually executed is not the one in my Application directory, but rather the one that is in the main program directory. I would have expected that the one in the Application directory is th one that would get executed.
  
  4. If I directly edit the one that is in the program directory, then the template executes as I would expect.
  
  Regards,
  
  Flavelle
  
• SQL Express and Templates