MS SQL Server - Views unseen but can query them

Author

Views unseen but can query them

Paul Bergson

2005-07-29, 8:23 pm

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

Hugo Kornelis

2005-07-29, 8:23 pm

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)

Sponsored Links