Once again many thanks.

Interesting...

Does this mean I'm going to have to use a cursor for this operation, one way or another?

Perfect Andy. That's exactly what I need.

Thanks Jayeth too.

This really is the premier SQL site!

Just need to add a coalesce to handle tables that don't have an id column.

Thanks Andy.

That may be of use to me but I need a way of linking the value in the id column of the table to the table name. Hope this...

anybody?

Data definitely in the correct database. When setting up new installs where no migration is taking place we still need the SSMA extension pack and SYSDb to perform the...

Thanks for response.

We still have many SYSDB dependencies in the application SQL profiler tells me this, also removing user's rights from SYSDB causes the application to fall over in a...

thank so much for this Deb. I'v been struggling with this for days.