Would like to know when was last backed up Database?

-- List of all Backup of data
SELECT Database_Name, CONVERT( SmallDateTime , MAX(Backup_Finish_Date)) as Last_Backup, DATEDIFF(d, MAX(Backup_Finish_Date), Getdate()) as Days_Since_LastFROM MSDB.dbo.BackupSetWHERE Type = 'd'GROUP BY Database_NameORDER BY 3 DESC
-- Find the backup of Transaction Log files
SELECT Database_Name, CONVERT( SmallDateTime , MAX(Backup_Finish_Date)) as Last_Backup, DATEDIFF(d, MAX(Backup_Finish_Date), Getdate()) as Days_Since_LastFROM MSDB.dbo.BackupSetWHERE Type = 'l'GROUP BY Database_NameORDER BY 3 DESC

ILMerge : Merge multiple .NET assemblies into a single .NET assembly

There is need of merging multiple assemblies into the single assembly. Micorosoft have ILMerge which supports for .NET assemblies.

ILMerge need set of assemblies as a input to merge them into a single assembly.
You can download the tool from microsoft URL...

http://www.microsoft.com/downloads/details.aspx?familyid=22914587-b4ad-4eae-87cf-b14ae6a939b0&displaylang=en

Foolowing is the overview from above URL:
The first assembly in the list of input assemblies is the primary assembly. When the primary assembly is an executable, then the target assembly is created as an executable with the same entry point as the primary assembly. Also, if the primary assembly has a strong name, and a .snk file is provided, then the target assembly is re-signed with the specified key so that it also has a strong name.

ILMerge is packaged as a console application. But all of its functionality is also available programmatically. Note that Visual Studio 2005 does allow one to add an executable as a reference, so you can write a C# client that uses ILMerge as a library.

ILMerge runs in the v2.0 .NET Runtime, but it is also able to merge v1 or v1.1 assemblies. However it can merge PDB files only for v2 assemblies.

Print Button For any Web application..

Switch to HTML View.

In the 'head' section of your code, put:
'SCRIPT Language="Javascript"'
function printthis(){
if (NS) {
window.print() ;
} else {
var WebBrowser = '';
document.body.insertAdjacentHTML('beforeEnd', WebBrowser);
WebBrowser1.ExecWB(6, 2);//Use a 1 vs. a 2 for a prompting dialog box WebBrowser1.outerHTML = "";
}
}
'/script'
In the 'body' section of your code put:
'script Language="Javascript"'
var NS = (navigator.appName == "Netscape");
var VERSION = parseInt(navigator.appVersion);
if (VERSION > 3) {
document.write('

');
}
'/script'
This is working code and applicable at any web application..
Cheers,
D. Nitin

Ruby programmers to get Visual Studio link

The artical by Paul Krill
Developers involved in the Sapphire in Steel project are building the software product, which will be called Ruby in Steel and sold by a soon-to-be-formed company named SapphireSteel Software. Ruby in Steel will plug into Visual Studio to blend the benefits of Microsoft's development environment with Ruby technologies, said Huw Collingbourne, who is involved in documenting Ruby in Steel in the United Kingdom.

Here you will find out some detail information about ruby for visual studio 2005 developer.

IF-Else condition in SQL query

In Expression, you can use the CASE Statements to acieve the IF ELSE IF functionality

CASE WHEN Source1.FIELD1 IS NULL THEN Source2.FIELD1
WHEN Source2.FIELD1 IS NULL THEN Source3.FIELD1
ELSE Source1.FIELD1
END

Hope you can do now.
Regards,
N. Boralkar
India