>I am accessing SQL Server data using VFP8 remote views.
>
>1. When I add a record to a SQL Server table, how can I get the PK value (the value in Identity colum) without updating the table?>
>2. How do you "pack" SQL Server table. I have been adding and deleting many records in a few tables (I am just learning). Does SQL Server automatically pack tables?You don't. Sql Server handles this stuff internaly.
>3. Is there a way to reset the Identity column back to 0, after deleting all records?The TRUNCATE TABLE command will reset Identity column. If for some reason you cannot use it, take a look at DBCC CHECKIDENT in BOL.
--sb--