SQL Server Date Time Formating

-- To get Time in the format - 9:45AM
select substring(convert(varchar(20),getdate(),100),13,7)

--To Get Date in the format -- 29-Dec-2010
replace(convert(varchar(12),getdate(),106),' ','-')

--To get Date & Time in the format - 29-Dec-2010(1:45PM)
select replace(convert(varchar(12),getdate(),106),' ','-') +'('+ltrim(substring(convert(varchar(20),getdate(),100),13,7))+')'

IIS 6 does not download .exe files & gives file not found error.

There is a setting in IIS that prevents .exe files from being downloaded in browser.

To enable the download of .exe files in IIS 6.0 follow the below steps

1.Navigate to the Website in IIS
2.Right Click and Select Properties
3.Select the Home Directory
4.Look out for Execute Permissions drop down
5.Change it from "Scripts and Executables" to "Scripts Only"