Kishore.P (1/8/2008)
use sp_msforeachtable to drop the identity column in all tables.
Yup... easy to do if no foreign keys... of course, if these IDENTITY columns are being used as the PK for tables, your whole database becomes a useless piece of slag.
C'mon folks! Doesn't anyone else see a problem with this request??? :blink:
--Jeff Moden
Change is inevitable... Change for the better is not.