I keep getting this error when trying to update a large text field. I understand that you can not use the normal insert or update with larger blocks when using ntext, text, and image fields.
Script: Error #-2147217887 [Microsoft][ODBC SQL Server Driver]String data, right truncation
I found...
I have a script that creates database, tables, and stored procedures, populates tables, creates login/user.
The script creates the database, tables, stored procedures, inserts data, and creates login/user. ok no errors.
The login/user acts like it doesn't have permissions.
So I drop the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.