Connectio String .SDE Vs .DBO

Hi. i have a problem.

I want to Update a Database like this GISETS.SDE.CADENA, but it sais that it wants update this GISETS.DBO.CADENA (Database that doesn′t exist).

I use a connection string .sde but it gets a conflict because the reference is for a database .dbo. how can I fix it?

thanks for advance. Sorry for my english.

Fernando.

which version of sql server is this? IF its 2005 then Object is owned by Schema and if its 2000 then the objects are owned by User. So *SDE* here is either schema (2005) or its a User(2000). First check who is the owner of CADENA Table. if the owner is DBO change the FQN (Fully qualified name) GISETS.DBO.CADENA or change the owner ship to SDE schema/user

Madhu

|||

Good Morning Madhu (I′m from Spain).

I Use 2005, and the schema of CADENA table is SDE. In the propierties I can′t see who is the owner of the table, where i can see this? How can I change the FQN and where?

thanks in advance.

Fernando.

|||

In 2005, Schema is the object owner. where as in 2000 user is the object owner. So SDE is the owner of the table. You can't change FQN, what i said what when we refer object , refer it like Database.Schema.TableName. Before changing Schema of table CADENA to DBO , think twice. why because the object may be refered in many place with schema SDE.

To change CADENA table schema from SDE to DBO run following query

ALTER SCHEMA DBO TRANSFER SDE.CADENA

Madhu