If you're using SQL Server 2000, you could construct an XML document containing the master and detail information and pass the whole thing to a stored procedure.

-Mike

>Anyone know if it’s possible to get the value for an SQL server identify field before a transaction is completed.
>
>Basically I want to add a record to a table, get its PK value which is assigned in SQL server. Then add to some other tables and if everything goes well, commit the transaction to all tables.
>
>Thanks,