Peter,

A thousand thanks! It looks and tests out nicely. I have a few minor issues that I think I can work out.

Jake

Here it is.

Thanks,

Jake

create procedure spGetNextSurrogateKey  @iTableName VARCHAR(30),

    @oNewKey int output

As

   begin transaction

   UPDATE tciSurrogateKey

      SET NextKey = CASE NextKey

                    WHEN 2147483647 THEN 1

                    ELSE NextKey + 1                   

                   ...

Hi Peter,

Thanks for the suggestion, however,  I noticed that you have modified 'exec spGetNextSurrogateKey..' to

'Select dbo.fnGetNextSurrogateKey...' Do I need to create this fn? If I run your script against...

I think I found my issue. I was Installing using 'sa' -SQL security.   'sa' on my laptop did not have a password. So, I run install again using Windows Authentication(assinged a...

I am currently having issues. The install seems to be hanging. It's been running for over an hour. Screen appears frozen at Updating Your System, Spawning Instances.

Thanks,

Jake