Chinthaka's Blog Page

Microsoft has now officially released Service Pack 1 Final ( KB976932 ) for Windows 7 and Windows Server 2008 R2. The RTM of SP1 is available for Free to everyone but validation is required in order to download it. The Service Pack for Windows 7 doesn’t bring major new features to Windows 7 . If you have installed SP1 Release Candidate (RC) build, you need to uninstall it before installing the RTM. Windows 7 and Windows Server 2008 R2 SP1 will help you Keep your PCs supported and up-to-date. Get ongoing updates to the Windows 7 platform. Easily deploy cumulative updates at a single time. Meet your users' demands for greater business mobility. Provide a comprehensive set of virtualization innovations. Provide an easier Service Pack deployment model for better IT efficiency. Download Links Download SP1 32-bit (x86) Download SP1 64-bit (x64)

Microsoft has put an end to all speculation surrounding its upcoming web browser Internet Explorer 9. Today, Microsoft unveiled Internet Explorer 9 beta and it is ready to download via download center. Internet Explorer 9 beta offers offers rock solid performance, elegant UI and much more. Key features of Internet Explorer 9 beta: New elegant UI Private OneBox (combined address bar and search box) New download center Pin web apps to Windows 7 taskbar Improved security Improved performance Tab pages (just like speed dial) You can now download the IE 9 beta from the below mentioned link. Have fun with IE 9!   Download for Windows 7 Download for Windows Vista

Microsoft has released the first beta of its new Security Essential software. The new Security Essential features an updated anti-malware engine which is better at both detecting and removing malware. Microsoft Security Essentials 2.0 Beta is directly integrated with the Firewall and gives users the option to either turn off the firewall or turn it on. Another new feature is the integration with Internet Explorer. This will provide protection against web-based threats. There is also a new Network Inspection System to prevent network-based exploits. However, users of Windows Xp will not be able to enable the Network Inspection System. To download it, go here and login using your Live account. After that you can download the beta (either in 32-bit or 64-bit). The beta is available on a first-come-first-serve basis until an allotted number has been reached. So, go grab yours quickly. It is available only to genuine Windows user and is available only in three languages – Englis...

Here's how you crack the password protected Microsoft Word file: Open the document and do a "Save As..." specifying Rich Text Format (RTF). It'll end up being called something.rtf. Open the RTF file by double-clicking on it. It should look identical to the original Word file. Save the RTF file with a new name as a Microsoft Word format document. Open the new word document and select “Stop Protection” That's all there is to it. You've sidestepped the read-only lock on the file.

Now that the Windows Live Essentials Wave 4 has been available for download, some of you might like to download the offline installer which allows you install Live Essentials without the Internet connection. The Windows Live Essentials offline installer features all applications that come with the normal web setup including Live Messenger, Live Mail, Live Movie Maker, Live Sync, Live Photo Gallery, Live Writer and Live Family Safety. Some screenshot of Windows Live Essentials 2011 Beta Live Essentials VIEW SLIDE SHOW DOWNLOAD ALL   Download Windows Live Essentials Beta Offline ...

I recently installed Visual Studio 2010.when I’m going to open a project which was developed from VS 2010 in VS 2008 I was getting an error. So I thought of finding a way to solve my problem. Here is the solution 1. Open the .sln file corresponding to the Project to be converted with Notepad 2. Locate the following line: Microsoft Visual Studio Solution File, Format Version 11.00 Replace 11.00 with 10.00 3. Locate the following line: # Visual Studio 10 Replace 2010 with 2008 Save the File 4. Delete the .cache files existing in the following paths: obj/debug obj/release 5. Open the project with Visual Studio 2008 6. Build the project with Visual Studio 2008

You create a table of contents by choosing the heading styles — for example, Heading 1, Heading 2, and Heading 3 — that you want to include in the table of contents. Microsoft Office Word searches for headings that match the style that you chose, formats and indents the entry text according to the heading style, and then inserts the table of contents into the document. Microsoft Office Word 2007 provides a gallery of automatic table of contents styles. Mark the table of contents entries, and then click the table of contents style that you want from the gallery of options. Office Word 2007 automatically creates the table of contents from the headings that you marked.   Mark entries for a table of contents Select the heading to which you want to apply a heading style. On the Home tab, in the Styles group, click the style that you want.   Mark individual text entries Select the text that you want to include in your table of contents. On the Refere...

