tag:blogger.com,1999:blog-495177919198719500.post494892428223270275..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: Find the Next Identity Value of Each Table of your SQL Server DatabaseSuprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-495177919198719500.post-75428418968861199552010-07-06T04:48:34.971-07:002010-07-06T04:48:34.971-07:00How to do it if I am using sql 2000?How to do it if I am using sql 2000?Khushboonoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-20009123605231793002010-07-06T00:02:38.057-07:002010-07-06T00:02:38.057-07:00If you dont want to use undocumented procedure and...If you dont want to use undocumented procedure and if the version is later than 2000, you can use<br /><br />select object_name(object_id) as table_name,name as column_name,last_value as current_value from sys.identity_columns<br />order by table_nameMadhivananhttp://beyondrelational.com/blogs/madhivanannoreply@blogger.com