[SSDT] Provide more "Script As" options in SSOX - by Jamie Thomson

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 780378 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 3/1/2013 5:05:13 AM
Access Restriction Public

Description

SQL Server Object Explorer (SSOX) enables one to connect to a database, right click on a stored-procedure and select:
Script As >
  Create To >
    New Query Windows
    Clipboard
    File
  Alter To >
    New Query Windows
    Clipboard
    File
  Drop To >
    New Query Windows
    Clipboard
    File
  Drop and Create to >
    New Query Windows
    Clipboard
    File

There is an option missing tho:
Script As >
  Execute To >
    New Query Windows
    Clipboard
    File


Similarly, tables should have:
Script As >
  SELECT To >
    New Query Windows
    Clipboard
    File
  INSERT To >
    New Query Windows
    Clipboard
    File
  DELETE To >
    New Query Windows
    Clipboard
    File
  UPDATE To >
    New Query Windows
    Clipboard
    File

I'm sure there are a multitude of other missing "Script As" options. Please rectify this.
Sign in to post a comment.
Posted by Microsoft on 3/4/2013 at 8:32 AM
Thanks for the feedback. We currently don't have support for the added scripting options on our schedule. We've catalogued your request.
Posted by Microsoft on 3/1/2013 at 4:47 PM
Hello Jamie. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)