In my previous post I explained how to run a SQL Script using Command prompt. It is bit difficult. So I found a way to run the SQL script using the application. I used it on button click. Here is how I did it. 1.   Create your SQL Script. 2. Add the references below to your C# application using Microsoft.SqlServer.Server; using Microsoft.SqlServer.Management.Smo; using Microsoft.SqlServer.Management.Common; using Microsoft.SqlServer.Management.Sdk.Sfc; 3. Add the path to your SQL Script string Filename = Path .Combine( Environment .GetFolderPath( Environment . SpecialFolder .MyDocuments) + "\\Configuration\\" , "Create_Database.sql" ); 4. Add the code below to read your SQL Script StreamReader StreamReader;           StreamReader = new StreamReader (Filename); string CreateDBQuery = StreamReader.ReadToEnd(); 5. Create a connection with server & Execute Query string tempConnString= "Data Source=(local);Inte...

Continued from previous post “ SQL Script to Create Database ” IF NOT EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID (N ' [dbo].[Product] ' ) AND type in (N 'U' )) BEGIN CREATE TABLE [dbo].[Product](     [ProductID] [int] PRIMARY KEY IDENTITY (1,1) NOT NULL,     [Name] [varchar](50) NULL,     [Description] [varchar](100) NULL,     [Modified] [timestamp] NOT NULL ) END GO SET IDENTITY_INSERT [dbo].[Product] ON INSERT [dbo].[Product] ([ProductID], [Name], [Description]) VALUES (1, N 'Red Bull' , N 'This drink gives you wings.' ) INSERT [dbo].[Product] ([ProductID], [Name], [Description]) VALUES (2, N 'Orange Juice' , N 'This drink goes better with Red Bull.' ) INSERT [dbo].[Product] ([ProductID], [Name], [Description]) VALUES (3, N 'BBQ Chicken' , N 'Yummy chicken for your tummy.' ) INSERT [dbo].[Product] ([ProductI...

USE master GO if exists ( select * from sysdatabases where name =' MyDatabase ')         drop database Chinthaka go DECLARE @device_directory NVARCHAR (520) SELECT @device_directory = SUBSTRING ( filename , 1, CHARINDEX ( N 'master.mdf' , LOWER ( filename )) - 1) FROM master.dbo.sysaltfiles WHERE dbid = 1 AND fileid = 1 EXECUTE (N' CREATE DATABASE MyDatabase   ON PRIMARY (NAME = N' ' MyDatabase ' ', FILENAME = N ' ' ' + @device_directory + N' MyDatabase .mdf' ')   LOG ON (NAME = N' ' MyDatabase _log' ',  FILENAME = N ' ' ' + @device_directory + N' MyDatabase .ldf ' ' ) ' ) go exec sp_dboption ' MyDatabase ','trunc. log on chkpt.','true' exec sp_dboption ' MyDatabase ','select into/bulkcopy','true' GO set quoted_identifier on GO USE [...

Microsoft offers a free tool, the Microsoft SQL Server 2008 Management Studio Express, as a convenient means of managing and editing entries in SQL databases through a GUI. The SQL Server 2008 license comes with the full version of the Management Studio, but the Express version is still very functional for the day-to-day operations. However, finding the stand-alone version of the software is quite a pain. Most people don't need to install a SQL server on their machine, but that is the most promoted means of getting the Management Studio Express. You can download it from here https://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displayLang=en ( 32-bit (168.3 MB) or 64-bit (176.5 MB)) Before you Install: Microsoft .Net Framework 3.5 SP1 Windows Installer 4.5 Windows PowerShell 1.0 How to Install: Once the installer starts, select "Installation" from the left column. The options on the right will change to mat...

Have you encountered the error 'CREATE DATABASE Permission denied in database 'master'' even though you are logged into Windows Vista with administrator privileges. Reason for the error : Windows Vista users that are members of the Windows Administrators group are not automatically granted permission to connect to SQL Server, and they are not automatically granted administrative privileges. Resolution: Grant rights to the administrator. Follow these steps: Step 1: Go to Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration. Step 2: Click on 'Add New Administrator'. Step 3: In the 'SQL Server User Provisioning on Vista' dialog box, look out for the 'Member of the SqlServer SysAdmin role ' in the 'Available Privileges' box. Transfer it to the 'Privileges that will be granted to' box. Click Ok. Note: You will be able to see 'Add New Administrator...