I used nvarchar(MAX) / sysname datatypes to update audit column [user_updated] - which uses suser_sname() values. Still get this error.

[User_Updated] Column - [nvarchar](max) NULL CONSTRAINT [DF_Employee_Audit_ModifyUser] DEFAULT (suser_sname()),

CREATE TRIGGER...

When I tried to log [system_user/suser_sname() - current user] to audit column(datatype - sysname) using trigger, I get the error 'String or Binary data would be truncated'. I used other...

Yes Phil. Any other way to implement this.

Thanks!

Thanks Phil. Please advise if the following permissions are good enough.

data reader, data writer, Create role for View/Execute permissions on db level (dbo and all user defined schemas).

Thank you!

Can I create just one file for now for a specific file group and create additional files if required in the future? Is this a good approach?

Thanks everyone!

Thanks Jeff. This was not causing a performance issue when the same code was running on 2008.

This particular function is used only in one stored procedure.

Here is the tsql:

--FUNCTION

create Function...

Yes it was done. It's been a while migration was done.

thanks Jeff. We happened to see this issue after sql server was migrated from 2008 to 2014 version.

Thanks Grant/Eric/Steve.

Sql server restart was not made. There is only intermittent TCP errors from clients on DMZ. No errors on clients accessing from internal network.

This script sends multiple email alerts rather than a single email. Can this be fixed?

Thanks. How to perform the migration using the default RS dbs on the new server.