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 tried 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?

I have had this problem, but not while uploading do a web server. What I did is create scripts from my source machine, then I ran the scripts on my destination machine.

If you can run scripts on your web server, you can try this.
By the way, if you had trouble with views and sps, chances are you need to make sure your triggers were uploaded as well.

Sal