Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alpoor
Starting Member
29 Posts |
 Posted - 2007-02-08 : 17:51:47
|
| Can I change owner of another database table from different database on the same server.Let's say, I have two databases d1 and d2, I am trying to run following from d1. Is it possible? sp_changeobjectowner 'd2.x.table1' 'y' changing ownership 'x' to 'y' on d2 database from d1 database in query analyzerBasically I want to run same script on all databases at one shot istead of logging on to each running the same script |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-09 : 01:43:19
|
| Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78832 |
 |
|
|
|
|
|
sp_changeobjectowner question