Thank you for the links 🙂 will these sort of statements be able to cope with instances with many databases, 100's... each one containing information of over 1000 people?...

Hi,

UPDATE t1

SET HomePostCode = t2.HomePostCode

FROM ...

I think I have worked it out trying something else, need to test it fully.

UPDATE t1

SET ...

Hi Willem,

Just to say thank you for all the help, I've managed to complete the transfer - had to do a few more statements on top of this but...

Would that be set in the original statement?

Both are the same datatype but the original NOTEs has a length of 500, the new NOTEs is only 60...

When you enter...

No - just found out they are completely different :/

I'm just sorting it out now, but because of the way the software using the database works I got to...

Hi Willem,

I did have a little scout around the net but kept getting problems 🙁

Thank you for your suggestion it appears to have worked, but I'm getting an...

Not sure if it should be, I'm thinking so. I don't want anything with the table owner dbo... I can't see it under tables of the database but wasn't...

Hi Everyone,

Thank you for all the posts...

I have ran

SELECT 'DROP TABLE ' + s.name + '.' + t.name

FROM sys.tables t INNER JOIN sys.schemas s on t.schema_id =...

Hi Guys,

Thanks for the help so far...

Gail, If I run the statement I get a list of all the tables I want to drop 😀

Nitin, My SQL skills are...