A journey of a practician to search knowledges by trial and error
Saturday, January 29, 2011
Thursday, January 27, 2011
Wednesday, January 26, 2011
Saturday, January 22, 2011
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
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
Labels:
SQL
Sunday, January 9, 2011
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!!!!!!!!!
Labels:
Thoughts
Subscribe to:
Posts (Atom)