How i check any other emails who list my Gmail account as their recovery email?

 for the username :   click here   enter the recovery address or phone number  , but you need to know the name/s of those accounts ( not the addresses - the name/s )   - a list of any usernames associated with that recovery email address will be sent to the address you provided , or shown on screen , or sent to your phone  ,   or :   ask a friend who you emailed from that address , or locate your original email from gmail when you created that address by searching for subject:"has been created"   , or check your browser  history maybe you used it to log into another site , or check your browser's auto fill options - it may be there   . no other way im afraid    

desc columns in mssql server

MSSQL syntax

exec sp_columns <table_name>;

Example

exec sp_columns employee_details;

Output::

It will show the table_name, column_name etc information.

user_tab_columns in sql server?

Yes!     

For those Oracle X.Xers finding themselves working in the SQL Server 2005/2008 world these days, you'll be happy to know all you need to do is:

1. Open up a new execute query window.

2. Type the following:

use FavoriteDbInstance

SELECT
 table_name,column_name
FROM
 information_schema.columns
WHERE
  column_name LIKE '%whateverYouWant%'

That's it!:-) Your table names with the column name you are searching for should show up!

Passport Application Status

Passport Application Status

If you have applied for an Indian passport, you can check your passport application status here. You will need to enter your 15-letter alphanumeric file number and date of birth below, and click the Get Passport Status button. Passport status is provided by the respective passport office and updated by National Informatics Centre, New Delhi.

Check Passport Status

File Number
Date of Birth	Day 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31   Month 01 January 02 February 03 March 04 April 05 May 06 June 07 July 08 August 09 September 10 October 11 November 12 December   Year 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994 1993 1992 1991 1990 1989 1988 1987 1986 1985 1984 1983 1982 1981 1980 1979 1978 1977 1976 1975 1974 1973 1972 1971 1970 1969 1968 1967 1966 1965 1964 1963 1962 1961 1960 1959 1958 1957 1956 1955 1954 1953 1952 1951 1950 1949 1948 1947 1946 1945 1944 1943 1942 1941 1940 1939 1938 1937 1936 1935 1934 1933 1932 1931 1930 1929 1928 1927 1926 1925 1924 1923 1922 1921

Need help? Email  | Join the Passport Status Community

Regional Passport Offices |  Right to Information (RTI) |  Police Clearance Certificate (PCC)

Disclaimer: This is not a government website, and we are not affiliated with The Ministry of External Affairs, Government of India. The content available on this website is for informational purposes only. We shall not be liable for any errors, inaccuracies or omissions in our content. Users are requested to confirm information with the respective regional passport office (RPO) or passport seva kendra (PSK) before taking any action. For the official website, please visit http://www.passportindia.gov.in.

Passport Status thru SMS

Now passport applicants can get regular alerts and updates about the status of their application right on their mobile phones through SMS service. This is offered to passport applicants as an optional service with effect from November 16, 2013.

An applicant needs to enrol for Passport Seva SMS service at the Passport Seva Kendra (PSK) or the Regional Passport Office (RPO) where he/she applies. The applicant will receive progress status of his/her application, and alerts for pending actions through text messages. Also, the applicant can send a text message at any time to know the current status of his/her application. The enrolment of SMS service is optional. The one time enrolment charge of Rs 30 is not included in the passport application fee.

An applicant needs to select SMS Services while submitting application, and he/she needs to pay the one time enrolment fee at the PSK. An applicant can enrol for SMS service at the time of filling out the application form or uploading the electronic form at the online portal. In case an applicant has already submitted the application form online or has uploaded the electronic form, he/she can enrol for SMS services using Enrol for SMS Services link under Services section after login.

An applicant can track the status of his/her passport application by sending an SMS to 9704100100 in the format STATUS , for example, STATUS GZ1060620484012.

Passport Seva SMS Service: http://passportindia.gov.in/AppOnlineProject/online/PspStaticContent

Passport Status Explained

After you submit your passport application at a Passport Seva Kendra (PSK) or a Regional Passport Office (RPO), you can check your passport application status online. If you applied at a location other than a Passport Seva Kendra (PSK) or a Regional Passport Office (RPO), please ensure that your passport application has been sent to the respective PSK for data entry. Please wait for at least 5 working days after your passport application is sent to a PSK. You will be able to track your passport application status online or through the call centre only after your application is processed by a PSK.

During the life cycle of a passport application, the status changes several times to show the progress of your application. The most common status descriptions are listed below in no particular order. Most of these descriptions are self explanatory.

