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 |
|
mbevon
Starting Member
41 Posts |
 Posted - 2002-05-16 : 11:40:11
|
| i'VE THE FOLL QUESTION1. We've a new sql based application in our department, my self and two other are the technical users, if anyone of us process BZ2000(table name), in the query analyser under user table it is shown as the foll: domain\loginname.Bz2000. when i try to run a query from the query analyser i'm getting the following message "Server: Msg 208, Level 16, State 1, Line 1 Invalid object name 'BZ2000'.How could i overcome this problem? |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-05-16 : 11:44:58
|
| Prolly wrong forum for this.. should be in administration.. but something to watch for... at the top of query analyzer you can choose which database your in. It defaults to master. Make sure you select the correct database (it should be just to the right of the play and stop button)If thats not right.. well.. I took my guess ;) |
 |
|
|
mbevon
Starting Member
41 Posts |
Posted - 2002-05-16 : 12:01:42
|
| I'm in the correct database. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-16 : 12:06:46
|
| Probably the BZ2000 table was created by someone other than dbo, in which case you need to precede the table name with the owner name:SELECT * FROM owner.BZ2000I'm lost if that doesn't fix it. If you want, you can use sp_changeobjectowner to change it to dbo, but you need to change all of the currently working references to that table in stored procedures, views, etc. |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2002-05-16 : 12:17:26
|
| If the object owner isn't the issue, check your sort order (case-sensitive)?'Bz2000' will then be different from 'BZ2000' |
|
|
|
|
|
|
Query problems