Changing Table ownership

[pkw25]

Hello

We have a an SQl Server database at work. I have written some of my own queries for it. I wanted to be able to work at home with the same queries by copying the relavant tables to a new Database on my hard drive.
The problem is the tables at work are all owned by user 'scheme' which means scheme is everywhere in the queries.
The copied tables have user 'dbo'. In order for the queries to work at home I have to edit them everytime.
I cant seem to change the owner of these tables to scheme.
I created the user scheme and login and used the sp_changedbowner stored procedure but to no avail. Any help on this matter would be appreciated.

Paraic Walsh

 

[tlbroadbent]

Use sp_changeobjectowner.

exec sp_changeobjectowner 'scheme.tablename','dbo' 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.

 

[pkw25]

Thanks

Your solution worked a dream. You saved me alot of time trying out different SP's

Paraic Walsh