Sorry , my bad. It's SQL Server 2005 , in the middle migrating from 2005 to 2008 r2 :).

I will check if this is set on my DB and will explore more on this. Thanks for the pointer