Welcome to W3Courses
 Like Us on Facebook


Enable or Disable Full Text Indexing with sp_fulltext_database in SQL Server

sp_fulltext_database can be used to enable or disable full text indexing on current database. Only members of the db_owner fixed database role can execute sp_fulltext_database.

In order to enable full text indexing, please execute the following code in the Query Analyzer after replacing NorthWind with your database name:


Disable Right Clicking on Webpage, Images and Photos with JavaScript

Add the following code to the head section of your html document to disable right clicking on your webpage. This way, users wll not be able to right click and save pictures or photographs from your website.

Note: However, users can use other ways to save the photos from your website such as looking at the source code and browsing to the location of the picture and then save it.

<script language=JavaScript>
<!-- //Hide from old Browsers


Enable and Disable Advance Options and Ole Automation Procedures in SQL Server 2005

-- Show Advance Options, 0 = disabled, 1 = enabled
EXEC sp_configure 'show advanced options';

-- Show Ole Automation Procedures, 0 = disabled, 1 = enabled
EXEC sp_configure 'Ole Automation Procedures';

-- Enable the Advance options if they are not already turned on
sp_configure 'show advanced options', 1;


How to Disable Java Automatic Update in Windows 7?

To disable the Java Automatic Update you will have to make the change with Admin Priviledges. 

Find the java control panel javacpl.exe here:

C:\Program Files\Java\jre6\bin\javacpl.exe

Then right click on javacpl.exe and then click Run as Administrator

Uncheck java update, save and then reopen it to check that the setting is sticking.