search or reseed identity columns in sqlserver 2008 

//Seach
DBCC CHECKIDENT ('AD_EmailType')   --AD_EmailType : table name

//Change
DBCC CHECKIDENT('AD_EmailType', RESEED,4)

 

posted @ 2013-11-14 14:29  shzy2012  阅读(170)  评论(0)    收藏  举报