Sql Server: Get all tables containing column with a specified name

A little helper query I came accross, very useful if you want to find all the tables that contain a specific column: SELECT c.name AS ColName, t.name AS TableName FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name LIKE ‘%ColumnName%’   What it basically does is that it will do a join on […]

Providing a File for Download trough a Save As Dialog in ASP.NET

The question of providing a file trough a SaveAs dialog in a web browser appears very often in the forums and QA websites like Stackoverflow. The default action of the web browser when a file is provided is to open it. It automatically determines the file type and opens it inside the browser. An example would be […]

Custom Membership Provider

Custom Membership, Role Providers, Membership User Series. Since these articles and the examples in them are pretty long, it could get pretty cumbersome to have all of them in one go so I split them up in several articles. Here goes the first one. The Custom Membership Provider Implementation There are many times when the MembershipProvider and its underlying database construction aren’t […]