Data truncated

'String or binary data would be truncated.' errors happen when an insert or update query is trying to set more data for a column than the size of that column allows. This shouldn't really ever happen for structured data (entities, field values etc), so if you're seeing it on entity tables then it's probably a bug on whatever module is providing the entity or field that is causing the error.

There is a possibility that you could run into this on cache tables, for example if a piece of rendered content is too large for data column in the cache_render table. It would have to be pretty big though, the data columns in cache tables use the 'blob:big' field type, which maps on to the varbinary(max) SQL Server type and can hold 2^31 - 1 bytes (i.e. 2GB). In this case clearing caches could help but if there's a particular piece of rogue content that's triggering it then that piece of content will need to be fixed.

I recommend you check the Drupal logs to work out the exact queries that are erroring so you can diagnose further, and checking how much storage your tables are using (i.e. in SSMS right click a table -> Properties -> Storage).

I found the problem, issue and everything is now fine.
It has nothing to do with module SqlSrv.