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 |
|
mbevon
Starting Member
41 Posts |
 Posted - 2002-07-02 : 09:11:02
|
| How could i change the owner of the table from John to DBO.thanks |
|
|
macka
Posting Yak Master
162 Posts |
Posted - 2002-07-02 : 09:12:23
|
| sp_changeobjectowner 'tablename','dbo'macka. |
 |
|
|
mbevon
Starting Member
41 Posts |
Posted - 2002-07-02 : 09:31:06
|
| Where and how do i run this code? |
|
|
|
macka
Posting Yak Master
162 Posts |
Posted - 2002-07-02 : 09:53:30
|
| From within Query Analyser.If you have Enterprise Manager open then goto Tools - Query Analyser.Paste this code into the main window and press F5.macka. |
|
|
|
mbevon
Starting Member
41 Posts |
Posted - 2002-07-02 : 10:00:46
|
| Thank YOu MAckaAMrlon |
|
|
|
|
|
|
Table Owner