Circular references, they'll bite you in the a** every time ;)

You'll probably have to rebuild the entire structure a piece at a time.

I say script the whole mess off and rebuild each item before establishing
the dependencies. Once in place, you can establish the dependency for each
item. This should work, though without seeing your actual problem, I cannot
accurately predict the results.

John

-----Original Message-----
From: Dylan Jones
[mailto:mssqldba-ezmlmshield-x60593005.[Email address protected]
Sent: Thursday, October 28, 2004 4:57 PM
To: LazyDBA Discussion
Subject: Views using UDF


Hi folks,

I have a view which calls a UDF that calls a 2nd view which in turn uses
data from the first view. This worked fine until I began to delete the UDF
and recreate it - at which point I get a error regarding binding.

Thanks, Dylan

Get the latest news on SurfControl and our products,
subscribe to our monthly e-newsletter, SurfAdvisory at:
http://www.surfcontrol.com/resources/surfadvisory/surfadvisory_signup.aspx

*********************************************************************
The information in this email is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this
email by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution or any action taken
or omitted to be taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error,
please contact the sender.
*********************************************************************
SurfControl Inc.
5550 Scotts Valley Drive
Scotts Valley, California 95066
831-440-2500


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]

MS Sql Server LazyDBA home page