dbTalk Databases Forums  

sql server 2000, inport/export, views & UDF

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss sql server 2000, inport/export, views & UDF in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jsa1981@hotmail.com
 
Posts: n/a

Default 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


Reply With Quote
  #2  
Old   
vadim.svinkin@gmail.com
 
Posts: n/a

Default Re: sql server 2000, inport/export, views & UDF - 01-25-2006 , 08:35 AM






Break the job into a couple of steps, and create the underlying objects
import underlying objects first.

Vadim.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.