SQL Query to search by text

In case if the WPSBankDB name is changed and the same has to be changed with SPs in the FrameworkDB. In order to find the SPs for which the WPSBankDB name needs to be changed use the below Query


select a.name from sys.procedures a join syscomments b on a.object_id =b.id

where text like '%wps%'


(OR)

SELECT DISTINCT o.name ,o.xtype  FROM syscomments c INNER JOIN sysobjects o ON c.id=o.id

WHERE c.TEXT LIKE '%cmd%' 

User related Query

Query to reset User if not logged on for long or to retain password if the user is asked to forcibly change the password (Below is the example for user named administrator)

update FRM_USERATTRIBS set USERATTRIBS_USERSTATUS ='A',
MODIFIEDON = getdate(),  USERATTRIBS_WRONG_PWD_ATTEMPT_COUNT=0, USERATTRIBS_LASTLOGGEDON =getdate() where USERATTRIBS_NAME='administrator'

Server Restart Issue After Vlink service is restarted

Below are the steps which needs to be checked for the Server restart issue once the Vlink service is restarted

1.       Open the Vlink.xml file, it will be in the same path Vlink à AutoService folder where hosts.xml is placed

2.       Go to the last four line and ensure that the log path tag line is commented like say (<!--<log_path>c:\Auto Service\Logs</log_path>--> ) or else, mention the path name where vlink log folder path is mentioned

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

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)

Resolution for the Issue "You do not have permission to use bulk load statement"

The SQL user defined in the environment should have the Full Admin privileges (MS SQL server)