Monday, February 23, 2009

HOW TO FIND A LOST MOBILE?

Hey, lost your cellphone & you dont know how to get it back...and you must be thinking that there must be someway to retrive your lost phone.... well I m equally not sure that it can me done...

there is lots about IMEI code..(15 digit no.) find more in google. type *#06# in ur phone u will get this number, or open the cellphone, it might be blow the battery.


If you had this number stored in somewhere ..go to the network service center.. and ask them to lock this phone....and ask how u can get you mobile phone..
there is definatly ways that you can get your phone...But I dont think anyone will seriously help u to get your phone back....

If you are lucky or having Big sources or u got your mobile back thru IMEI..I would definatly like to hear from you



there are some website claims that they are managing database of theft mobile and they will send info of ur moblile phone in your email..I m not sure how reliable they..but definattly this is good idea to mainttain this type of database... everyone shud encourge this..


some websites claims that if u become the member of site they will send the theft users images in your http://www.flickr.com account.. one of such website is www.shozu.com....

check this

http://www.cellulartrace.com
http://www.numberingplans.com
http://www.gsmworld.com/using/security/index.shtml
http://www.mobilephonestracker.com



also got this from the net

HOW TO FIND A LOST MOBILE?


If u lost your mobile, send an e-mail to cop@vsnl.net with the

following info.

Your name:

Phone model:

Make:

Last used No.:

E-mail for communication:

Missed date:

IMEI No.:

-----------------------------

Wednesday, February 4, 2009

Shrink Database & Transaction Log

Here you can find more about shrinking of database & log file.
http://support.microsoft.com/kb/q256650/

total records in a database....tablewise record count

Sometime we need to count the total numbers of reord count in a database or in a table... given below is the query.


use windmail
go

SELECT tblname.name AS "Table Name", recordcount.rowcnt AS "Row Count"
FROM sysobjects tblname, sysindexes recordcount
WHERE recordcount.id = tblname.id
AND indid IN(0,1)
AND xtype = 'u'
AND tblname.name <> 'sysdiagrams'
ORDER BY recordcount.rowcnt DESC

COMPUTE SUM(recordcount.rowcnt);
GO