Wrox Programmer Forums
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 16th, 2003, 09:48 PM
Authorized User
Join Date: Jun 2003
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default Enterprise Manager

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?
Old October 17th, 2003, 08:45 AM
sal sal is offline
Friend of Wrox
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts

This is the fifth


Similar Threads
Thread Thread Starter Forum Replies Last Post
enterprise manager security angelboy C# 2005 5 April 9th, 2007 04:15 PM
Enterprise Manager Frozen??? morpheus SQL Server 2000 1 May 31st, 2004 08:24 PM
Enterprise Manager Problems Jan_Ma ASP.NET 1.0 and 1.1 Basics 3 October 22nd, 2003 07:50 AM
Enterprise Manager Jan_Ma Classic ASP Databases 1 October 17th, 2003 08:44 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.