Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Finding the IdentitySeed and IdentityIncrement properties with ASP

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-12-08 : 09:08:05
Mathew writes "I want to find the values of the identityseed and identityincrement properties from a field that is set as an identity field. I think the only way to do this is through SQL-DMO. I think this can me done through collections. For example: make a SQLServer collection, then a Database collection, a table collection, and then a column collection. From the column collection, you should be able to decide the identityseed and identityincrement values.

How do I do this with asp?

Versions
-SQLServer 7.0
-Windows 2000 Pro

Thanks,

Matt"
   

- Advertisement -