Select tableid + '.U_' + aliasid as 'UDF', editsize as 'nvarchar_size'įrom cufd where typeid='A' and editsize>1 (select xtype from systypes where name='nvarchar') Select T2.name + '.' + T3.name as 'UDF', T3.length/2 as 'nvarchar_size' from sysobjects T2 inner join syscolumns T3 on T2.id=T3.id where T2.xtype='U' and T3.xtype in Select T1.UDF, T0.nvarchar_size as 'act_size', T1.nvarchar_size as 'def_size' from ( * 6) UDF definition does not match actuality.*/ Select 1 from CUFD where TableId=T.TableId and FieldID=T.FieldID * 5) UDF valid values are defined for non-existing UDF.*/ Where t0.name=TableID and t1.name='U_'+AliasID)Īnd TableID not in ('BTNT', 'OIBT', 'OSRI', 'SRNT') Select TableID, AliasID from CUFD where not exists (įrom sysobjects t0 inner join syscolumns t1 * 4) UDF is defined but does not exist.*/ Not exists (select 1 from OUTB T1 where +T1.TableName = * 3) UDF is defined on an unregistered UDT.*/ Select from outb where logtable is not null) and xtype='U' Select * from sysobjects where like and name not in

Select 1 from sysobjects where xtype='U' and 2) UDF is not registered.*/ * 1) UDT is defined but does not exist.*/ If an issue is related to UDT & UDF, the queries provided bellow will detect the inconsistencies known.Ģ) UDF is defined on a non-existing table.ģ) UDF is defined on an unregistered UDT.ĥ) UDF valid values are defined for a non-existing UDF.Ħ) UDF definition does not match actuality.ħ) UDF contains extra spaces in field TableID or AliasID in CUFD table. This note provides a few generic queries to detect some common issues about UDT & UDF.

User-Defined Table (UDT) and User-Defined Field (UDF) related issues often have different behaviors.

PasswordGenerator 23.6.13 instaling