Auto increment primary key in SQL Server Management Studio 2012

0 votes
How can I make a SQL Server database table's primary key automatically increment? I searched the forum but couldn't find a way to accomplish this.

Despite looking through the properties, I couldn't find a choice. I read a solution that said to go to the Identity specification property, set it to yes, and set the Identity increment to 1. However, that area is greyed out, and I am unable to convert the no to yes.

I'm sure there's an easy method to do this, but I can't seem to locate it.
Sep 2 in Database by Kithuzzz
• 12,240 points
37 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Database

0 votes
0 answers

How to install SQL Server Management Studio 2012 (SSMS) Express?

I just set up SQL Server 2012 ...READ MORE

Sep 2 in Database by Kithuzzz
• 12,240 points
10 views
0 votes
0 answers

Rename database name in sql server management studio 2014

The database I use is called "ip ...READ MORE

Sep 3 in Database by Kithuzzz
• 12,240 points
32 views
0 votes
1 answer

Auto Increment in SQL

Auto increment keyword allows the user to ...READ MORE

answered Sep 28, 2018 in Database by DataKing99
• 8,240 points
200 views
0 votes
1 answer

Reorder or reset auto increment primary key

To reset the IDs of my User ...READ MORE

answered Oct 4, 2019 in Database by Daric
• 500 points
1,694 views
0 votes
0 answers

how to use sql server management studio

Jan 31 in Database by Neha
• 8,920 points
31 views
0 votes
1 answer

How can I define a composite primary key in SQL?

A primary key is unique and it ...READ MORE

answered Feb 21 in Database by Vaani
• 7,020 points
307 views
0 votes
0 answers

No process is on the other end of the pipe (SQL Server 2012)

I've got this error: A connection was successfully ...READ MORE

Aug 18 in Database by Kithuzzz
• 12,240 points
21 views
0 votes
0 answers

SQL Server Configuration Manager not found

I cannot locate the SQL Server Configuration ...READ MORE

Aug 22 in Database by Kithuzzz
• 12,240 points
31 views
0 votes
0 answers

No backupset selected to be restored SQL Server 2012

I have a filestream-enabled SQL Server 2012 ...READ MORE

Aug 28 in Database by Kithuzzz
• 12,240 points
43 views
0 votes
0 answers

How can I use LTRIM/RTRIM to search and replace leading/trailing spaces?

I'm attempting to remove leading and trailing ...READ MORE

Sep 8 in Database by Kithuzzz
• 12,240 points
25 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP