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 |
chiragvm
Yak Posting Veteran
65 Posts |
Posted - 2006-09-11 : 05:48:21
|
hello friendsi want to change the owner name of table in my databasedatabase name = corporettable owner = corporeti want to change table ownretable owner = dbo |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-11 : 05:49:43
|
sp_changeobjectownerChanges the owner of an object in the current database.Syntaxsp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner'Peter LarssonHelsingborg, Sweden |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-09-11 : 06:19:45
|
Also in 2005 you could try ALTER SCHEMA .. TRANSFER-------Moo. :) |
|
|
chiragvm
Yak Posting Veteran
65 Posts |
Posted - 2006-09-11 : 06:34:08
|
please discuss briffly i don't understood i am new in sql quote: Originally posted by Peso sp_changeobjectownerChanges the owner of an object in the current database.Syntaxsp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner'Peter LarssonHelsingborg, Sweden
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-09-11 : 06:37:13
|
Look for sp_changeobjectowner In SQL Server Book online, there you will find the pretty good description on the Stored procedure.Chirag |
|
|
|
|
|