I have a fairly large SQL Server database, when I use the LLBLGen project designer to create a new project, it times-out on the following query (which taked 35 seconds)...
SELECT db_name() as TABLE_CATALOG, user_name(t_obj.uid) as TABLE_SCHEMA, t_obj.name as TABLE_NAME, col.name as COLUMN_NAME, c_obj.name as CONSTRAINT_NAME FROM sysobjects c_obj, sysobjects t_obj, syscolumns col, master.dbo.spt_values v, sysindexes i WHERE permissions(t_obj.id) != 0 and c_obj.xtype in ('UQ') and t_obj.id = c_obj.parent_obj and t_obj.xtype = 'U' and t_obj.id = col.id and col.name = index_col('[' + user_name(t_obj.uid) + '].[' + t_obj.name + ']', i.indid, v.number) and t_obj.id = i.id and c_obj.name = i.name and v.number > 0 and v.number <= i.keycnt and v.type = 'P' ORDER BY TABLE_SCHEMA ASC, TABLE_NAME ASC, COLUMN_NAME ASC
Any way to increase the connection timeout?
UPDATE:
This issue looks specific to SQL 2005 in 2005 compatability mode.
Thanks
CT