hello,

I have developed a site using ASP & SQL Server.
My problem is to load the databse on to my hosting server.
My hosting server people say "use enterprise manager to create tables etc" they have given me an ip address where my database is located.
I have SQl server 7.0 & enterprise manager installed on my pc(windows 2000 professional). plz tell me how to create tables on the hosting server using my sql server enterprise manager.

Right click on the server group in the manager and use the "register new server" wizard. You'll need to know the name of the server and have rights to logon.

--

Joe

thanks...I did that but getting version error
I have version 7.0 and hosting company has version 2000 . is there no other way to resolve it other than upgrading

You will have to load the client tools for 2000 on your local machine. You can create two separate instances of SQL 7.0 and SQL 2000 but you are better off just using SQL 2000.