Hello Group,

The table with the next unique primary key value is on a remote server that I am linked to. To run a select statement to get the next primary key I would use
SELECT iNextUnique
FROM [Audat].[testcareercenter].[dbo].nsuniq
WHERE tablename = 'Studemo'

How do I get the next unique primary key from with in a stored procedure and after I increment it how do I put the next unique value into the nsuniq table on the remote server.

Thanks
Jim