Posted by rod.weir on 03/30/06 11:03

Thanks Erland,

I need to refresh all views because there are some views that have
embedded views within them, using a Select * statement. When the
underlying view changes (new column etc), the parent view does not pick
up the new column in the embedded view that it references.

Using SQL Server 2000. Surely there must be a simple way to trap the
error and skip over it right?

Perhaps just after the following line...

EXEC sp_refreshview @DatabaseObject

....you examine @@Error and ignore or continue in the loop? Sorry, I'm
primarily a VB developer, so this TSQL has got me a little puzzled.

I'll give your website a read. Thanks again.

• Next in forum: Re: Error in Query
• Prev in forum: Re: Full text indexing with Japanese characters problem
• Thread view: Re: I'm sure this is an easy one...Error trap to skip over a "bad" object.

[Reply to this message]