SQL Server Date Formats

There are several date formats available in the SQL like the following few formats

• mm/dd/yy
• mm/dd/yyyy
• dd.mon.yyy

for complete list of the SQL date fromats use the this link Date Formats.

Download .dll or .exe files from IIS server.

If try to download he exe or dll file from the IIS server, you will get 404 file error. But this is incorrect settings in the IIS.

Why:
IIS Manager >> Website/VD >> Properties >> Home Directory >> Application Settings

Execute permissions set to "Scripts and Executables" in IIS.
 
Resolution:
IIS Manager >> Website/VD >> Properties >> Home Directory >> Application Settings

Set Execute permissions to "Scripts only" in IIS.