Thycotic Community Forum

12/28/2010 11:43:28 AM Nick D Posts: 58	Any way to modify a template to allow more characters in the Notes field? We have a need for this.
	0 • link
12/28/2010 2:32:20 PM Tucker Posts: 87	Hello Nick, I will take allowing larger text files as a feature request. Since we no longer have to support SQL 2000, we are looking into expaining notes to a much larger field. -- Regards, Tucker
	0 • link
12/28/2010 2:38:32 PM Nick D Posts: 58	Thanks. So what is the explanation (so i can inform my team)? Is it that SQL2000 only allows 1991 character in a field?
	0 • link
12/29/2010 6:51:50 AM Tucker Posts: 87	SQL 2000 has a maximum of 8060 Bytes per row. Using NVARCHAR to support Unicode characters and including the salt and encryption the maximum length of the Notes column is 1991 characters. Two potential workarounds until that limitation is updated, is 1) to use multiple notes fields, (ie note 1, note 2, note 3) or 2) upload it as a file attachment. -- Regards, Tucker
	0 • link

---