Configuration of Broadband and leased line in Switch

FOLLOW THE FOLLOWING STEPS FOR CONFIGURATION OF BROAD BAND MODEM.

01. PING 192.168.1.1(DEFAULT IP ADDRESS OF BROAD BAND MODEM)
02. OPERN YOUR WEB BROWSER TYPE http://192.168.1.1
03. type user name: admin, password: admin.
04. goto advanced setup>WAN
05. click on edit on line containg vpi/vci 0/35.
06. click on next > change the connection type to pppoe
07. click on next > enter username and password and service name.
08. click on next>next> save
09. again advanced setup screen will appears
10. click on save/reboot.

after two minutes.

01. again open the web browser and type 192.168.1.1
02. enter username : admin and password: admin
03. click on device info.
04. note down the primary dns server and secondary dns server.
05. configure the system in which you want broad band as follows

ip address 192.168.1.x
subnet mask 255.255.255.0
default gateway 192.168.1.1
preferred dns server: <enter the value from step 4>
alternate dns server:<enter the value from step 4>


or

ip address 192.168.1.x
subnet mask 255.255.255.0
default gateway 192.168.1.1
preferred dns server: 192.168.1.1

if you dont want borad band in a system then dont configure the default gateway, preferred dns server and alternate dns server in that system.

Corrupted MDF Solution

Corrupted MDF solution

---

Procedure for recover MDF files when the LDF files are not available or corrupted. Detaching and Attaching are not possible normally.

• Copy the original mdf file to a secure place.
• Create a new database with the same name and same .mdf & .ldf file names.
• Stop the SQL Server.
• Replace the Corrupted .mdf with newly created .mdf file and Delete the .ldf file of the Database.
• Restart the SQL Server.
• See in Enterprise Manager the Database is in Suspect Condition.
• Update the sysdatabases to update to Emergency mode. This will not use LOG files in start up

Run the query in Query Analyser using Master Database.

Sp_configure "allow updates", 1
GO
Reconfigure with override
GO
Update sysdatabases set status = 32768 
where name = ‘BadDbName’
GO
Sp_configure "allow updates", 0
GO
Reconfigure with override

GO

• Stop & Restart SQL server. Now the database will be in emergency mode, Check in Enterprise Manager.
• Now execute the undocumented DBCC to create a log file.

DBCC REBUILD_LOG(BadDbname,'c:\BadDbname.ldf') 
-- Undocumented step to create a new log file.
(Replace the BadDbname and log file name based on your requirement)

• Execute :

sp_resetstatus <BadDbname>

• Restart SQL Server. See in Enterprise Manager the Data base is in online. If there is any situation like <DBO Only> Just Detach and attach the mdf in normal process.
• The Currupted Database Mdf file is now repaired and You can browse through the tables. Check for any missing records.

Try it when You are in trouble to attach a mdf file seeing the error message like 

< Server: Msg 5173, Level 16, State 1, Line 1
Cannot associate files with different databases.
Server: Msg 1813, Level 16, State 1, Line 1
Could not open new database 'dbABC'. CREATE DATABASE is aborted.
Log file 'D:\Microsoft SQL Server\MSSQL\Data\dbABC_log.LDF' does not match the primary file. 
It may be from a different database or the log may have been rebuilt previously.>

SOP for Address Proof ID Card in TN.doc

OPERATING AND ACCOUNTING PROCEDURE

1. The application for Proof of Address Card available at all HOs, HSG and LSG Sub Post Offices in Chennai City and Tambaram and also at Anna Road HO and Chennai GPO is now also available at the District Head Quarters of Vellore, Kanchipuram, Tiruvallur, Villupuram and Pondicherry UT at the cost of Rs.10/-. The cost per application will be brought under RETAIL POST on the date of sale.

2. Application duly filled in all respects with the recent stamp size colour photos affixed in the relevant portion of Annexure I & II will be presented at the HO or HGS/LSG Sub Post Office from where the postal articles are being delivered to the applicant. The processing fee for Fresh / Renewal / Duplicate cards of Rs. 240/- (or) Rs.140/- (or) Rs. 90/-(as the case may be) will be collected and credited under RETAIL POST on the date of collection of application.

  Procedure at receiving SO / HO:

The application received at the delivery Post Office will be checked first, the name stamp is impressed on the top of application i.e. Annexure I; a rubber stamp impression ‘FRESH / DUPLICATE / RENEWAL’ should be made on the top of both Annexure I and II and the irrelevant option should be scored out. The relevant fee collected should also be invariably mentioned below it. And then the particulars of application will be entered in a Register, the columns of which will be as shown in Annexure -3 and the application alone will be sent to the concerned PRI (P) for verification.

3. The Annexure-II need not be sent to PRI (P) but to be kept in the office itself.

4. If PRI(P) finds answer to SL No. 11 of the application as ‘YES’, the PRI(P) shall then check with the applicant about the status of proof of address card issued earlier and make appropriate observations on the application. Words such as “DUPLICATE” etc may be written on the application.

5. The PRI (P) will complete the verification within FIVE days and return the verified application immediately to SO or HO. The PRI(P) will take utmost care in verifying the application. He will ensure through all possible means that the applicant is actually residing in the address furnished in the application. Suppose the applicant stays in a FLAT, the association of FLATS or Land Lord of the flat/house is to be enquired and confirmed. Even if the applicant is not able to produce any documentary proof for address, it is enough, if the genuineness of applicant residing in that address is ascertained by him from the Residents Association/ Neighborhood.

6. On receipt of verified application from the PRI(P) by the SO, the application (i.e. Annexure I) and the Annexure-II will be forwarded to the concerned HO for further action.  The verified application received from Sub Offices and the verified applications received from the PRI (P) in respect of HO will be assigned with the SERIAL NUMBER as follows. The abbreviation of HO will be placed first followed by four digit Number assigned Chronologically and Year of Issue. The abbreviation of all 14 HOs issuing this Card are as follows:

Anna Road – ARD	Mylapore  - MYL	Tambaram – TBM
Chennai GPO – GPO	Park Town   – PT	Avadi Camp – AVC
T.Nagar    - TNR	St.Thomas Mount -  STM	Ambattur  - ABT
Vellore – VLR	Kanchipuram – KCM	Tiruvallur – TVR
Villupuram – VLM	Pondicherry - PDY	Chengalpattu – CPT
Tindivanam – TDM	Arakkonam – AKM	Ranipet – RPT
Tiruvannamalai – TVM	Arni - ARN

                                   

           

           

          The Serial No. and the Card no. under item No.9 in Annexure-II and the Serial No. in application will all      be ONE AND THE SAME and the number will be like ARD/0001/2008, MYL/0001/2008, STM/0001/2008 etc.

7. The particulars against Sl.7 to 11 in Annexure-II will be entered by the PA at HO and the Annexure-II duly filled in all respects will be sent to the Card Maker, Shri.Bastin Paul, Southern Regional Manager, UTI Technology Services Ltd., No.45, Justice Bhasheer Ahmed Building, II floor, Second Line Beach, Chennai – 600 001 by service Registered Post.

8. The card prepared in Ultra Silk finish touch quality will be entrusted with the BD Section of Regional Office by the Card Maker for dispatch to the concerned Head Postmaster. On receipt of card from the Regional Office, the PA at HO will immediately enter particulars of all Cards in the Register, retain all Annexure II in HO and return only Annexure I (i.e. Application) and card duly enclosed in a strong cover to the concerned Sub Office, duly invoiced in SO Slip for delivery to the applicant from SO concerned.  The PAs at HO and SOs will contact the applicant over his Telephone/ Mobile number and deliver the card to the applicant under acquittance on his/ her arrival.

9. The Register for issuance of Proof of Address Card will be properly maintained by the PA at HO / SO. Entries will invariably be made in the Register at each and every course of action.

10. When the application tendered at a SO is received back at HO duly verified by the PRI(P), entry will be made in the Register as if it was a fresh case received at HO and the entry under column-6 will be the date on which the application was originally received at SO.

11. On receipt of cards and applications from HO, the PA at SO will contact the applicant over his Telephone / Mobile Number and deliver the card to the applicant under acquittance in the application, on his / her arrival.

12. The undelivered cards will be under the personal custody of Postmaster / Sub Postmaster. At the end of each day, the position of pendency will be noted under the ‘Remarks’ Column of Register under the dated signature of Postmaster / Sub Postmaster.

