Firstly, Thanks again for your time and help.

OK, spoke to the techies at work today, appparently i had insufficient acces rights.

This is now sorted, can connect to our RS Server and view the database and tables.

I have found the correct DB and tried running the script in your link.

It errors with the following....????

PS: Do you know of a schema/table definitions doc for the RS database

Msg 6850, Level 16, State 1, Line 25

Column name 'TEXT()' contains an invalid XML identifier as required by FOR XML; '('(0x0028) is the first character at fault.