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 |
|
maramor
Starting Member
18 Posts |
 Posted - 2009-03-09 : 23:55:24
|
| OK, there has to me something i am missing, a setting somewhere. Perhaps this is security related.if i run SELECT * FROM TABLE i get a cant find object.if i run SELECT * FROM SCHEMA.TABLE everything works.problem is applications are sending requests without schema. they are using the first type and not the second. these used to work. but we are moving or recreating database and i am getting this. so it has to be something with the setup. I have not done anything i can think of during installation that i dont do on any other machines. blank databases where created via script and not gui, logins, and everything likewise. another was a restore.user is a dbo of the database, default set to database and default for the back the schema was set to the correct one as default (not dbo). blank database is dbo.any ideas?Thanks,Matt |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-10 : 08:18:00
|
| Make that schema as default schema for user or role. |
 |
|
|
maramor
Starting Member
18 Posts |
Posted - 2009-03-10 : 11:43:54
|
| The Restored Database has the schema as default.The Blank is dbo and should be.Thanks,Matt |
|
|
|
maramor
Starting Member
18 Posts |
Posted - 2009-03-10 : 15:16:36
|
| Not sure exacly how but the blank database is now working. Seems the restore is working as well at least form the client, SELECT still does not, but thats probly my logged in user. Thinks for your help. one of the things i did was change the database owner to sa.another thing i did was reset multi authentication.did a fresh restore of the database because my changes may have bugged it.Thanks,Matt |
|
|
|
maramor
Starting Member
18 Posts |
Posted - 2009-03-12 : 10:22:38
|
| Just a recap... I think the multi authentication setting must have not set correctly during install.Thanks for your help....Thanks,Matt |
|
|
|
|
|
|
Select Satement strangness