sql server 2000, inport/export, views & UDF -
01-25-2006
, 03:16 AM
I am using the import/export wizard to import all the objects from one
database into another.
My problem is that any views that use User Defined Functions are
failing because the view is being created before the UDF.
I have searched for this error, and found the following microsoft
article:
http://support.microsoft.com/kb/300272/en-us
The article says that I should upgrade to the latest service pack. The
problem with this is that I already have the latest service pack When
I run the following:
SELECT @@Version
I get:
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005
23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard
Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Could anyone please help me solve this problem.
Jag |