Full text index details using TSQL

-- catalogue details
SELECT name, path, is_default, is_accent_sensitivity_on
FROM sys.fulltext_catalogs

-- full text index details
SELECT object_name(object_id) table_name, change_tracking_state_desc
FROM sys.fulltext_indexes

-- full text index columns details
SELECT distinct ixc.object_id, object_name(ixc.object_id) tblname, col.name, ixc.*
FROM sys.fulltext_index_columns as ixc
INNER JOIN sys.columns as col ON ixc.object_id = col.object_id AND ixc.column_id = col.column_id
ORDER BY col.name

To someone Special........

Rabb kare MANZOOR

Eko GAL asi CHAHIYE.........

Ve Tu AKHAAN SAHMNE hove

Jado DUNEYA cho JAYEAA....

Mera sohna Punjab

Know punjab?????
Punjab, a region in Northern India and the east side of Pakistan, has a long history and rich cultural heritage. The people of the Punjab are called Punjabis and they speak a language called Punjabi. The three main religions in the area are Sikhism, Hinduism, and Islam. The region has been invaded and ruled by many different empires and races, including the Aryans, Persians, Greeks, Egyptians, Afghans, and Mongols. Around the time of the 15th Century, Guru Nanak Dev founded the Sikh religion, which quickly came to prominence in the region, and shortly afterwards, Maharaja Ranjit Singh reformed the Punjab into a secular and powerful state. The 19th Century saw the beginning of British rule, which led to the emergence of several heroic Punjabi freedom fighters. In 1947, at the end of British rule, the Punjab was split between Pakistan and India .

For know about punjabi culture or anything about punjab go to www.punjabonline.com

Sikh Information

Guru Gobind Singh Ji was the Enlightener who dispelled delusion and brought awareness


Being the Guru he is One with God. It is impossible to make an estimate of his greatness as a person, for the Guru is not a person. He is Light. The Guru's glories are infinite, and therefore unfathomable and inexpressible. No one can estimate the Guru's greatness, only pay homage to the Guru by expressing his glories as seen in the play of his phenomenal life.

for more Information click on http://www.info-sikh.com
This site is a guide to Sikhism, its social and spiritual roots, its history,beliefs and philosophy.

Viewing todays hukumnama online

To view todays hukamnama from Shri Darbar Sahib Amritsar go to following web page:

http://sgpc.net/hukumnama/index.asp

The first sikh settler in UK

I was surfing BBC website and I came across an article about first recorded sikh settler in UK.

"The first recorded Sikh settler in Britain was Maharajah Duleep Singh. Duleep Singh was the last ruler of the Sikh kingdom of Punjab.

The Maharajah was dethroned after six years' rule, and exiled to Britain in 1849 at the age of 14, after the Anglo-Sikh wars.

There is a statue to the Maharajah at Butten Island, Thetford, Norfolk, near the Elveden Estate where he lived in Britain. The statue was unveiled by the Prince of Wales in 1999.

Despite the early arrival of the Maharajah, the first Sikh Gurdwara (temple) was not established until 1911, at Putney in London."

Source: http://www.bbc.co.uk/religion/religions/sikhism/history/britishsikhism.shtml