Dear All

I am trying to export the data from the live SQL Server to my local SQL Server, however, I am getting "Failed to copy objects from SQL server to SQL Server".

I managed to export the stored procs by generating a script, and also to export the tables, however they did not have any relationships.

Do you have any idea what I can do?

I am not sure I am understanding what you want to do. Can you not simply do a backup and restore from source to target?

When I tried to back up from the live server to my hard drive, its not allowing me, giving me "Execute Permission Denied on object 'xp_availablemedia', database 'master', owner 'dbo'"

Try backing up the live database to the live server, then copy the backup file to your local computer then restore the file to your local computer.

I solved it

What I did was I created the same owner on my local database and it worked perfectly

Thanks for your help mate

Johann