Courtesy : http://nfpemavelikaradivision.blogspot.com/
Wednesday, 6 July 2011
DB Analyzer dated 05.07.2011
Recent additions in DBAnalyzer
1. Agreement - Sanchay Post & V2SBCO data
2. Miscellaneous - Balance Verification List for RD accounts
3. Database Discrepancies - PPF - HUF Accounts (3 reports)
4. Reports - Signatures exceeding 150 kb
5. Reports - List of Live RD Accounts allotted to Closed Agents
6. SeparateLoT for NREGS / IGNOAPS / IGNWPS / IGNDPS / BPL for HO & SOs
1. Agreement - Sanchay Post & V2SBCO data
2. Miscellaneous - Balance Verification List for RD accounts
3. Database Discrepancies - PPF - HUF Accounts (3 reports)
4. Reports - Signatures exceeding 150 kb
5. Reports - List of Live RD Accounts allotted to Closed Agents
6. Separate
Monday, 4 July 2011
How to Insert Horizontal Lines in Word
When you want to quickly insert a horizontal line into your Word document, you don’t have to type the line manually or even go to the menu looking for a ‘Insert horizontal line’ button.
All you have to do is type three characters on your keyboard and hit enter, and a horizontal line will appear. There are 6 different horizontal lines that you can create.
— (3 dashes) and Enter – This will give you a simple straight line.
___ (3 underscores) and Enter – This will give you a thicker, almost double layer horizontal line.
### (3 hashes) and Enter – This will give you a thick line with two thin ones surrounding it.
*** (3 asterisk) and Enter – This will give you a dotted horizontal line.
=== (3 equals signs) and Enter – This will give you a double line.
~~~ (3 tildes) and Enter – This will give you a zig zag horizontal line.
List of Holiday Home for Central Government Employees
This is the list of holiday homes operated by Directorate of Estates, Urban Development Ministry throughout India .
Most of these holiday homes can be booked online. Refer to following GConnect Articles that explains how to book Central Government Holiday home online.
And the following article gives you a fair idea about maintenance these holiday homes. One of the GConnect members has shared his experience of staying in one of such holiday homes
Sl No | Name of stations | No. of Rooms | Location | Name of the Allotting Authority |
1. | Agra (U.P.) Only on-line applications (Taj Mahal remains closed on Fridays) | 14 | Holiday Home for the Central Government Employees, Sikandra Sector 15, (Near Kar-Kunj Income Tax Colony), Sikandra, | Asstt. Director(Regions), Directorate of Estates, Nirman Bhawan, New Delhi-11. Tel: 011-23062231 |
2. | Amarkantak (M.P.) [for details about Amarkantak, pl. access Photo Gallery Section on the website] | 10 | Central Govt. Holiday Home, Amarkantak Madhya Pradesh Tele: 07629-269416 Contact Nos.: MP Tourism Tele : (011) 23366528, 32599000, 23341185-87 Fax : (011) 23347264 email:delhi@mptourism.comwebsite:www.mptourism.com | |
3. | 13 | Central GovernmentHoliday Home, Central Government Residential Complex, Bambolim [Near Nirman Bhawan and | Asstt. Director(Regions), | |
4. | Kanyakumari (Tamil Nadu) | 22 | Holiday Home for | Executive Engineer, Madurai Central Divn-I, Income Tax Staff Qtrs Campus, Meenambalpuram, CPWD, Madurai-625002 Tel: 0452-2535940, and AEM, Chennai@, and (Room Nos.103, 106) Only on-line applications AD(Regions), N.Delhi ## (Room Nos. 201, 206, 208, 209, 213) (w.e.f. 15.3.2010) Only on-line applications AEM, Kolkata $ (Room Nos.104) (4-bed) |
5. | 12 | Holiday Home, CPWD Office Campus, | Executive Engineer, | |
6. | Mussorrie | 05 | Southwood Cottage in the ITBP campus (near library Chowk, | Asstt. Director (Regions), Directorate of Estates, Nirman Bhawan, New Delhi-11011 Tel: 011-23062231 # |
7. | Nainital | 13 | Central Govt. EmployeesHoliday Home, Khurpatal (Nainital). Tele : 05942-240330 | Asstt. Director(Regions), New Delhi-11. # Tel: 011-23062231 |
8. | Ooty | 26 | Holiday Home for CentralGovernment Employees, Good Shed Road, Near Railway Station, Udagamandalam, Nilgiris,Tamilnadu | @ Asstt. Estate Manager, Dte. of Estates, Shastri Bhavan, |
9. | Shimla | 109 | Grand Hotel, The Mall, Shimla-171001 Tel: 0177-2658121 | Asstt. Estate Manager, Grand Hotel, Shimla-171001 Tel: 0177-2658121(Office) 0177-2652587(Reception) |
Courtesy : http://www.gconnect.in/
Sunday, 3 July 2011
How to Repair a Suspected Database
Sometimes when you connect to your database server, you may find it in suspect mode. Your database server won’t allow you to perform any operation on that database until the database is repaired.
A database can go in suspect mode for many reasons like improper shutdown of the database server, corruption of the database files etc.
To get the exact reason of a database going into suspect mode can be found using the following query
DBCC CHECKDB (‘YourDBname’) WITH NO_INFOMSGS, ALL_ERRORMSGS
Output of the above query will give the errors in the database.
To repair the database, run the following queries in Query Analyzer,
EXEC sp_resetstatus ‘yourDBname’;
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb(‘yourDBname’)
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (‘yourDBname’, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER
You should keep one thing in mind while using the above queries that the repair mode used here , REPAIR_ALLOW_DATA_LOSS, is a one way operation i.e. once the database is repaired all the actions performed by these queries can’t be undone. There is no way to go back to the previous state of the database. So as a precautionary step you should take backup of your database before executing above mentioned queries.
Saturday, 2 July 2011
Discussion about System Adminstrators
Gist of settlement & Charter of Demands regarding System Administrator
Demand No. 6
Immediate finalization of Cadre Restructuring proposals including Postal Accounts as assured by the Secretary Department of Posts and its implementation.
- Cadre review proposals including the system Administrators will be finalized before 31.08.2011. Committee will be reconstituted with DDG (P) as chairman. For Postal Accounts problems separate meeting was held and the minutes will be issued separately. First sitting up of the Postal Accounts cadre restructuring committee will be held on 05.07.2011.
10. Drop the proposed move of ending the services of existing System Administrators by outsourcing the technology work to the outsider agencies. Create the System Administrators Posts as assured with specified norms and other works and make the cadre as a promotional cadre to PA/SA.
- This will be considered in the cadre review committee. Formal Proposal will be made before 31.08.2011. Regarding conveyance allowance, order have been issued.
Subscribe to:
Posts (Atom)

