I have a stored proc in which I want to retur the primary key of an insert statement that the stored proc just ran. How can I do that? ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly