Using SQL Server 2000

I have the following View
================
SELECT DISTINCT TOP 100 PERCENT Email, FullName
FROM dbo.[AllUnitEmail]
WHERE (Email LIKE '%@%')
ORDER BY FullName
================

There is another view named "dbo.AllUnitEmail"

If I use Query Analyzer to Open this view it is fine.

If I use DTS to do a copy of all objects I get an error on this view
indicating "Invalid Object Name" for dbo.AllUnitEmail

It appears DTS does not like it if a View embeds a reference to another
View?
Has anyone else seen this? Is there a workaround?

--
------------------------------------
Wayne Wengert
wayne (AT) wengert (DOT) org

Script your views and apply them instead.

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

Hi Wayne,

I perform an experiment on my side. I do not found the problem which you
post. The detailed steps which I performed are below:

1. Use Nothwind sample database.
2. Create Two View called VIEWtest1 and Testview2 below:

VIEWtest1:
CREATE VIEW dbo.VIEWtest1
AS
SELECT CustomerID, ContactName
FROM dbo.Customers
~~~~~~~~


VIEWtest2:
CREATE VIEW dbo.VIEWtest2
AS
SELECT ContactName
FROM dbo.VIEWtest1
~~~~~~~~

3. Please select the "Copy objects and data between SQL Server databases"
option in the Specify table copy or query" dialog when you are setting in
the DTS Import/Export Wizard.
a. In the "Select Objects to Copy" dialog, the "Use Default Options" was
checked. Please unchecked that and then clicked "Options" button.
b. "Copy database users and database roles" was checked. Please unchecked
this as well as unchecking "Copy SQL Server logins".
c. Press OK and go ahead.

4. In the "Select Objects to Copy" dialog, the "Copy all objects" was
checked. Please unchecked that and then clicked "Select Objects" button.
Chose the View called Viewtest2. Press Ok and go ahead.

It works on my side. I do not found any error messages. Could you try and
check to see if it works on your side?

Note: In the destination SQL Server, please make sue there are no views
called Viewtest1 and Viewtest2.

Hope it helps. If you have any concerns, please post it directly on the
newsgroup. I will be happy to provide the support service.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.