Tuesday, January 18, 2011

Add BUILTIN\Administrators to Login

USE master

go

EXEC sp_grantlogin 'BUILTIN\Administrators'

go

EXEC sp_defaultdb 'BUILTIN\Administrators', 'master'

go

EXEC sp_defaultlanguage 'BUILTIN\Administrators', 'us_english'

go

EXEC sp_addsrvrolemember 'BUILTIN\Administrators', 'sysadmin'

go

IF EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname='BUILTIN\Administrators')

PRINT '<<< CREATED LOGIN BUILTIN\Administrators >>>'

ELSE

PRINT '<<< FAILED CREATING LOGIN BUILTIN\Administrators >>>'

go

Tuesday, January 4, 2011

2011 New Year Resolutions


Finally, it is 2011.

Alot of new thougths come in to my mind.
But the most radical one is coming from my friend.

He mentioned to me a new idea. Retired after 5 years.
That's why i said this is a radical idea! :)

So this is how he explains to me.
Let's say you are working at USA and 1 USD is 3 times your currency exchange rate.
OK, now assume 1:1 without conversion, you earn the same figure of salary in USA as you are in you home country.

So by calculation, working at USA for 1 year meaning you already work 3 years at your home country. So after 5 years working at USA, meaning you have already working for 15 years in your country.

So that's his theory. Althought there are still some flaws in the idea but still it is a good one.

So 2011 new year resolutions:
1. work towards retirement after 5 years.
2. Have saving of 100K at the end of the year.

Happy New Year 2011!!!!!!!!!