Obtaining IDENTITY SEED and IDENTITY INCREMENT values

Obtaining IDENTITY SEED and IDENTITY INCREMENT values

Post by Ym9CIFRheW » Thu, 03 Jun 2004 08:01:05


I am attempting to obtain IDENTITY SEED and INCREMENT values by using the GetOleDbSchemaTable method. I have been unable to find a way to determine that using any of the SchemaGuids. I have resorted to calling SQL Server IDENT_SEED and IDENT_INCR for the table name. Any suggestions

TIA
bo