Views unseen but can query them

I have run a db copy from one sql server to another.  All the tables came
across fine but I'm a little puzzled on the views.  I can query them but
they don't show up in Enterprise Manager as existing.

Anyone know why or how to make them visible?

--
Thanks

Paul Bergson

On Fri, 29 Jul 2005 14:43:33 -0500, Paul Bergson wrote:

>I have run a db copy from one sql server to another.  All the tables came
>across fine but I'm a little puzzled on the views.  I can query them but
>they don't show up in Enterprise Manager as existing.
>
>Anyone know why or how to make them visible?

Hi Paul,

Have you tried refreshing the views list? Right click on "Views", then
select refresh. (Note that each node - tables, views, procedures, etc
etc) need to be refreshed seperately. Refreshing the views list won't
refresh the tables list as well.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)