Programming

create function getDayOfWeek
    (@date datetime)
returns varchar(10)
as
    begin
        declare @retVal varchar(10)
        select @retVal=
            case datepart(dw,@date)
                when 1 then 'Sun'
                when 2 then 'Mon'
                when 3 then 'Tue'
                when 4 then 'Wed'
                when 5 then 'Thu'
                when 6 then 'Fri'
                when 7 then 'Sat'
            end
        return @retVal
    end

Then you can just call it as any other function in a select (or however you need it):

select dbo.getDayOfWeek(getdate())

USE [dbName]
GO
CREATE TABLE #temp (
table_name sysname ,
row_count INT,
reserved_size VARCHAR(50),
data_size VARCHAR(50),
index_size VARCHAR(50),
unused_size VARCHAR(50))
SET NOCOUNT ON
INSERT #temp
EXEC sp_msforeachtable 'sp_spaceused ''?'''
SELECT a.table_name,
a.row_count,
COUNT(*) AS col_count,
a.data_size
FROM #temp a
INNER JOIN information_schema.columns b
ON a.table_name collate database_default
= b.table_name collate database_default
GROUP BY a.table_name, a.row_count, a.data_size
ORDER BY CAST(REPLACE(a.data_size, ' KB', '') AS integer) DESC
DROP TABLE #temp

Reference articles:

• Tip/Trick: Url Rewriting with ASP.NET by Scott Guthrie – Examines four approaches: 1) Use Request.PathInfo Parameters Instead of QueryStrings; 2) Using an HttpModule to Perform URL Rewriting; 3) Using an HttpModule to Perform Extension-Less URL Rewriting with IIS7; 4) ISAPIRewrite to enable Extension-less URL Rewriting for IIS5 and IIS6; also discusses how to handle ASP.NET postbacks correctly with URL rewriting.

• URL Rewriting by Salman (CSharpFriends) – simple implementation of URL rewriting logic within the Application_BeginRequest() method of the Global.asax file.

• Search Engine Friendly URLs using ASP.NET (C#.NET) by Maziar Aflatoun (The UK Web Design Company) – similar to the above, but regular expression is used to match URLs.

• Rewrite.NET – A URL Rewriting Engine for .NET by Robert Chartier (15Seconds.com). Solution steps:
  • Create the HttpModule to process the web request and rewrite the URL
  • Add the handler in Web.config
  • Create a configuration section in Web.config to define URL mapping rules
  • Add extensibility by creating a rules engine interface
  • Write class or classes to implement rules engine interface
  • Add code to the HttpModule to dynamically load the desired rules from Web.config

• URL Rewriting in ASP.NET by Scott Mitchell (MSDN) – examines how to implement URL rewriting in a HTTP module; also explains how to handle postbacks.

• URL Rewriting with ASP.NET by Richard Birkby (CodeProject) – shows how legacy ASP sites can be upgraded to ASP.NET, while maintaining links from search engines. Solution steps:
  • Create the configuration section in Web.config for defining URL mapping rules
  • Write the configuration section handler class, incorporating the URL rewriting logic
  • Create a call to handler in Global.asax in Application_BeginRequest() method
  • Compile the code and install the rewriter assembly in the Global Assembly Cache (GAC)
  • Configure IIS to map non- .aspx files to the ASP.NET ISAPI extension

Related Resources

• Making Sense of ASP.NET Paths by Rick Strahl
• Fixing Microsoft’s Bugs: URL Rewriting by Jesse Ezell
• Regular Expressions with .NET by Dan Appleman and Daniel Appleman
• UrlRewritingNet.UrlRewrite – an Open Source Component which allows you certainly to rewrite URLs with ASP.NET 2.0.
• Open Source URL Rewriter for .NET / IIS / ASP.NET

Possible Cause:-
         When you install IIS AFTER .NET 2.0 framework, the rights of the ASPNET user had not been set correctly.
Resolution
         Repair (Uninstall if repair does not work for you)  .NET Framework 2.0

Simply run the following from command line to reset the IIS registry settings for aspnet user. Usually framework directory for .Net Framework 2.0 resides under C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

References:-

• http://support.microsoft.com/?kbid=267904 http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=116989&SiteID=1
• http://support.microsoft.com/kb/555583