Increase SQL Name Length

Though probably not officially supported and a bit of a hassle, this can be done directly in the backed database. The NAME field in the CON_SQL_NAME table allows up to 100 characters. Be advised, this may alter the appearance or layout of forms in DPA. Also restarting, this is most likely NOT supported.

- In DPA, identify the applicable Hash you want to rename. Keep the Hash handy.

- In DPA, give the Hash number a unique name

- In the repository database, update the CON_SQL_NAME table for specific the Hash. For example in a repository database hosted on SQL Server:

UPDATE csn

SET

csn.NAME = '<<unique name longer than 30 characters>>'

FROM

dbo.CON_SQL_NAME AS csn

WHERE

csn.HASH = <<hash from DPA>>

- Refresh the applicable page in DPA, you will see the longer than 30 character name