Day: March 21, 2012

DataBase

Find Processes causing Locks on MS SQL DBs

MS SQL provides a Stored Procedure (SP) named sp_who2 which will show up all the actions going on on the MS SQL DB server as shown below:   You can have a temporary DB created with data from sp_who2 for your further processing as shown below     — check if there is a table already existing with the name — you have choosen for your temp DB, if exists delete it if OBJECT_ID(‘tempdb..#temp_spwho’) > 0 drop table #temp_spwho go — create new table with required fields of sp_who2 create table #temp_spwho (      SPID int not null,      Status […]

Read more
Citrix, Server

RDP connection to Remote Desktop server running Windows Server 2008 R2 may fail with message ‘The Local Security Authority cannot be contacted’.

Error: ————————— Remote Desktop Connection ————————— An authentication error has occurred. The Local Security Authority cannot be contacted Remote computer: <IP-Address/Hostname> ————————— OK   —————————   When attempting to establish a remote desktop connection using RD client (mstsc…. When attempting to establish a remote desktop connection using RD client (mstsc.exe) to a Remote Desktop server which is running Windows Server 2008 R2, you may encounter any of these messages: The connection cannot be completed because the remote computer that was reached is not the one you specified. This could be caused by an outdated entry in the DNS cache. Try using […]

Read more
Self Management

Passport Police Verification Procedure

Every passport applicant applied for the first time will have to get the police verification done.  Once you apply for passport, it will be sent Passport Verification Cell of state Police Department.  One of the police officer will come to your residence and verifies your presence.   Applicant needs to be at the address specified in the application form.  The police will come with your passport application form and other documents to be filled up confirming your presence as specified in the application form.  You need to have one of the residence verification form to be signed at least by […]

Read more