We've noticed that the query below, that appears in the pdobd.ini file (both in PB17 and PB21)
SelectDefault='select y.name, x.text from syscomments x, syscolumns y where x.id = y.cdefault and y.id = OBJECT_ID(''&TableOwner.&TableName'')'
The above query execution takes a long time to complete.
Execution samples were around 5 minutes.
The issue observed on SQL Server 2014.
We've considered that perhaps the
x.id = y.cdefault condition might be incorrect, as the records returned always amounted to zero.
Changing the condition from
x.id = y.cdefault to
x.id = y.id resulted in less than a second execution time.
Although, according to documentation, messing with the ini file is not recommended.
Any advise regarding this issue and maybe how can it be resolved?