>However, when I attempt to discover the primary key field which is a uniqueidentifer type, and insert a new record into it, I keep getting this error from SQL Server telling me that the temporary table does not exist.

There are two types of temporary tables. Local temporary tables are scoped to the connection that created them. When the connection is closed, the temporary table will be dropped. Global temporary tables are available to all connections but will be droppped when the connection that created it is closed.

Also, temporary tables created within stored procedures will automatically be dropped with the stored procedures completes execution.

-Mike