Advertisement

07.15.2008 at 11:21AM PDT, ID: 23567099
[x]
Attachment Details

Can I reset identity seed after deleting all records from a table to start at 1 again?

Asked by kdschool in dBase, MS SQL Server, SQL Server 2005

Tags: SQL server 2005, Microsoft

I have a field in an sql table called Id_Record.  It' integer , identity seed=yes, increment 1 and identity seed=1.  I have to remove all the test records and want to start the next entry at 1.  Is there a way to do this without messing up my table.Start Free Trial
[+][-]07.15.2008 at 11:24AM PDT, ID: 22009475

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.15.2008 at 11:25AM PDT, ID: 22009483

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.15.2008 at 11:27AM PDT, ID: 22009501

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.15.2008 at 11:33AM PDT, ID: 22009564

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.15.2008 at 11:33AM PDT, ID: 22009575

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: dBase, MS SQL Server, SQL Server 2005
Tags: SQL server 2005, Microsoft
Sign Up Now!
Solution Provided By: Rrooter
Participating Experts: 3
Solution Grade: A
 
 
[+][-]07.15.2008 at 11:37AM PDT, ID: 22009631

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.15.2008 at 12:03PM PDT, ID: 22009926

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.15.2008 at 12:12PM PDT, ID: 22010023

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628