I have moved over to newid() now and I am successful. I can use the Integer (autoinc) if the view is simple, but when it involves multiple tables, foreign keys etc, I can't make it work. I would be interested in what experience others are having.

Thanks for your help.