SQL Server INSERT with SELECT IDENTITY

I would create a Stored Procedure in SQL Server that handles the inserting of records. Then call the Stored Procedure (pub.db:call) from wM passing whatever parameters.

Hope this helps.

Frank