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"

VisualWorkBench Exception 3.2.2.2

For the System.TypeInitializationException when you run VisualWorkBench in MC, Register the below dll
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322> regsvr32 MCApproot\bin\SSAPI.DLL

ASP .NET security Vulnerability

"I stumbled upon a ASP .NET Security Vulnerability Patch which is critical y'day and applied to test and Production environments. Please find the reference below

http://weblogs.asp.net/scottgu/archive/2010/09/28/asp-net-security-update-now-available.aspx"

MS SQL Server Query Execution plan - Tweeks

If you have some parameters for a MS SQL server Stored procedure most of the time to be empty, then make sure that you give the empty string check first then the value check in the OR part for ex. ((@FromDate = '' and @ToDate = '') OR (VT.TransactionDate BETWEEN @FromDate AND @ToDate )) will make the execution plan to choose the clustered index of the table, rather than choosing the non-clustered index of the table, if one exists. it would choose the non-clustered index if given like ex. ((VT.TransactionDate BETWEEN @FromDate AND @ToDate) or (@FromDate = '' and @ToDate = ''))

Type in your own language in any site!

To type in your local language in any site using google translitration, check the below link
http://t13n.googlecode.com/svn/trunk/blet/docs/help_hi.html

If you are unable to print from Report server website of SQL Reporting Services 2000, using print button

Apply Hot fix - Security Update for SQL Server Reporting Services 2000 Service Pack 2 (KB970899) from the below location


http://www.microsoft.com/downloads/en/confirmation.aspx?familyId=33554f96-5af7-4683-a537-9db293b67b8d&displayLang=en