>What is a normal time to expand a database to show its elements (LVs,RVs,Connectios,SPs)?
>
>It takes my database 30-40 seconds. Is there a way to speed this up? I have about 170 tables, 20 Local views, 5 connections, 10 Stores Procs.
Is your database on your local drive or a network drive somewhere? And are all the tables local or are they on a network drive somewhere (or tables located in more than one location..?)
ICQ 10556 (ya), 254117