Status Summary	Status Message
Application submitted	Passport application has been submitted along with applicable fees and supporting documents.
Application under review	Passport application is under review at Passport Seva Kendra. OR Passport application is under review at Regional Passport Office.
Application under review with reason	Your application is under review with Passport Seva Kendra (PSK) where you submitted the application. Please visit the PSK with all relevant documents. OR Your application is under review with Passport Seva Kendra, where you submitted the application for the following reasons: null OR Your application is under review with Passport Seva Kendra, where you submitted the application for the following reasons: Data Entry Modification Required OR Your application is under review with Passport Seva Kendra, where you submitted the application for the following reasons: Document Re-submission Required OR Your application is pending with Passport Seva Kendra for the data entry modification.
Police verification pending	Pending for physical police verification at <police-station-name>, <city-name>. OR Pending for physical police verification at your respective Thana under Commissioner of Police, <city-name>. OR Pending for physical police verification at your respective Thana under DCSC Office, <city-name>. OR Pending for physical police verification at your respective Thana under SP Office, District <district-name>.
Police verification initiated	Police verification (PV) has been initiated and a PV request has been sent to <police-station-name>, <city-name>. Your passport will be dispatched after 'Clear' Police Verification Report is received at Regional Passport Office. You would receive an e-mail/sms once the passport is dispatched. OR Police verification (PV) has been initiated and a PV request has been sent to Commissioner of Police, <city-name>. Your passport will be dispatched after 'Clear' Police Verification Report is received at Regional Passport Office. You would receive an e-mail/sms once the passport is dispatched. OR Police verification (PV) has been initiated and a PV request has been sent to SP Office, <district-name>. Your passport will be dispatched after 'Clear' Police Verification Report is received at Regional Passport Office. You would receive an e-mail/sms once the passport is dispatched. OR Police verification has been initiated and a request has been sent to <police-station-name>, <city-name>. OR Police verification has been initiated and a request has been sent to Commissioner of Police, <city-name>. OR Police verification has been initiated and a request has been sent to SP Office, <district-name>. OR Police verification has been initiated and a request has been sent to SP Office, <district-name>. Your passport will be dispatched after 'Clear' Police Verification Report receipt. You would receive an e-mail/sms once the passport is dispatched. OR Police verification has been initiated on Post PV basis to <police-station-name>, <city-name>. Printing of your passport is in progress at the Passport office.
Police report submitted	Police report has been submitted by <police-station-name>, <city-name> and sent to Commissioner of Police, <district-name> for review. OR Police report has been submitted by Commissioner of Police, <city-name> and passport printing is in progress. OR Police report has been submitted by DCSC Office, <city-name> and passport printing is in progress. OR Police report has been submitted by SP Office, <district-name> and passport printing is in progress. OR Police report has been submitted by SSP Office, <district-name> and passport printing is in progress. OR Police report has been submitted by your respective Police Office and is under processing at Regional Passport Office <rpo-city>. OR Police report has been submitted by your respective Thana and is under review at Additional SP Office, <district-name>. OR Police report has been submitted by your respective Thana and is under review at Commissioner of Police, <district-name>. OR Police report has been submitted by your respective Thana and is under review at Commissioner Office, <district-name>. OR Police report has been submitted by your respective Thana and is under review at SP Office, <district-name>.
Police report under review	Police Verification Report for your passport application is under review at Regional Passport Office. After Police Verification Report is found clear, passport will be dispatched. You would receive an sms/e-mail once the passport is dispatched.
Police report not clear	Police Verification Report is not clear and application is under review at Regional Passport Office.
Passport granted	Passport application has been granted to applicant on <dd/mm/yyyy>. Your application is under processing. You would receive an e-mail/sms once the passport is dispatched.
Passport printed	Your passport has been printed and You would receive an sms/e-mail once the passport is dispatched.
Passport dispatched	Passport <passport-number> has been dispatched on <dd/mm/yyyy> via Speed Post Tracking Number <tracking-number>.
Passport returned undelivered	Passport delivery status as on <dd/mm/yyyy> is 'Returned Undelivered'. Please contact the Regional Passport Office.

Here is a list of status descriptions that are less common than the ones mentioned above.

