Solved

How to set 'is identity' to yes for incrementing id when rows of data already exist

Posted on 2011-09-13
3
251 Views
Last Modified: 2012-05-12
I have a table I imported from Access to SQL Server, it didn't recognise that the column named ID was a primary key column, nor that it was an incrementing identity column.

How do I set 'is identity' to yes for incrementing id when rows of data already exist in the table? When I do this in the tables design using SQL Server Express 2008 r2 it says:
'Saving changes not permitted. The changes you have made require the following tables to be dropped and re-created'!! ...it's a lot of tables and a lot of data, so I need a way of doing this quickly and efficiently.

Please help!

Thanks Experts.

/ Tobzzz

0
Comment
Question by:tobzzz
  • 2
3 Comments
 
LVL 25

Accepted Solution

by:
Lee Savidge earned 500 total points
ID: 36528420
Tools -> Options -> Designers -> Table and Database designers -> untick Prevent Saving changes that require table re-creation.
0
 
LVL 11

Author Comment

by:tobzzz
ID: 36528789
Ah fantastic, thank you so much :-)
0
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 36528973
No probs. Its ticked by default in SQL 2008 and it's caught a lot of people by surprise including me :)

Lee
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Query Syntax 17 43
SQL Error - Query 6 42
length of the password hash sha1:64000 to set sql field property. 13 67
Loops and updating in SQL Query 9 55
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question