13. The cost of preparing each card is Rs.19/- only. A consolidated bill for all cards prepared during a month will be furnished by the Card Maker to the Regional office during the first week of following month. The sanction for payment will be issued by the Regional Office with directions to the Card Maker to take payment by cheque at Anna Road HO. The Chief Postmaster, Anna Road HO will effect payment by cheque and charge the amount under “RETAIL POST – Deduct.”

14. The application for issue of Proof of Address Card will be kept in a Guard File by all HOs / SOs and the same preserved till the expiry of validity of card ie., three years. Annexure II in respect of HO and SOs will be preserved at HO only.

15. Renewal of the Card after expiry of Validity period:

The Proof of Address Card can be renewed after the validity period on following the same procedure as that of a fresh one ie., Furnishing Application with the then stamp size photo, verification by PRI(P), Fees collection, Card preparation etc.  The fees for renewal will be Rs. 150/- (Rupees One hundred and fifty only) i.e. Rs. 10/- towards application and Rs. 140/- towards processing fees.

16. DUPLICATE: Change of address within Chennai City:

If the Card holder has to shift his residence to some other place in Chennai City and if the new address of Card holder falls within the jurisdiction of Card issuance of Chennai City and if the Card holder desires to surrender his/her card and get a new card upon the new address, he/she may get a new one by paying Rs. 100/- (Rupees One hundred only) i.e. Rs. 10/- towards application and Rs. 90/- towards processing fee.  The date of validity of new card will be the same as that of old card.  The card will however be issued only after the genuineness of new address is duly verified by PRI (P) / ASP. The old card will be surrendered by the holder on getting his/her new card.  PM/SPM will personally destroy the old card and endorse a certificate in the Annexure I of the new application.

17. DUPLICATE: Loss of the Card:

Similarly, if the card holder has lost his original Proof of Address Card and if the holder desires to obtain a duplicate card, he/she may get a new one by paying Rs. 100/- (Rupees One hundred only) i.e. Rs. 10/- towards application and Rs. 90/- towards processing fee.  The date of validity of new card will be the same as that of old card. The details of original card should be verified with the Original Annexure I & II (submitted for obtaining original card) available at the PO and the information furnished in the new form should be attested by the verifying Postmaster / Sub Postmaster.

18. Forfeiture of processing fee:

In the event of address furnished in the application found to be “false” or “bogus” at the time of verification, the processing fee of Rs. 240 / 140 / 90/- will be forfeited and no refund of fees need be ordered, as followed hitherto.

19. Procedure for Accounting sale of Application form of Proof of Address card (Rs.10/-):
    At the end of the day, the amount realized on the sale of application forms of Proof of Address Card should be brought under Retail post by selecting the option Other Receipts→Retail Post.

20. Procedure for Accounting processing fee for Proof of Address card (Rs.240/-):
    

                                i.            Create a new service with name ‘Proof of Address Card’ by logging in as POS Supervisor

                              ii.            Add three columns with the follow up discipline

o   Applicant Name           :

o   Applicant Number       :

o   Amount                       :

            All the above three columns should be printed in receipt.

                            iii.            While configuring the amount column the Account Head should be ‘Retail Post’.

The System Administrator should ensure that the service should be configured in all the offices that are authorized for Proof of Address Card Services.

21. Incentive:

i.           The PA at HSG/LSG SO who is selling and also  processing the application for  correct preparation and sending the application to PRI(P) for verification will be paid Re.2/- per application as incentive.

ii.         The PA who is doing the aforesaid work at HO will be paid Re.2/- per application.

iii.       The correspondence section PA at HO who is maintaining entries in the Register, preparing particulars in Annexure-II and sending the same to the Card Maker by Registered Post, dispatching cards with respective application i.e. Annexure I to concerned SOs through SO Slip, delivering the card pertaining to HO and maintaining closing entries at the end of a day will be paid Re.2/- per application.

iv.       The PRI(P) who is verifying the application will be paid Rs.3/- per application.

22. Payment of incentive:   

      According to the conveniences, the Postmaster will effect payment of  incentive to all          eligible officials including those at HO and SOs under his jurisdiction weekly,       fortnightly    or monthly depending upon the voluminous of this business and charge the           payment under “RETAIL POST-Deduct”.

