Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
djohn
Starting Member
2 Posts |
 Posted - 2008-11-26 : 10:36:59
|
| I have imported my database from SQL server 2005 Standard to Sql server 2008 workgroup and i start getting error of object not found while referring to any table, although the table exist. Its perfectly accessing by using schema name in prefix of table. I have also set default schema of the user accessing it. But its giving the same error. Its perfectly working fine without schema prefix in sql server 2005 with the same settings as in sql 2008. Is there any extra settings to set default schema in sql server 2008. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-26 : 14:12:41
|
| Did you make that schema your default schema or does it exists in 2008? |
 |
|
|
|
|
|
Default Schema - Object Not Found