Thanks both of you - my set was in the wrong place - and I needed a from.

Cheers will give that a go.

Thanks - unfortunately I don't know the contstraint name - the names have been system defined and are differant across dbs I want to run the code against. Can I...

The default is 0 I think

Thanks - it all togther to one EXEC? This will then allow run refreshView ''View2'' even though it failed on View3?

Sorry spoke to soon - errors out if the views are tried to refresh in the wrong order. - ie if view D is refreshed before B then get an...

Thanks that works perfectly.

Thanks Lowell have got that cursor thru the view names to work - only 1 problem - views which have schemabinding come back as invalid object names - I can...

Thanks Lowell - I'm not to sure I need this solution - and since a beginner at this I don't reall understand what is going on there!

Having had a little...

OK - Ta

Thanks - How does SQL server return the dependencies list if you try and delete the object?

So its psooible in 2005 but not 2000?

Thanks both of you for the solution.