Hi! I have installed the sql server 2005 2005 ctp and want to work with the sql managment studio. I habe a database with some tables named as username.articles, username.ratings and so on. The username is the schema. I want to rename the username.articles to dbo.articles but habe no idea how to. I can only rename the "article" but have no acces to the username schema prefix. Habe anyone an idea how to rename this schema prefix? Thanks!!
i feel username is owner name for the table articles. U can change the owner by using pre supplied SP in sql 2000. About 2005 have not much idea. In sql 2000 u can use sp_changeobjectowner.
