Identity Column

Wrox Programmer Forums

		Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Identity Column

SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

July 7th, 2007, 03:47 AM

mike_remember mike_remember is offline

mike_remember is offline

Friend of Wrox

Join Date: Aug 2004

Posts: 550

Thanks: 0

Thanked 1 Time in 1 Post

Default

Identity Column

Hi

Is there a way to disable Identity column and again enable it using
T-SQL.

Regards
Mike

Don't expect too much, too soon.

__________________
Regards
Mike

Old

July 7th, 2007, 01:32 PM

Jeff Moden Jeff Moden is offline

Jeff Moden is offline

Friend of Wrox

Join Date: Oct 2006

Posts: 475

Thanks: 0

Thanked 9 Times in 9 Posts

Default

Yes... Check Books Online for how to use the following...

SET IDENTITY_INSERT

--Jeff Moden

Old

July 9th, 2007, 08:59 AM

mike_remember mike_remember is offline

mike_remember is offline

Friend of Wrox

Join Date: Aug 2004

Posts: 550

Thanks: 0

Thanked 1 Time in 1 Post

Default

Thanks for the info. jeff, much appreciated...

Regards
Mike

Don't expect too much, too soon.

Old

July 9th, 2007, 07:12 PM

Jeff Moden Jeff Moden is offline

Jeff Moden is offline

Friend of Wrox

Join Date: Oct 2006

Posts: 475

Thanks: 0

Thanked 9 Times in 9 Posts

Default

You bet... thanks for the Feedback.

--Jeff Moden

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
checking column is either identity or not.	g_vamsi_krish	SQL Server 2000	2	March 17th, 2006 12:38 PM
getting identity column from the table	g_vamsi_krish	SQL Server 2000	1	March 15th, 2006 05:05 PM
identity column	rohit_sant	SQL Language	4	June 6th, 2005 08:27 AM
Identity column	jbenson001	SQL Server 2000	5	April 12th, 2005 02:01 PM