23. Statements:

      Each HO and SO involving this business will furnish a monthly statement to the Regional                 Office directly with copy endorsed to the respective Divisional Office.

Sl. No.	Number of Applications entered in the Register	Number of cards issued from Sl…….. to…….	Number of cards delivered	Number of cards pending delivery at the end of each month.
1	2	3	4	5 (4-3)

     

      Each Division involving this business will furnish a monthly statement to the Regional                      Office on or before 3^rd of every month in the following format henceforth.

Sl. No.	Name of the PO	No. of applications sold	No. of cards processed			Revenue earned
			Fresh	Duplicate (Loss / Change of address)	Renewal

                                                **********

Ho to Instal Hindi Font (Mangal Font) in all Computers of D.O/P.O using for correspondences.

It is instructed by the Directorate that all correspondences should be typed in bilingual (Hindi and English) to some extent.

So, please install Hindi Font (Mangal Font) in all Computers of D.O/P.O using for correspondences. Similarly Tamil Font can also be installed if required.

Procedure is furnished below:

Step 1 :
http://www.google.com/ime/transliteration/

Download  the Google IME  and install the same 
(Hindi and Tamil IME given below for ready reference)
Download Hindi Setup   , Download Tamil Setup

Step 2 :

For Window XP : In Control Panel - Regional and Language option - Select 'languages' tab - Select 'Install files for EastAsian languages' (it will ask for Win XP CD) - apply - ok

For Windows Vista : In Control Panel - Regional and Language option - Select 'Keyboard and languages' bar - click 'Change keyboard' - Select Hindi - check the 'Google Hindi input' - ok

Step 3 :
Open MS-word
Select the language (which is shown in the taskbar - right side bottom)
Now you can type Hindi (Transliteration)

Complete list of IE (Internet Explorer) Keyboard Shortcut Keys

Complete list of IE (Internet Explorer) Keyboard Shortcut Keys

Are you tired of moving your mouse too dam* much across the screen all the time? What if I tell you that now you can actually perform lots of different tasks quickly or to work without a mouse while using Internet Explorer? Yes, there’re actually many simple ways to do things in IE. The lists below describe all the keyboard shortcuts keys you can use in Internet Explorer.

Viewing and exploring webpages

The following table describes shortcuts used to view and explore WebPages.

To do this	Press this
Display Help	F1
Toggle between full-screen and regular views of the browser window	F11
Move forward through the items on a webpage, the Address bar, or the Favorites bar	Tab
Move back through the items on a webpage, the Address bar, or the Favorites bar	Shift+Tab
Start Caret Browsing	F7
Go to your home page	Alt+Home
Go to the next page	Alt+Right Arrow
Go to the previous page	Alt+Left Arrow or Backspace
Display a shortcut menu for a link	Shift+F10
Move forward through frames and browser elements (only works if tabbed browsing is disabled)	Ctrl+Tab or F6
Move backward between frames (only works if tabbed browsing is disabled)	Ctrl+Shift+Tab
Scroll toward the beginning of a document	Up Arrow
Scroll toward the end of a document	Down Arrow
Scroll toward the beginning of a document in larger increments	Page Up
Scroll toward the end of a document in larger increments	Page Down
Move to the beginning of a document	Home
Move to the end of a document	End
Find on this page	Ctrl+F
Refresh the current webpage	F5
Refresh the current webpage, even if the time stamp for the web version and your locally stored version are the same	Ctrl+F5
Stop downloading a page	Esc
Open a new website or page	Ctrl+O
Open a new window	Ctrl+N
Open a new InPrivate Browsing window	Ctrl+Shift+P
Duplicate tab (open current tab in a new tab)	Ctrl+K
Reopen the last tab you closed	Ctrl+Shift+T
Close the current window (if you only have one tab open)	Ctrl+W
Save the current page	Ctrl+S
Print the current page or active frame	Ctrl+P
Activate a selected link	Enter
Open Favorites	Ctrl+I
Open History	Ctrl+H
Open Feeds	Ctrl+J
Open the Page menu	Alt+P
Open the Tools menu	Alt+T
Open the Help menu	Alt+H

Working with tabs

The following table describes shortcuts used when working with tabs.

