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 |
|
flukebuzzsaw
Starting Member
13 Posts |
 Posted - 2005-05-06 : 20:01:21
|
| I had copied my db data from a production box to a dev box. By doing this I could update and delete but not insert to the data. I then set all the tables primary keys and set those keys as identity seeds with an increment of one. Now nothing displays and query analyser registers the below error when trying to run a select statementServer: Msg 208, Level 16, State 1, Line 1Invalid object name 'tn_results'.Hints |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-05-07 : 00:18:07
|
quote:
Now nothing displays
Nothing displays where???quote:
Server: Msg 208, Level 16, State 1, Line 1Invalid object name 'tn_results'.
And when you run: SELECT * FROM sysobjects WHERE name = 'tn_results' does it show anything???MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-05-07 : 01:22:16
|
| Make sure you are at the correct database. Otherwise, useSelect * from yourdbname..tn_results.MadhivananFailing to plan is Planning to fail |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-05-07 : 09:46:54
|
| if Derrick's: >>And when you run: SELECT * FROM sysobjects WHERE name = 'tn_results' <<shows your table, check who the owner is.(sp_help on the table will show owner name)select * from <db>.<owner>.tn_resultsif you want to change the owner back to dbo, use sp_changeobjectowner.Be One with the OptimizerTG |
|
|
|
|
|
|
Invalid object name