Database Browser - MSSQL: Timeout expired
Posted: Tue Jun 12, 2012 3:24 am
Software : Primal Studio V3.0.4OS : Windows 7 SP1 x64Powershell Version : V2Hello,I'm getting a problem which i've traced to when using the database browser with large databases with PrimalStudio & PrimalSQL. I'd previously thought this issue had been resolved, but its still happening.When i click on the '+' symbol to the left of the database, after 30 seconds, the following text appears.Query:select pf.TABLE_CATALOG as PK_TABLE_DATABASE, pf.TABLE_SCHEMA as PK_SCHEMA_NAME, pf.TABLE_NAME as PK_TABLE_NAME, pf.COLUMN_NAME as PK_FIELD_NAME, ff.TABLE_CATALOG as FK_TABLE_DATABASE, ff.TABLE_SCHEMA as FK_SCHEMA_NAME, ff.TABLE_NAME as FK_TABLE_NAME, ff.COLUMN_NAME as FK_FIELD_NAME, pf.ORDINAL_POSITION as ORDINAL from INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc, INFORMATION_SCHEMA.KEY_COLUMN_USAGE ff, INFORMATION_SCHEMA.KEY_COLUMN_USAGE pf where (rc.CONSTRAINT_NAME=ff.CONSTRAINT_NAME) and (rc.CONSTRAINT_SCHEMA=ff.CONSTRAINT_SCHEMA) and (rc.CONSTRAINT_CATALOG=ff.CONSTRAINT_CATALOG) and (rc.UNIQUE_CONSTRAINT_NAME=pf.CONSTRAINT_NAME) and (rc.UNIQUE_CONSTRAINT_SCHEMA=pf.CONSTRAINT_SCHEMA) and (rc.UNIQUE_CONSTRAINT_CATALOG=pf.CONSTRAINT_CATALOG) and (ff.ORDINAL_POSITION=pf.ORDINAL_POSITION) order by pf.TABLE_SCHEMA, pf.TABLE_NAME, ff.TABLE_SCHEMA, ff.TABLE_NAME, pf.ORDINAL_POSITIONMSSQL: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.It looks like the command timeout for the above command is set at a default of 30 seconds. For smaller databases this works fine because the query will execute within that period, but for larger ones they do not complete the query in time.