Hi Ninja's_RGR'us

Thanks for your reply.

This method does work when to remove a lock I require to kill SP process.

SQL Server throw below error:

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '.'.

Thanks a lot.

Yes sure.

You can create a SQL job by using Enterprise Manager, schedule the job to run on daily basis and write following SQL stsement in Command text box of job...

I think you can try like:

Update

set f1= Rtrim(ltrim(f1))

Or