J Wolfgang Goerlich's thoughts on Information Security
Viewing cached credentials, clearing cached credentials, preventing cached credentials

By wolfgang. 26 February 2007 09:04

Microsoft Windows caches domain credentials (usernames and passwords). See Microsoft article KB913485 for details. These credentials are stored on the local computer's registry.

Viewing cached credentials: In the registry, grant your user account full permission to HKEY_LOCAL_MACHINE\Security. By default, only the System account has permission to the Security key. Refresh Regedit (you may need to close and relaunch Regedit.) Then open the key. You can view the cached credentials under HKEY_LOCAL_MACHINE\Security \Cache. Up to ten credentials can be cached, and these are stored in the values NL$1 thru NL$10.
 
Clearing cached credentials: Zeroing out the NL$x binary value will clear the cached credential.

Preventing cached credentials: Deleting the NL$1-NL$10 binary values will prevent credentials from being cached. 

Tags:

Security | Troubleshooting

SQL Server Tip: Bulk load a csv file

By wolfgang. 17 February 2007 10:28

Create your table in SQL 2000 or 2005. The table's columns must match the .csv (comma separated value) columns. Then, from Query Analyzer, execute the following command:

-- Load contents of the csv file into the table.

Bulk
Insert
YourTable
From
'C:\YourDataFile.csv'
With (FieldTerminator = ',', RowTerminator = '\N'
)
Go

Tags:

History

    Log in