15% CASH BACK WITH AIRTEL MONEY.

Dear all,

Airtel Money offer 15% cash back on First Transaction on airtel money min  rs. 20 and above. offer is only for New Users.

terms and conditions.

1. code can be used one time at first transaction.
2. minimum recharge value should be rs. 20
3. maximum cash back is rs. 50.
4. valid on airtel money app.


Promo Code : - NEW15

CLICK HERE TO RECHARGE.

ALTER TABLE IN MERGE REPLICATION.

To alter table in merge  replication follow the following steps.

1. first of all you can't alter replication table trough design view.

2.  to alter table run the following command at publisher

alter table table_name add column_name datatype

e.g. alter table abc add xy char(10).


Click Here For More Detail

REPAIR SUSPECT OR CORRUPTED SQL DATABASE IN SIMPLE WAY..

Due to some reason SQL Database to go in a suspect mode. When we connect to the database device going into offline. don't worry follow the following steps to recover your database.

for example your database name is ABC

1. Reset the flag of suspect database
2. Set the database to emergency mode so that it become read only and not accessible to other user.
3. Set the database to Single User Mode.
4. Repair the erros.
5. Set the database to multi user mode so that it can be accessed by other user.

CONSIDER ABC IS USER DATABASE NAME.

first of all execute the following store procedure to reset the flag.

1. exec sp_resetstatus 'ABC'

Then execute the following SQL COMMAND  to set EMERGENCY MODE.

2. ALTER DATABASE ABC SET EMERGENCY\

SQL COMMAND FOR SET SINGLE USER MODE.

3. ALTER DATABASE ABC SET SINGLE_USER WITH ROLLBACK IMMEDIATE

REPAIR THE ERROR WITH FOLLOWING COMMAND.

4. DBCC CHECKDB ('ABC',REPAIR_ALLOW_DATA_LOSS)

SET THE DATABASE TO MULTI USER MODE.

5. ALTER DATABASE ABC SET MULTI_USER.

ABOVE IS THE SIMPLE METHOD TO REPAIR SUSPECT OR CORRUPTED DATABASE.


ANY QUERY THEN MAIL ME.

ERROR STDOLE32.tlb IN EXCEL.

hello friends,

many times you may also face the problem in excel stdole32.tlb when you start the excel. my today's post about that onel

here find the solution of STDOLE32.tlb in excel.


Steps for resolve the problem of STDOLE32.tlb.

1. remove excel from your pc.
2. restart your pc.
3. Open registry (type regedit on run)
4. remove excel manually from following location.
 
---- >  HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\8.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\9.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\10.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\11.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\EXCEL (RIGHT CLICK AND DELETE THE KEY)

AFTER THAN REMOVE FROM FOLLOWING LOCATION ALSO.

4. ---- >  HKEY_CURRENT_MACHINE\SOFTWARE\MICROSOFT\OFFICE\8.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)

---- >  HKEY_CURRENT_MACHINE\SOFTWARE\MICROSOFT\OFFICE\9.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_MACHINE\SOFTWARE\MICROSOFT\OFFICE\10.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_MACHINE\SOFTWARE\MICROSOFT\OFFICE\11.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_MACHINE\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_MACHINE\SOFTWARE\MICROSOFT\OFFICE\EXCEL (RIGHT CLICK AND DELETE THE KEY)

CLOSE REGEDIT.

your problem resolved.

star excel and you find that there is no error about stdole32.tlb.

GET RS. 50 CASH BACK ON VODAFONE POSTPAID

Dear all,

Paytm offer rs. 50 cash back on postpaid recharge of rs. 500 and above. offer is only for vodafone users.

terms and conditions.

1. code can be used upto 5 times.
2. one number can be recharged upto 5 times.
3. offer is valid only for vodafone postpaid users.
4. valid on web and app.


Promo Code : - VODA500

CLICK HERE TO RECHARGE.

Get 22.5% cash back on paytm.

Paytm  gives 22.5% cash back on DTH Recharge if you are never sign in on paytm.

Get rs. 225 cash back on DTH  recharge of rs. 1000 and above.

Read More....

1. Code can be used one times.
2. valid for new users.
3. valid for all payment methods.
4. valid only for DTH.
5. valid on web and app.


Promo code:- D2HNEW


D2H RECHARGE HERE !!!

Get upto rs. 625 cash back on DTH Recharge.

Paytm gives upto rs. 625 cash back on DTH Recharge. then why you wait for last date recharge your DTH and enjoy cash back.

Get rs. 125 cash back on recharge of rs. 1000.

Terms and Conditions :

1. code can be used upto 5 times.
2. valid only for DTH.
3. valid for all users.
4. valid on web and app.
5. valid for all payment modes.

Promo Code:- DTH1000


Recharge Here DTH