Monday, May 21, 2012

User login related issues


Below triggers are maintained which needs to be removed and transform to stored procedure instead of firing as trigger


trig_lastlogin
trig_pwd_History
trig_UserDelete
trig_UserProfileHistInsert
trig_XREF_Update
trig_UserProfileHistUpdate


Wednesday, May 16, 2012

Solution to the Issue when processing more than 10 records

Execute the below script to resolve the mentioned issue.

alter table t_import_work alter column ImpWork_Field13 numeric(18,0)