Hi,

Using SMO to gather information on various SQL servers. The following code snippet takes *significantly* longer to complete when run against a SQL2005 Express server compared to a SQL2000 server:

Server srv = new Server("xxx")
foreach (Database db in  srv.Databases)
{
    if (! db.IsSystemObject)
       //do something
}

Accessing the 'db.IsSystemOject' property is slow and seems to requery the server if it's SQL2005; the SQL2000 response if virtually instantaneous. Any way of improving the performance?
Regards,
Viv