How to fix a corrupt USB stick

In windows open a command prompt

start > run > cmd > press enter > type "Chkdsk driveletter: /r" > press enter

Check that it can fix and agree with a Y press enter

The system will now try to repair the data.

back up the data if it can be repaired.

How to turn on pop logging in Exchange 2007

To start Pop logging you would need to follow these instructions

1.go to C:\Program Files\Microsoft\Exchange Server\ClientAccess\PopImap
2.open Microsoft.Exchange.pop3.exe.config with text editor
3.find and then modify protocolLog from false to true.
4.open services.msc
5.restart the pop service

How to turn on imap logging in Exchange 2007

To start IMAP logging you would need to follow these instructions

1.go to C:\Program Files\Microsoft\Exchange Server\ClientAccess\PopImap
2.open Microsoft.Exchange.Imap4.exe.config with text editor
3.find and then modify protocolLog from false to true.
4.open services.msc
5.restart the imap service

pc:browsers

If you have a problem when no browser will allow a page to be seen but all connectivity is ok i.e. ping, nslookup then delete the files in this location


C:\Users\profile\AppData\Local\Temp

PC:Windows:Hotfixes

%windir%\softwaredistribution\download

To clear

net stop wuauserv
rmdir %windir%\softwaredistribution /s /q
net start wuauserv
exit

PC: remote restart

You can remotely restart a machine from the command line by running the following:

start > run > cmd > type shutdown -i

add the machine name, fill in the details and click ok.

Ping the machine to ensure it is going through a reboot cycle.

How to list list object name from ID's

SELECT Object_name(number)
SELECT db_name(number)

How to list all table names for export in SQL server

USE database name
GO
SELECT *
FROM sys.Tables
GO