Re: You are not the owner specified for the object 'INFORMATION_SCHEMA'...
- From: "Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx>
- Date: Thu, 9 Jul 2009 07:46:03 +0200
I created the procedure master.dbo.Table_Estimated_Rows, but am now
trying to change ownership from "dbo" to "INFORMATION_SCHEMA".
Why? INFORMATION_SCHEMA is reserved and should not be used for anything else but what is already in there. That is why MS has these checks to prohibit you from creating stuff in there. Also, you seem to be confusing owner and schema (which were the same thing in 2000, but are separate things as of 2005).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Eric" <ericbragas@xxxxxxxxx> wrote in message news:a3e36600-807f-4250-aff7-2b328eed022a@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I created the procedure master.dbo.Table_Estimated_Rows, but am now
trying to change ownership from "dbo" to "INFORMATION_SCHEMA". When
trying to execute the following statement, I get the following error.
I'm following advice from a SQL Server Central article (http://
preview.tinyurl.com/mmhcm2) on creating utility procedures, but it
doesn't tell how to resolve this error.
What do I need to do in order for the statement to execute
successfully?
EXEC sp_ChangeObjectOwner 'TABLE_ESTIMATED_ROWS', 'INFORMATION_SCHEMA'
gets the following error:
Msg 2710, Level 16, State 1, Line 1
You are not the owner specified for the object 'INFORMATION_SCHEMA' in
this statement (CREATE, ALTER, TRUNCATE, UPDATE STATISTICS or BULK
INSERT).
.
- References:
- Prev by Date: Re: coping rows
- Next by Date: Re: making database
- Previous by thread: Re: You are not the owner specified for the object 'INFORMATION_SCHEMA'...
- Next by thread: eliminate unnecessary joint in the view
- Index(es):
Relevant Pages
|
