“CREATE DATABASE permission denied in database 'master'...”

If you have added new user and same will not able to create the database on SQL server 2008 due to "“CREATE DATABASE permission denied in database 'master'...” then follow the steps...

1. Click the Start button, point to All Programs, click Microsoft SQL Server, right-click SQL Server Management Studio, and then click Run as administrator.
2. Connect to an instance of SQL Server.
3. Click Security, right-click Logins, and then click domainname\username.
4. Click to Properties and Select Server Roles
5. Select the sysadmin check box, and then click OK.

Wanted to know list of connection to your SQL database?

Execute the following stored procedure
'sp_who2 active' into Query Analyser
It will return the information with status, login, cpu time, DB Name, Command etc.

HTTP/1.1 400 Bad Request errors

One possibility of the cause is because of the specific IP address. Could you change it to "All Unassigned" and test it again.

This is one of the option to resolve the error.

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.