How to Recover MSSQL from "Suspect Mode" / "Emergency Mode" / "Error 1813"

This article describes the course of actions you should take

1. if your database somehow got "suspect mode" or "emergency mode";
2. if you receive the error 1813 on attaching database

The History Behind 

I've been developing under SQL 7 for a while. Sometimes transaction log grew too large. My usual fix for that problem was:

1. stop the server (on the development machine we do not need any logs), 
2. delete transaction log
3. start the server again
4. after that the server was creating empty 1MB transaction log from scratch

I had been using this technique a lot of times under SQL 7, until sometime I have migrated to MSSQL 2000...

After my transaction log grew too large, I stopped the server, deleted the log file and started the server once again. However this time it did not worked: my database got "suspect". I was not able to read or write from the database. A week of work seemed to be lost... Ouch!...

AnjLab SQLProfiler (SQL Profiler for MSSQL Express Version)

Microsoft SQL Server family includes free Express edition, that is fully functional, however has some disappointing limitations which prevent from using it in development process. One of them is absence of profiling tools, standard SQL profiler is not included. However, now you have an ability to use express edition for tuning your

system, includes free Express edition, that is fully functional, however has some disappointing limitations which prevent from using it in development process. One of them is total absence of profiling tools, standard SQL profiler is not included. However, now you have an ability to use express edition for tuning your system.

Window Enable 1.1

Windows Enabler is a small and simpleprogram that runs on Microsoft Windows. It allows the user to enable disabled windows and controls such as buttons and tick boxes and choose menu options that would normally be disabled.
This is obviously a very dangerous practice if used recklessly but having said that, you'd be surprised at how often it comes in handy.
Windows Enabler has a very simple user interface; it appears as an icon in the system tray and can be turned on and off simply by clicking on it.
Windows Enabler is a very simple utility and does not ship with an install program. The installation process is simple; just copy the two files ("Windows Enabler.exe" and "EnablerDLL.dll") somewhere on your system and run "Windows Enabler.exe" to run the program.
Link download http://www.mediafire.com/?dl3m354d55ml3lj

Hiren's BootCD From USB Flash Drive (USB Pen Drive)

Step 1
Connect USB Pen Drive (1GB or more)
Step 2
Download and Run USB Disk Storage Format USBFormat.zip (34KB)

IISADMPWD virtual directory is not getting created during a default install of IIS?

The IISADMPWD virtual directory allows users to change their account passwords remotely through IIS by means of ASP scripts. IISADMPWD does not come installed as part of a standard Windows Server 2003 IIS install.
To create the IISADMPWD virtual directory, follow these steps: