In SQL Server Management Studio, after logging into a remotely hosted database, I right-click on the database, and select 'Script Database As', 'CREATE to', then select 'Clipboard'...
I then get this error:
"Script failed for database xxxx
Could not read metadata, possibly due to insufficient access rights."
Can anyone tell me what permission I need to have assigned to the database user to allow me to do this? (The hosting provider is not sure).
Also, I need to be able to export the data from this database and copy it locally, once I have created the tables using the above script. Are there any specific permissions required to export data?