Security has been enhanced in SQL Server 2005. You can not only ENABLE/DISABLE login but can do more then that.
One of my colleague was on vacation so for security reasons I tried to DISABLE his login during the whole vacation, I issued the statement
ALTER LOGIN <login_name> DISABLEGO
And when he came back, I issued this statemetn to ENABLE again
ALTER LOGIN <login_name> ENABLEGO
Try doing it, a nice feature.
Remember Me
Powered by: newtelligence dasBlog 1.8.5223.0
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.
© Copyright 2009, Danish Sami, et.al.
User Group Lead