Status Summary	Status Message
Show cause notice	Adverse PVR SCN possible refusal notification has been dispatched on <dd/mm/yyyy> OR SCN - Others notification has been dispatched on <dd/mm/yyyy>
Applicant reply received	Applicant reply has been received on <dd/mm/yyyy>.
IFC notification dispatched	Initiate File Closure notification has been dispatched on <dd/mm/yyyy>
Objection letter dispatched	Objection Letter notification has been dispatched on <dd/mm/yyyy>
Reminder letter dispatched	Reminder Letter notification has been dispatched on <dd/mm/yyyy>
PCC application forwarded	PCC application has been forwarded to Regional Passport Office (RPO) for further action. Please visit RPO in person along with original documents.
PCC granted	PCC application granted on <dd/mm/yyyy>. Police Verification has been initiated and a request has been sent to SP Office, District <district-name>. After 'Clear' Police Verification Report is received at Regional Passport Office, PCC needs to be collected from the Passport Seva Kendra where you applied. You would receive an e-mail/sms once the PCC is ready for collection.

Remember that the online status of your passport application may not always reflect the current status. Sometimes the status is simply not up-to-date or not entered correctly into the system due to human error.

City Codes of Passport Offices

Passport applications are processed according to the jurisdiction to which an applicant belongs. Each jurisdiction is served by a Regional Passport Office (RPO) located in a prominent city of India. For example, Mumbai and Greater Mumbai, Districts of Aurangabad, Beed, Ratnagiri, Sindhudurg in Maharashtra and the Union Territory of Daman & Silvassa are under the jurisdiction of Regional Passport Office, Mumbai.

The first two letters of a file number consists of a city code. You can find your city code in the tables below.

City	Code
Ahmedabad	AH
Amritsar	AS
Bangalore	BN
Bareilly	BL
Bhopal	BP
Bhubaneshawar	BH
Chandigarh	CH
Chennai	MA
Cochin	CO
Coimbatore	CB
Dehradun	DD
Delhi	DL
Ghaziabad	GZ

City	Code
Goa	GO
Guwahati	GU
Hyderabad	HY
Jaipur	JP
Jalandhar	JA
Jammu	JM
Kolkata	CA
Kozhikode	KO
Lucknow	LK
Madurai	MD
Malappuram	ML
Mumbai	BO
Nagpur	NG

City	Code
Patna	PA
Pune	PN
Raipur	RP
Ranchi	RC
Shimla	SM
Srinagar	SG
Surat	SU
Thane	TH
Trichy	TR
Trivandrum	TV
Vishakapatnam	VS

Regional Passport Offices

A Regional Passport Office (RPO) is a subordinate office of The Ministry of External Affairs under the supervision of the Joint Secretary (CPV), who functions as Chief Passport Officer, The Ministry of External Affairs, Government of India, New Delhi. India is divided into more than 35 jurisdictions each corresponding to an RPO. All RPOs accept submission of fresh and re-issue passport applications and miscellaneous requests like name change, address update, correction etc. Each RPO has its own website to cater to the information needs of the applicants belonging to the jurisdiction.

Information provided through these websites are informative in nature, and should not be construed as a statement of the law.

Passport Tacking Seva Portal

Given the changing demographic profile and economic liberalization, the number of passport seekers has been growing rapidly. Passport offices have strived hard to keep pace. However the existing infrastructure and manpower is not adequate to handle the requirements of Indian citizens.

The Ministry of External Affairs initiated the Passport Seva Portal to facilitate availing passport services online. The website allows you to apply online for a passport or police clearance certificate (PCC). You need to have a user account on the portal. After registering yourself, you can log into your user account and apply for any passport-related service.

The Passport Seva Portal currently provides the following services:

• Online application for fresh passport
• Online application for reissuance of passport
• Online application for police clearance certificate (PCC)
• Online submission of any feedback/grievance

Application can be submitted online in two ways. You can either fill the application form online or you can download the e-form, fill it offline and upload the filled e-form to the website.

Passport Seva Portal: http://www.passportindia.gov.in

Police Clearance Certificate (PCC)

PCC is a certification issued by the concerned police authorities covering the whole period of the applicant's residence in that locality. It also notes whether any time the applicant was arrested, along with the reason for and the nature of each case for which there is an evidence/record.

Why PCC

• Required only for immigrant visa or other non immigrant visa such as K and V
• PCC is required for each visa applicant aged 16 years or older

Validity

A PCC is valid for one year from the date of its issue and it must be valid on the day your visa is issued.

Documents Required

• Valid Passport in original
• Proof of residence
• A set of three completed Personal Particulars Form if the applicant has not stayed at the present address for the last one year
• Application fee of Rs 300 (subject to change in the future)

How to Apply for PCC

http://passportindia.gov.in/AppOnlineProject/online/pccOnlineApp

Emigration Check Not Required (ECNR)

All Indian passports are divided into two categories - Emigration Check Required (ECR) and Emigration Check Not Required (ECNR).

