SQL Studio - Retrieving Metadata

[mpalmer]

When I connect with SQL Studio it retrieves the table names from my database, but not the table metadata. It's not until I add a table to a query that SQL Studio then loads the metadata. So, every time I add a table more metadata is loaded and I have to wait. I've used other competing products that load all metadata upon the initial connection.

How can SQL Studio be configured to load all metadata at once rather than table-by-table?

Thanks!

[alexa]

You could specify the default database in the 'Database' drop-down menu on the 'General' tab of the Database Connection Properties dialog box (right-click the connection in Database Explorer and select 'Modify Connection...' from the popup menu).

[mpalmer]

Thanks! That seems to do the trick :)

[alexa]

Thank you for the reply.

Please let us know if any questions arise.