This is a difficuilt process to see through as different types of installations usually need their own release processes defined.

What I do is, have every single database object scripted (Tables,...

Standards always seem to be an issue, so define a standard and stick to it...

Oh yes, and learn to avoid cursors with a passion!!

Deon

Thanks and I will consider using GUID's as a next step. The reason behind this is, we use a 6 character prefix to our ID's which is a server, database,...

Thanks Steve

Sequential ID's is not an issue as all ID's are internal to maintain integrity. I am going to try this approach now. Thanks for all your help.

Cheers

Deon

Thanks for the prompt response.

What we are trying to do is minimise calls to the database. I have written an ID retrieval process for the database and the reason behind...