As per the Emigration Act, 1983, certain categories of Indian passport holders require to obtain Emigration Clearance before going to certain countries. In this case, emigration means leaving of India with the intent of taking up employment in a foreign country. ECR is for the safety of Indian citizens due to the legal conditions of other countries and is based on various situations/conditions.

For passports issued before January 2007, no notation in the passport means ECR. For passports issued in or after January 2007, no notation in the passport means ECNR.

Right to Information (RTI)

The Right to Information (RTI) Act, 2005 was enacted by The Government of India and came into effect from October 12, 2005. The RTI act empowers Indian citizens to access information under the control of public authorities in order to promote transparency and accountability in these organisations. The RTI act also provides for appointment of a Chief Public Information Officer (PIO) to deal with requests for information.

Indian passport applicants desiring to obtain information from the Central Passport Organization (CPO) or the Consular, Passport and Visa (CPV) Division of The Ministry of External Affairs, may make an application to the Public Information Officer (PIO) assigned to the concerned Regional Passport Office. You can find complete details of the Right to Information Act at http://righttoinformation.gov.in

Key points aobut RTI to keep in mind:

Applicatoin Format

Make a request to the Chief Public Information Officer/Public Information Officer, preferably in the prescribed application format, in writing or through electronic means.

Application Fee

The RTI application must be accompanied by prescribed application fee drawn in favour of Accounts Officer, The Ministry of External Affairs payable at New Delhi, or the Regional Passport Officer, payable at the place where the application is being submitted.

Additional Fee

In case it is decided to provide the information, the applicant shall be informed of any additional fees required to obtain the information.

Appeal

In case the applicant does not receive a decision within the time specified in the act, or is aggrieved by a decision of the PIO, as the case may be, may within thirty days from the expiry of such period from the receipt of such a decision, prefer an appeal to the Departmental Appellate Authority.

Learn more about Right to Information Act (RTI): http://www.passportindia.gov.in/apponlineproject/pdf/RTI.pdf

Privacy Policy

Your privacy is important to us. This privacy policy outlines the types of personal information we receive and collect when you visit and use PassportStatus.in, and the choices you can make about the way your information is collected and used. We never sell your personal information to third parties.

Log Files

Like many other websites, PassportStatus.in makes use of log files. The log files include information like your IP (internet protocol) address, browser type, ISP (Internet Service Provider), date/time stamp, referring/exit pages, number of clicks, and your movement around the website. Your IP address and other such information are not linked to any information that is personally identifiable.

Cookies and Web Beacons

PassportStatus.in does not use cookies. We do use third party advertisements on PassportStatus.in to support our website. Some of our advertising partners, including Google AdSense, may use technologies such as cookies, JavaScript and web beacons on PassportStatus.in to collect information including your IP address, ISP, browser, and in some cases, whether you have Flash installed. This information is used by our advertising partners to measure the effectiveness of their advertisements and/or to personalize the advertising content that you see.

PassportStatus.in has no access to or control over these cookies that are used by third-party advertisers. You should consult the respective privacy policies of these third-party ad servers for more detailed information on their practices as well as for instructions about how to opt out of certain practices like the use of cookies for interest-based advertising. PassportStatus.in's privacy policy does not apply to, and we cannot control the activities of, such other advertisers or websites.

The DoubleClick Cookie

The DoubleClick cookie is used by Google in the ads served on the websites of its partners, such as websites displaying AdSense ads or participating in Google certified ad networks. Since Google AdSense is our advertising partner, when you visit PassportStatus.in and either view or click on an ad, a cookie may be dropped on your browser.

• Third party vendors, including Google, use cookies to serve ads based on your prior visits, if any, to PassportStatus.in.
• Google's use of the DoubleClick cookie enables it and its partners to serve ads to you based on your visit to PassportStatus.in and/or other websites on the Internet.
• You may opt out of the use of the DoubleClick cookie for interest-based advertising by visiting Ads Settings.

Third Party Websites

We have included on this website links to third party websites for your use and reference. You should be aware that after you input certain information and perform an action on PassportStatus.in, we may redirect you to an appropriate government website to help you find the information you are looking for. We are not responsible for the privacy policies of these websites, and their privacy policies may differ from that of PassportStatus.in.

Browser Settings

You can choose to disable cookies through your browser settings. More detailed information about cookie management with a specific web browser can be found at the browser's respective website. However disabling cookies can affect how you are able to interact with our website as well as other websites. This could include the inability to login to services or programs, such as logging into forums or accounts.

Deleting cookies does not permanently opt you out of an advertising program. Unless you have settings that disallow cookies, the next time you visit a website running advertisements, a new cookie may be added.