when i'm trying to run my page i got an error saying invalid object .
I found out that that error crept in because my table is not a dbo table ..
Can someone help me by telling how can i change a table with the database name to dbo table .....
Or should i create all tables ....
if i create a table on the server i get dbo one only...
But if i import tables from local to server then i'm not getting dbo tables...
can someone please help

Log into Enterprise Manager and right click on the table and select properties and change the user to dbo.

When you import your tables make sure that your CREATE statements create the table as:

CREATE TABLE [dbo].[tableName]

Otherwise the user you use to connect to SQL will become the owner, not dbo.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========