|
Home > Archive > MS SQL Server DTS > January 2006 > sql server 2000, inport/export, views & UDF
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sql server 2000, inport/export, views & UDF
|
|
| jsa1981@hotmail.com 2006-01-25, 3:27 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
| |
| vadim.svinkin@gmail.com 2006-01-26, 4:58 pm |
| Break the job into a couple of steps, and create the underlying objects
import underlying objects first.
Vadim.
|
|
|
|
|