To do this	Press this
Open links in a new tab in the background	Ctrl+click
Open links in a new tab in the foreground	Ctrl+Shift+click
Open a new tab in the foreground	Ctrl+T
Switch between tabs	Ctrl+Tab or Ctrl+Shift+Tab
Close current tab (or the current window if tabbed browsing is disabled)	Ctrl+W
Open a new tab in the foreground from the Address bar	Alt+Enter
Switch to a specific tab number	Ctrl+n (where n is a number between 1 and 8)
Switch to the last tab	Ctrl+9
Close other tabs	Ctrl+Alt+F4
Toggle Quick Tabs (thumbnail view) on or off	Ctrl+Q

Using Zoom

The following table describes shortcuts used for zooming.

To do this	Press this
Increase zoom (+ 10%)	Ctrl+Plus Sign
Decrease zoom (- 10%)	Ctrl+Minus Sign
Zoom to 100%	Ctrl+0

Using Search

The following table describes shortcuts used for search.

To do this	Press this
Go to the search box	Ctrl+E
Open your search query in a new tab	Alt+Enter
Open the search provider menu	Ctrl+Down Arrow

Using Printer Preview

The following table describes shortcuts used to preview and print webpages.

To do this	Press this
Set printing options and print the page	Alt+P
Change paper, headers and footers, orientation, and margins for this page	Alt+U
Display the first page to be printed	Alt+Home
Display the previous page to be printed	Alt+Left Arrow
Type the number of the page you want displayed	Alt+A
Display the next page to be printed	Alt+Right Arrow
Display the last page to be printed	Alt+End
Specify how you want frames to print (this option is available only if you are printing a webpage that uses frames)	Alt+F
Close Print Preview	Alt+C

Using the Address bar

The following table describes shortcuts used on the Address bar.

To do this	Press this
Select the text in the Address bar	Alt+D
Display a list of addresses you’ve typed	F4
When in the Address bar, move the cursor left to the next logical break in the address (period or slash)	Ctrl+Left Arrow
When in the Address bar, move the cursor right to the next logical break in the address (period or slash)	Ctrl+Right Arrow
Add “www.” to the beginning and “.com” to the end of the text typed in the Address bar	Ctrl+Enter
Move forward through the list of AutoComplete matches	Up Arrow
Move back through the list of AutoComplete matches	Down Arrow

Opening Internet Explorer toolbar menus

The following table describes shortcuts used to open Internet Explorer toolbar and Command bar menus.

To do this	Press this
Open the Home menu	Alt+M
Open the Print menu	Alt+R
Open the RSS menu	Alt+J
Open the Tools menu	Alt+O
Open the Safety menu	Alt+S
Open the Help menu	Alt+L

Working with feeds, history, and favorites

The following table describes shortcuts used when working with feeds, history, and favorites.

To do this	Press this
Add the current page to your favorites (or subscribe to the feed when in feed preview)	Ctrl+D
Delete browsing history	Ctrl+Shift+Del
Open an InPrivate Browsing window	Ctrl+Shift+P
Open the Organize Favorites dialog box	Ctrl+B
Move selected item up in the Favorites list in the Organize Favorites dialog box	Alt+Up Arrow
Move selected item down in the Favorites list in the Organize Favorites dialog box	Alt+Down Arrow
Open Favorites Center and display your favorites	Alt+C
Open Favorites Center and display your history	Ctrl+H
Open Favorites Center and display your feeds	Ctrl+J
Open and dock the Favorites Center and display your feeds	Ctrl+Shift+J
Open the Add to Favorites menu (or open Subscribe to feed when in feed preview)	Alt+Z
Open the Favorites menu from the menu bar	Alt+A
Display all feeds (when in feed view)	Alt+I
Mark a feed as read (when in feed view)	Alt+M
Put the cursor in search box in feed view	Alt+S

Editing

The following table describes shortcuts used when editing webpages.

To do this	Press this
Remove the selected items and copy them to the Clipboard	Ctrl+X
Copy the selected items to the Clipboard	Ctrl+C
Insert the contents of the Clipboard at the selected location	Ctrl+V
Select all items on the current webpage	Ctrl+A
Open Internet Explorer Developer Tools	F12

Using the Information Bar

The following table describes shortcuts used when working with the Information bar.

To do this	Press this
Move focus to the Information bar	Alt+N
Click the Information bar	Spacebar