Windows

Everything Windows – Windows Server – SQL Server – Windows 10, 8, 7, even XP
MS Office tricks – Registry secrets – Applications – Browsers

How to Reset Win XP Admin Password

2017/06/21
By
Modified: 2017/04/30

There are two ways to reset forgotten Administrator password. Method one – Reset During Repair Reinstall: Use Win XP installation disk Run Recovery (not Recovery Console) Press Shift+F10 during GIU portion of repair / install Run LUSRMGR.MSC to reset any user password to whatever you want During my tests, this method always ended up in freeze  during a late install stage on “Deleting Temp Files” Method Two – Use LUNIX bootable CD: Download free boot CD software from http://pogostick.net/~pnh/ntpasswd/ It might be called Offline Registry Editor, but this utility main purpose is to reset Administrator passwords to blank. Burn a bootable disk (only 4MB) Boot from this CD. Blank Administrator password…

Read more »


Moving Win XP from RAID to RAID Machine

2017/06/18
By
Modified: 2017/04/30

After several days of heavy exhausting battles and sleepless nights, after testing dozens of options, after browsing many proposed Internet solutions, I finally was able to move an old instance of Windows XP on a new machine with new RAID drivers. That happened at 13:23 on December 12, 2010.  I moved Win XP from old RAID machine to a new RAID machine. O boy! I found  a clear and clean way to do this task.  I will also use the same technique to move any Microsoft operating system from a Single drive to a RAID machine.  And this also works great, if you simply switching your PC controller from IDE to…

Read more »

Count Number of Cell with Errors in Excel

2017/06/17
By
Modified: 2017/06/15

This problem occurs, when you have a column with a formula that sometimes returns an error.  That is very typical for all kind of look-up situations .  Let’s say, you have a column E with formula that returns good values and errors.  You need to count how many errors are in that column. Enter formula =SUM(IF(ISERROR(E2:E10),1)) and press Ctrl+Shift+Enter while still in editing mode. You should see two things.  First, your formula turns into {=SUM(IF(ISERROR(E2:E10),1))} with square brackets around it, and second, you got you a correct cells with errors count.  This is it. If you need to count cell without errors, you can use this formula: =SUM(IF( NOT( ISERROR(E2:E10)),1 ))…

Read more »

Update Field Based on a Field in Another Table

2017/06/02
By
Modified: 2017/04/30

This article contains 3 examples: - T-SQL; – MS Access; – AS/400.   This example shows a standard T-SQL syntax tested on MS SQL 2005 server: update P set P.CertMemberLevelID = Z.CertLevelTo from   UPM_MemberPermissionMask P INNER JOIN zzzCertRegistryUpdate Z ON P.MemberID = Z. Cert2ID Here we are updating one filed CertMemberLevelID in table UPM_MemberPermissionMask based on field Cert2ID in table zzzCertRegistryUpdate. This next example was generated using MS Access 2007 syntax: UPDATE CRPDTA_F1201 INNER JOIN CatCode7 ON CRPDTA_F1201.FANUMB = CatCode7.XXNUMB SET CRPDTA_F1201.FAFA7 = [CatCode7].[XXFA7] A field FAFA7 in CRPDTA_F1201 is being updated. Table  CatCode7 contains 2 fields: – ID Link field XXNUMB and – Update values field XXFA7 SQL statement JOINs two…

Read more »

Process **\MCSHIELD.EXE contains signed but untrusted code …

2017/05/25
By
Modified: 2017/04/30
mfehidk-EventID-516

This fix was tested with Windows XP Pro SP3 with Office 2003 SP3 and McAfee AntiVirus Plus. Finally.   Finally I found a solution for this really scary-looking error message that was bugging me since 12/24.  Marry Christmas! Description of a Problem Every time you restart you PC you see a very unpleasant Warning Event ID 516 in your system event log from mfehidk. This is the very last system message before computer reboots or goes to sleep. Process **\MCSHIELD.EXE pid (864) contains signed but untrusted code, but was allowed to perform a privileged operation with a McAfee driver. What is Causing it? It appears that most people (and I join them) …

Read more »

Cisco VPN Client Error 51 – Open Your Firewall

2017/05/23
By
Modified: 2017/04/30
Cisco Error 51

Annoying!  How Annoying! This very simple, very typical error message, but it is so hard to find a quick solution. Symptoms: You are starting a Cisco VPN Client and immediately you are getting this error message: Error 51: Unable to communicate with the VPN subsystem. Please make sure that you have at least one network interface that is currently active and has an IP address and start this application again.     Most of Internet discussions on this error message revolve around MAC OS.  But this error I was able to fix on Windows XP. Quickly – What to Do? Quickly – Open your firewall.  Each firewall solution is different, but…

Read more »

Invisible Files in Windows 7, 8 and 10 Program Files

2017/05/19
By
Modified: 2017/04/30
Program Files in Windows Explorer

Summary First of all – it is not a virus! It is not a bug either. It is a feature, that doesn’t allow legacy applications to write files inside Program Files directory.  This feature allows legacy applications think that they are writing to a system folders. Symptoms You can see your custom files inside one of the Program Files directory folder through your application.  You can open them and view them and modify them..  However, if you open the same directory in Windows Explorer, your files are not there.  You can’t see them, even if your a super administrator of all administrators.  What is the Mystery? You can see your custom…

Read more »

How to Get SQL Table Field Structure?

2017/05/15
By
Modified: 2017/04/30
SQL-2008-R2

Sometimes you need to display or print a SQL table structure. This article provides a SQL statement that allows you to do that. We are using MS SQL 2008 Studio interface.

Read more »

The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database ‘YourDB’, schema ‘dbo’

2017/05/09
By
Modified: 2017/04/30

ASP.NET page returns this erorr: The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database ‘YourDB’, schema ‘dbo’. (1) First try runing this command/wizard: %WinDir%\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe   (2) If this doesn’t work, try this query:  -- Add user ASPNET to DB role USE YourDB GO sp_addrolemember 'aspnet_Membership_FullAccess', 'ASPNET' These steps should resolve your issue.

Read more »

Extremely Slow Windows XP Shutdown – Fixed

2017/05/01
By
Modified: 2017/04/30
WinXP-Slow-Shutdown

Several years I had this problem in one particular instance of Windows XP Professional – an extremely slow shutdown upon clicking on Shutdown button.  For several minutes system would completely freeze, and then Shutdown/Restart dialog box would finally come up. What did I know about the problem.  It was extremely annoying.  It was persistent.  And it was happening only on one  instance of XP, so that excluded the possibility of a faulty hardware. It was so bad, that I came up with a workaround.  I would open up a Task Manager and end one after another svchost.exe processes running under SYSTEM name.  A counter and warning would appear saying that your…

Read more »