Problem with Outlook - Can't Select text in the content area

Recently, I've faced an issue with Microsoft Outlook and started searching for the solution. For god's sake, I got a very good solution from the below URL.

It may be useful for my blog readers too.

 http://social.technet.microsoft.com/Forums/en/office2010/thread/4c8780f5-bbb9-449d-a1fb-2ab668fcceb3

1.            Exit Outlook.

2.            Go to Start > Control Panel, click or double-click Mail.

Mail appears in different Control Panel locations depending upon the version of the Microsoft Windows operating system, Control Panel view selected, and whether a 32- or 64-bit operating system or version of Outlook is installed.

The easiest way to locate Mail is to open Control Panel in Windows, and then in the Search box at the top of window, type Mail. In Control Panel for Windows XP, type Mail in the Address box.

 Note    The Mail icon appears after Outlook starts for the first time.

The title bar of the Mail Setup dialog box contains the name of the current profile. To select a different existing profile, click Show Profiles, select the profile name, and then click Properties.

3.            Click Show Profiles. Choose Prompt for a profile to be used.

4.            Click Add.

5.            Type a name for the profile, and then click OK.

6.            Start Outlook, and choose this new profile. Create a new message and send to yourself in this profile.

Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech
http://www.facebook.com/KaaShivInfoTech

function is not a recognized built-in function name - Error - Fix

Usually, functions are created to incorporate re-usability features. 

In the below query, we are trying to create a function which will return a string and this comes under "User defined function returning scalar values or scalar user defined function"

create function VenkatFunction()
returns varchar(100)
as 
begin 

  return 'VenkatSample'
  end 

With encryption is an option to restrict other to view or modify the user defined functions.


create function VenkatFunction()
returns varchar(100)
with encryption
as 
begin 

  return 'VenkatSample'
  end 
  
To access the function, you can use 
  select   VenkatFunction()

Oops, it will thrown an error indicating "function is not a recognized built-in function name "

Solution:  you need to use schema name in the front of the function to overcome this error.

You need to use  select dbo.VenkatFunction()

Cheers,
Venkatesan Prabu .J
http://kaashivinfotech.com/
http://www.facebook.com/KaaShivInfoTech