SQL Enterprise Manager - Not very usefull tool for building views

Man do I struggle with Enterprise Manager as a graphical tool for
building views etc.
>
Its flaky and hangs frequenlty so i have to kill it with the task
manager and re open it.
>
You cant debug functions ( or am I missing something)
>
But the worst thing is that it appears to cache the results of views
and doesnt refresh from the source.
>
If I build a view that includes a calculated field using a custom
function, and have another view thats built on the first one, then
change the function to produce a different result, the second view
dosnt show the new value, its shows the old value. I have to cut the
sql statment from the view and then paste it back in and save it on
both views before the data is refreshed correctly.
>
Has anyone else found this??
>
Surely there are some better tools out there to replace Enterprise
Manager for building views and SQL statements graphcally?
>
Cheers
>
Grant

If I build a view that includes a calculated field using a custom
function, and have another view thats built on the first one, then
change the function to produce a different result, the second view
dosnt show the new value, its shows the old value. I have to cut the
sql statment from the view and then paste it back in and save it on
both views before the data is refreshed correctly.
>
Has anyone else found this??
>
Surely there are some better tools out there to replace Enterprise
Manager for building views and SQL statements graphcally?