Do you mean the prefix of the table is db_owner (e.g., db_owner_members, db_owner_topics, etc.)?
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.”
If you or your host specifies that the default schema for the user you are using to connect to the DB is db_owner, the problem will go away.
Shaggy, the prefix in question is defined by SQL Server. In SQL Server 2000 it meant the object (table) owner, in SQL Server 2005 it represents the schema the tables were created in.
thanks for the reply. Ive actually changed all the tables by hand and copied them to dbo tables. the forum works now but has a few other problems have posted them in forum help
Topic Locked
Posted - 04 May 2007 : 10:46:33
