Make Creating Primary Keys with an auto incrementing identity easier - by lfoust

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.

Sign in
to vote
ID 340996 Comments
Status Closed Workarounds
Type Suggestion Repros 3
Opened 4/29/2008 10:42:34 AM
Access Restriction Public


Creating an identity column for a table which is an auto incrementing primary key is such a common scenario (I do it on 90% of all the tables I create) that it should be easier to do using Sqm Management Studio. Currently, I have to click the primary key button, then scrooll down in the colum properties below and expand the "Identity Specification" property and change Is Identity to true. This wastes alot of time when you are doing it alot.
Sign in to post a comment.
Posted by Daniel Smith on 5/12/2011 at 1:42 AM
This is quite a disappointing resolution. Hopefully in the next release we will at least get the extensibility features that a large number of people have been pleading for. That way, at least we can extend SSMS ourselves, since clearly the SQL Server team has next to no resources available for SSMS features :-(

Here's the link to the extensibility request if anyone's interested:
Posted by Microsoft on 5/12/2011 at 12:20 AM

We took a look at this bug along with several others recently. Unfortunately, triaging it against other critical bugs, I do not think we would get to investigating this in the near future. However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this resolved.

Thanks for writing in to Microsoft.

Posted by Microsoft on 5/4/2008 at 1:27 AM
Hi lfoust,

Thanks for reporting this usability issue. We will consider facilitating the same in the future release.

Posted by ramos_gocougs on 4/30/2008 at 2:41 PM
Making the ever increasing complexity of these tools less cumbersome to the IT professional should be an important goal and this is 1 good example of "low-hanging fruit" on that tree.