SQL Server 2005 - add table window very slow to appear when creating new view

microsoft.public.sqlserver.tools

4 Jan 2007 9:40 PM

Smitty

Has anybody else ran in to the following problem? If so, have you been
able to correct it?

When you right click on on the Views folder and select new view, the
add table window takes 2 to 4 minutes to appear.

5 Jan 2007 1:41 PM

Aaron Bertrand [SQL Server MVP]

I strongly recommend using the syntax for CREATE VIEW instead of the visual
drag & drop designer. This is not the only limitation of that tool that you
will come across.

Show quote

"Smitty" <rmsmith1***@gmail.com> wrote in message
news:1167946836.592274.39380@42g2000cwt.googlegroups.com...
> Has anybody else ran in to the following problem? If so, have you been
> able to correct it?
>
> When you right click on on the Views folder and select new view, the
> add table window takes 2 to 4 minutes to appear.
>