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

Sal

I'm new to the MSDE and my guess would be to export your DB from your local machine and import on the site. Most web hosts provide a feature such as "run sql script" or something like that where you can import your entire db from a sql file.

I'm not sure if that works when you have data in your tables. I've always used the import for a sql file for such things as PHP Nuke that was already written and didn't have any data in the tables.

I think you can send the files of your database to your DBA and ask him to attach them.