When using Enterprise Manager to upload tables, views, procedures from my local Web server on my PC, to my Web Host’s MS SQL server the following occurred.

All the tables and procedures were uploaded, but not the views.

I used the DTS Import/Export Wizard, and try all options. With the Copy SQL Server Objects options I got a failed rror for completion. But the tables and view option appeared to work until I noticed the views were always missing on my Web Hosting services server.

Also, I tried the Wizard to copy a whole database from server to server, but got the error message that I need Administrator rights, and don’t know if my Web Hosting service would give me this for this Wizard.

I’m new to using Enterprise Manager. Can anyone tell me what is wrong?

Please do not double post.

Sal