select * from v_R_User where len(givenName0) > 255 OR len(sn0) > 255 OR len(Network_Operating_System0) > 255 OR len(physicalDeliveryOfficeNam0) > 255 OR len(l0) > 255 OR len(postalCode0) > 32 OR len(department0) > 255 OR len(title0) > 255 OR len(User_Name0) > 255 OR len(mail0) > 255 OR len(manager0) > 255 OR len(distinguished_Name0) > 255 OR len(Full_User_Name0) > 255 OR len(Name0) > 255 OR len(Unique_User_Name0) > 255 OR len(Windows_NT_Domain0) > 255 OR len(company0) > 255 OR len(DisplayName0) > 255
select * from v_RA_User_UserOUName where len(User_OU_Name0) > 512
String or binary data would be truncated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at AppPortal.Business.SqlService.ExecuteSQL(SqlConnection connection, String sql, List`1 parameters) at AppPortal.Business.Common.ImportDeploymentResources.ImportCMUsers(Boolean isCM12)
ALTER TABLE [WD_User] ALTER COLUMN [PostalCode] nvarchar(40)
Oct 19, 2018 05:21 PM