>If you create a complex sql view manually is there any risk of damaging it by opening it using the modify button on the project manager.

Sometimes t won't even let you open it. There is a replacement for the Veiw Designer, BTW, and works incrediblly well. Check out eView in the Files Section.