>The Developer's Guide advises after upsizing to remove the defaults from the SQL tables that reference the NEWID() function. It doesn't suggest how to implement another way of getting a unique ID from the MM stored procedures.
>
>What would be the best solution to implement the SQL stored procedures for adding records to a SQL table?
>
>
>TIA
>
>Chuck Berry

I don't use MM, but I suppose you could substitute a PK generation function with an IDENTITY field in SQL. Check this out in the SQL BOL.