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?