"Table does not exist" after moving database to another server 1

[cceng]

I just finished moving 4 databases to another server. We have an application that does some manipulation of the data in these databases. When we run this application it comes back with an error "Tabel does not exist.....invalid object name DBA.UDEF"

I am guessing this has to do with the links when this database was moved. Any suggestions on how to fix this.

I am about as much of a newbie as you can be to SQL.

Thanks!

 

[tlbroadbent]

Actually, the output shows that the default database for the login is master. If the datbase context is not changed, the login will not be able to find the table. That is why I asked about the default database. Use the following script to change the default database of the login. Then see if the application will work.

EXEC sp_defaultdb 'dba', 'tman'

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[cceng]

WOW.....


That did it. Like I have said before this is the best forum I have used. You guys are great!

Thanks for helping a newbie like me!