Archive for December, 2008

Atom 1.0 Vs RSS Feed

December 21, 2008 Leave a comment


The name Atom applies to a pair of related standards. The Atom Syndication Format is an XML language used for web feeds, while the Atom Publishing Protocol (AtomPub or APP) is a simple HTTP-based protocol for creating and updating web resources.

Web feeds allow software programs to check for updates published on a web site. To provide a web feed, a site owner may use specialized software (such as a content management system) that publishes a list (or "feed") of recent articles or content in a standardized, machine-readable format. The feed can then be downloaded by web sites that syndicate content from the feed, or by feed reader programs that allow Internet users to subscribe to feeds and view their content.

A feed contains entries, which may be headlines, full-text articles, excerpts, summaries, and/or links to content on a web site, along with various metadata.

The Atom format was developed as an alternative to RSS. Ben Trott was one of the advocates of the new format that became Atom. He believed that RSS had problems that ought to be fixed. Since RSS was frozen, and in any case had to remain backward compatible, there could be advantages in doing a fresh design.

Proponents of the new format formed the IETF Atom Publishing Format and Protocol Workgroup. The Atom syndication format was published as an IETF "proposed standard" in RFC 4287, and the Atom Publishing Protocol was published as RFC 5023.

Categories: Miscellaneous

Search for string in the entire database

December 4, 2008 Leave a comment

This is the query which searches for string in the entire DB.
Provide 2 inputs as DB name and Search string.
This query takes more time, but will sure get you the results.
You can customize the search criteria…
Use [Database_Name]
declare @SearchChar varchar(8000)
Set @SearchChar = ‘Search_Text’ — Like ‘yuva%’, ’11/11/2006′
declare @CMDMain varchar(8000), @CMDMainCount varchar(8000),@CMDJoin varchar(8000)
declare @ColumnName varchar(100),@TableName varchar(100)
declare dbTable cursor for
Distinct b.Name as TableName
sysobjects b
b.type=’u’ and b.Name <> ‘dtproperties’
order by
open dbTable
fetch next from dbTable into @TableName
declare db cursor for
c.Name as ColumnName
sysobjects b,
syscolumns c
WHERE = and
b.type=’u’ and b.Name = @TableName
order by
open db
fetch next from db into @ColumnName
set @CMDMain = ‘SELECT ‘ + char(39) + @TableName + char(39) + ‘ as TableName,’+
‘ [‘+ @TableName + ‘].* FROM [‘ + @TableName + ‘]’+
set @CMDMainCount = ‘SELECT Count(*) FROM [‘ + @TableName + ‘] Where ‘
Set @CMDJoin = ”
set @CMDJoin = @CMDJoin + ‘Convert(varchar(5000),[‘ +@ColumnName + ‘]) like ‘ + char(39) + @SearchChar + char(39) + ‘ OR ‘
fetch next from db into @ColumnName
close db
deallocate db
Set @CMDMainCount = ‘If (‘+ @CMDMainCount + Left(@CMDJoin, len(@CMDJoin) – 3)+ ‘) > 0 Begin ‘
Set @CMDMain = @CMDMainCount + @CMDMain + Left(@CMDJoin, len(@CMDJoin) – 3)
Set @CMDMain = @CMDMain + ‘ End ‘
Print @CMDMain
exec (@CMDMain)
fetch next from dbTable into @TableName
close dbTable
deallocate dbTable



Categories: SQL and .NET Blog

Hyperlink not working in outlook

December 4, 2008 Leave a comment


"This operation has been cancelled due to restrictions in effect on this computer."

A very common question in the Microsoft public newsgroups goes something like this:

When clicking on a hyperlink in an e-mail, I get this Message : "This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator." I get this message every time that I attempt to use the hyperlink. I am the administrator on this stand alone computer. How do I deactivate this feature so that I activate hyperlinks ?

This is not an Outlook error. The most common cause is a corrupt registry key in Internet Explorer 6. The registry key found at
is either damaged or corrupt.

To fix it, try  resetting Web settings in Internet Explorer. If this does not resolve the issue, you’ll need to import the registry key from another computer.

Reset Web Settings

To Reset Web settings

  1. Open  Internet Explorer.
  2. On the Tools menu, click Internet Options.
  3. Click the Programs tab, and then click the Reset Web Settings button.
  4. Under Internet programs, verify that the correct e-mail program is selected.
  5. Click to select the Internet Explorer should check to see whether it is the default browser check box.
  6. Click Apply, and then click OK.

