DBCC CHECKIDENT

Last Post 23 Jun 2009 11:29 AM by g8r. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
g8r
New Member
New Member

--
23 Jun 2009 11:29 AM
Anyone know if it's possible to send the results of DBCC CHECKIDENT ('tablename',NORESEED) to a variable or temp table? I need to get the current seed value. I can't do SELECT MAX(ID) because in some cases the tables are empty and that returns NULL. I can't insert and then delete to get the value either as it would violate compliance. Thanks.


Acceptable Use Policy
---