C:\>cscript C:\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>NET STOP W3SVC /y & NET START W3SVC
Microsoft OLE DB Provider for ODBC Drivers error ’80004005′
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
Run C:\Windows\SysWOW64\odbcad32.exe to setup DSN
Restore & Backup IIS 7
> %windir%\system32\inetsrv\appcmd.exe add backup “My Backup Name”
to restore that backup, run this command:
> %windir%\system32\inetsrv\appcmd.exe restore backup “My Backup Name”
to delete a backup, run this command:
> %windir%\system32\inetsrv\appcmd.exe delete backup “My Backup Name”
This is for when you restore a database and want to hook the users in the new database to the users with the same name in the SQL Server
login to the db as SA
exec sp_change_users_login 'Auto_Fix', 'UserName'
response.ContentType = “application/vnd.ms-excel”
response.AddHeader “content-disposition”, “inline; filename=” & FileName
Abyss Web Server is a compact web server available for Windows, Mac OS X, Linux, and FreeBSD operating systems.
Despite its small footprint, it supports HTTP/1.1, secure SSL/TLS connections (HTTPS), dynamic content generation through CGI/FastCGI scripts, ISAPI extensions, native ASP.NET support, Server Side Includes (SSI), custom error pages, password protection, IP address control, anti-leeching, and bandwidth throttling.
It also features an automatic antihacking system as well as a multilingual remote web management interface that makes its configuration as easy as browsing a web site.
I developed some complicated reports for my company lately, and the query can be slow up the 10 seconds. using with nolock or readpast really do the trick.
ex: reading only commited rows
select * from some table with(readpast)