If you receive a message when Internet Explorer starts telling you that IE is not currently your default browser, click Yes to make it your default.

Import the Registry Key

When resetting the web settings doesn’t help, you’ll need to recreate the corrupt key. The easiest way to do this is by exporting the key from another computer.

To save exporting it from another computer, right click here to download a registry key exported from my computer. Choose Save target as and change the file extension from txt to reg and double click on it to run it.

If you prefer to use a key from a computer you have access to, follow the instructions in You receive an error message when you click a hyperlink in Outlook.

Set Program Access in Control Panel

Windows XP and Vista allow you to control program defaults through Control Panel, Add and Remove Programs, Set Program Access and Defaults. If the above methods fail, use this method to set the default browser.

Other Causes

There are several other causes of this error. In most cases, they do not affect hyperlinks in Outlook. If you found this page searching for the error message, check out the following pages. Note that if you receive this error on a computer at work, you should contact your administrator, they may want access to applications restricted for security reasons.

You receive the message when:

· Using Outlook 2002 SP3

· Trying to run a program

· Saving a document (Windows 2000)

· Accessing file open dialog

· Starting Windows Explorer

More Information

You receive an error message when you click a hyperlink in Outlook


Categories: Miscellaneous

Updates in Vista SP2

December 3, 2008 Leave a comment


Hardware support

•SP2 contains Blue tooth 2.1 feature pack supporting the most recent specification for Blue tooth technology
•Ability to record data on Blu-Ray media,
•Adds Windows Connect Now (WCN) Wi-Fi Configuration to Windows Vista SP2,
•exFAT file system now supports UTC timestamps, which enables correct file synchronization across time zones.
•SP2 provides support for new form factors, such as ICCD/CCID.  new form factor support –example USB form factor as opposed to PCMCIA).
•Support for the new VIA 64-bit CPU


•SP2 includes all previously released security updates, and builds on the proven security benefits of Windows Vista
•Secure Development Lifecycle process updates, where we identify the root cause of each security bulletin and improve our internal tools to eliminate code patterns that could lead to future vulnerabilities
•SP2 addresses previously released reliability updates, as well as addressing crashes, caused by Microsoft code,  discovered since the launch of SP1


•Resume performance when Wi-Fi connection is no longer available after resume from sleep
•Inclusion of Windows Search 4 for improved indexing performance,  improved relevancy in search, broader indexing scenario inclusion, as well as new Group Policy integration for Windows Search,
•Improvements to the RSS feeds sidebar gadget to improve update performance and responsiveness

Application Compatibility

•It is our goal that applications that run on the Windows Vista Operating System today and are written using public APIs will continue to work as designed on Windows Vista SP2.
•Previously released Application Compatibility updates are included in Windows Vista SP2.
•Spysweeper and ZoneAlarm now working with POP3 email accounts

Administration and Support Improvements

•Customers installing .net framework 3.5 service pack 1 will notice shorter download and installation times with Vista service pack 2 or Windows 2008 service pack 2 already installed,
•Service Pack Clean up tool (Compcln.exe): This tool helps restore the hard disk space by permanently deleting the previous versions of the files (RTM & SP1) that are being serviced by Service Pack 2.
•Single installer for both Vista & Server 2008
•Ability to detect an incompatible driver and block service pack installation or warn users of any loss of functionality
•Better error handling and providing more descriptive error messages where possible
•Better manageability through logging in system event log
•Componentization for Serviceability of the installer

Some Specific Fixes/Additions Include:

•Inclusion of Hyper-V
•Event logging support in SPC
•DNS Server now listens over ISATAP address
•Fixes DRM issues from WMP upgrades
•Windows Vista Feature Pack for Wireless
•Reduction of resources required for sidebar gadgets
•Improved power settings for WS08


Categories: Miscellaneous

Fine experience with Nisha

December 3, 2008 Leave a comment


Nisha the devastating flood in Chennai on Nov 28 – 30.


The auto drowned, picture from balcony

Opposite house drowned


Our flats ground floor and an eagle taking rest in the sun shade

Oh. My bike and my moms pep and the car in the parking arena.

Me went for buying bread.

The electricity supply has also been cut for 4 long days.

Finally Nisha gave me a wonderful experience I have never met.

Categories: Miscellaneous