19 August 2014

how to set file upload size in web.config

<configuration>
  <system.web>
    <httpRuntime maxRequestLength="1024" />
  </system.web>
</configuration>

14 August 2014

How to uninstall SQL Server 2008 from Windows 7

To Remove SQL Server 2008 from Windows 7, do the following steps
1. Go to Control Panel | Program | Uninstall Programs |Microsoft SQL Server 2008 R2 (64-bit) | and click on Uninstall
Uninstall SQL Server 2008 from Windows

2. You will get option to Add/Repair and Remove SQL Server 2008 . Click Remove
Remove/uninstall SQL 2008 Server
3.  Once Setup Support Rules completed, click OK  
Setup support rules to uninstall SQL Server 2008

4. Select Instance to remove
Select the instance of SQL Server to remove. To remove Management Tools and Shared Features only, Select
Remove Shared Features only and then click next.
Select Instance to remove SQL Server 2008

5. Select the features to remove
The SQL Server Features on this computer are shown below. To remove a feature, select the checkbox next to the feature name
Select Features to Uninstall SQL 2008 Server
6.  Click next to Removal Rules and your system is ready to Remove SQL Server 2008
Ready to Uninstall SQL 2008 Server
7. Removal of SQL Server 2008 R2 from Windows 7 computer
Removal of SQL Server 2008 R2

8.  Complete: Your SQL Server 2008 R2 Removal Completed Successfully.

your-slq-server-2008-r2-removal-completed-successfully

13 August 2014

When was the last successful backup in sqlserver?

Just right click on the Database and click on properties on the sql management studio.

http://adidotnettotal.blogspot.in/2014/08/when-was-last-successful-backup-in.html


On top of window the last full backup completion time and log backup completion time is shown.This is the simplest way of finding the success of a daily backup without even typing a command.

Run a program automatically when Windows starts

If you always open the same programs after starting your computer, such as a web browser or an e‑mail program, you might find it convenient to have them start automatically when you start Windows. Programs or shortcuts placed in the Startup folder will run whenever Windows starts.
  1. Click the Start button Picture of the Start button , click All Programs, right-click the Startup folder, and then click Open.
  2. Open the location that contains the item you want to create a shortcut to.
  3. Right-click the item, and then click Create Shortcut. The new shortcut appears in the same location as the original item.
  4. Drag the shortcut into the Startup folder.
The next time you start Windows, the program will run automatically.

11 August 2014

How to give password to the Word file?



Step 1: File -> Prepare -> Encrypt Document.
Step 2: Enter password and click on OK .

Step 3: Save the file.