In a way this doesn't really surprise me, it just confirms statements I've made in the past. Microsoft has shown zero loyalty to the outside developers/DBAs/others who have helped...

Might want to tell that to Microsoft ...

Hi Mike,

I see the link to the source is no longer valid 🙁 We are trying to deploy in an environment using a mix of SQL2K through SQL2K8 and...

I'd be curious to see what the expected result is for the 21 count. I use SQL2K and long ago ended up creating my own IsNumeric function because of...

Too bad these views don't exist on SQL2K

My apologies to the group, I had not read through to see that others had already proposed similar solutions, mea culpa ...

From NOT a DBA ...

sounds like what you really need is an Oracle "sequence". I have implemented similar as follows:

CREATE PROCEDURE dbo.nextval @sequence varchar(28) AS

...