Updated drivers did not fix it. Changing to varchar(8000) did.


First determine if there are any notes over 8000 characters that will be truncated (not likely unless people are putting images in notes which I think only TC does, which is why this got changed to max anyways)


SELECT * FROM note

WHERE LEN(sznote) > 8000


Then run


ALTER TABLE [dbo].[Note] ALTER COLUMN [szNote] [varchar] (8000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL



I ran it on TaxOfficeTest_GC and tried pulling up notes and it then worked.


I have no idea why it stopped working all of a sudden yesterday. Maybe an Azure SQL update.