人生是一场不能存盘的RPG,我只能尽量多搞几个Screenshot

When I try to use “New Query” in MS Sql Server Managemnet Studio, an error pop up:
Cannot find template file for the new query (’C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\SQL\SQLFile.sql’).

I check this file on other guy’s machine, and found this file is an empty sql file.
So, I create it on my machine and fix the error.

I think I mistakenly deleted it by a disk cleaning tool name fastcleaner because this file with 0 byte size.

1.sfc.exe /purgecache

2.Delete %windir%\$ntuninstallq311889$

3.Delete %windir%\driver cache\i386\driver.cab文件

4.清理C:\Documents and Settings\ 各个user目录下的 application data, My documents, Local Settings目录.
All users\Application Data\Microsoft Help 很大,但不能删
User\Local Settings\Temp 很值得一删.

5.%windir%\Installer也可以清理一下

在装了 vs2005 sp1 之后,遭遇错误
Server Application Unavailable

The web application you are attempting to access on this web server is currently unavailable.
Please hit the “Refresh” button in your web browser to retry your request.
在产看了Eventlog(Application)之后,看到:

aspnet_wp.exe could not be launched because the username and/or password supplied in the
processModel section of the config file are invalid.

aspnet_wp.exe could not be started. The error code for the failure is 80004005.

这两个错误成对出现,由此怀疑 ASPNET 这个帐号的设置有问题.
经过一番折腾,得出解决方案:
1. 删除ASPNET帐号,
2. 为了保险,运行 aspnet_regiis -u, 此过程并不能删除ASPNET帐号,实在有些令人不解
3. 运行 aspnet_regiis -i, 重新安装ASP.net, 此过程会生成ASPNET帐号.
4. 运行 iisreset