btw- We use Transactional replication with Pull subscriptions

Ben

Don't take this as a solution- it's a thought, but I wonder what others say about this plan...

stop sqlserver and copy the device master.mdl and masterlog.ldf file to another instance.

attach...

This is a messy piece of code- but it might do it for you.

I'm assuming the result you're looking for from the supplied values is

Dementia = 2

resthome =...

here's a method I've used on SQL 2000 (although I haven't tested it in sql2005- it does apply ok)

Hope it helps