use dbname
EXEC sp_changeobjectowner 'oldowner.tblToChange', 'newowner'
Note: The default owner is dbo.
Wednesday, December 10, 2008
Changing ownership of a table (object) in SQL Server
Subscribe to:
Post Comments (Atom)
Links
Labels
- SQL (8)
- ASP.Net (3)
- IIS (3)
- JavaScript (3)
- CSS (2)
- Master Pages (2)
- SQL Management Studio (2)
- Stored Procedures (2)
- 301 Redirect (1)
- AJAX (1)
- AJAX Extenders (1)
- APIs (1)
- ASP.Net 1.1 (1)
- ArrayList (1)
- Binding (1)
- DataList (1)
- Dates (1)
- Fieldsets (1)
- Good Practices (1)
- Google (1)
- ItemIndex (1)
- MIME Types (1)
- MySQL (1)
- PHP (1)
- Page Title (1)
- SEO (1)
- Tips (1)
- UrlRewriter.net (1)
- WhiteSpace (1)
- XML (1)
- alphanumeric (1)
- parse (1)
0 comments:
Post a Comment