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 |
|
mukta
Starting Member
12 Posts |
 Posted - 2004-04-08 : 03:08:04
|
| HI I am facing a strange problem.While I access the webpage where I select the values from a table called "employee".Now the employee table exits but the owner is not dbo but a userID.How to resolve this problem that I do not have to specify the owner name with the object name ina query?Microsoft OLE DB Provider for SQL Server (0x80040E37)Invalid object name 'employee'./validate_login.inc, line 35 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-08 : 12:04:14
|
| If the owner is not dbo, then you have to specify ownername.objectname if you are not owner. Why not change the owner to dbo since this is the recommended approach?sp_changeobjectownerTara |
 |
|
|
|
|
|
Error 208 n SQL server while accessing a table