Importing SQL data into another SQL database

[BrimReap]

My situation:

I want to copy down the tables and data from our "Live" SQL server to our local copy of the database.

My problem:

We don't have sys admin privileges on our "Live Server". When I use the SQL import/export wizard the data will copy over correctly but not the table structures (i.e default values, etc.). Then I tried selecting the "Copy objects and data between SQL Server databases" in the import wizard and that worked. My problem is that the owner of the tables i import is different from the owner of my local tables. My local system can only find and read db tables with the owner dbo.

My question:

How can I get it to read tables with a different owner?

 

[tlbroadbent]

You need a login on the remote server with appropriate permissions. The Sys Admin must either give permissions to your login or provide another login with permissions. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.

 

[BrimReap]

Terry,

If i get the appropriate permissions from the sys admin, will it let me copy the database down exactly?

Why won't my local database read tables of another owner?

 

[tlbroadbent]

If the local user is not granted permission to a table, it will not be able to view the table. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.