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 |
|
nskatp
Starting Member
8 Posts |
 Posted - 2011-06-01 : 23:22:14
|
| Hi,Hope someone can help.I restored a Database in a new SQL Server, after the restore the application that tries to use the DB is getting an error Invalid Object Name.The user which I use to restore DB is now the owner and from SQL Management Studio I can execute queries with it.Thanks |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-02 : 05:12:41
|
| Is it a permissions problem?How does the application connect? Does the login have a correct mapping to the database and permissions.Does it need anything outside the database?Doesn't the application give any information about what the object is or what it is trying to do? If not where did it come from and can you get it changed - or at least point out to the company that they haven't built it very well.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Invalid object name after restore