Folder backup/restore

NTBackup is the backup utility that comes with Windows utility.
Start -> Run -> NTBackup

You can backup your server's system state and any folders/files that you choose.
If you choose full backup, the "archive" bit on each file backed up gets reset. When a file is updated, the archive bit is "set".

This allows each subsequent incremental backup to know which files have been changed, and only those files will be backed up, you end up with everything backed up to a .bak file. You could then store this .bak file somewhere safe.
To restore the files, you can use the same NTBackup utility.

Error while trying to run project: Unable to start debugging on the web server

Resolution:
1. Open IE and go to Tools -> Internet Options -> Security -> Local Intranet -> Custom Level -> User Authentication
check 'Automatic logon with current User & password
2. Go to virtual directory of project and select appropriate ASPNET version.
3. Right click to Project under solution explorer and go to properties, select Configuration settings and go to 'Dubugging' and select 'Enable ASP.NET Debugging' as TRUE

ActiveX control 'xxx' cannot be instantiated because the current thread is not in a single-threaded apartment.

Please use appropriate attribute:
///

/// The main entry point for the application.
///

[STAThread] // !!!!!!!!!!!!!!!
static void Main()
{
Application.Run(new MainForm());
}

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