Charlie.anna (2/10/2011)
Its just a requirement, i hope by doing this i will not break any law :unsure:
I'm asking because there are very few good reasons to do this and if you do all your application have to be able to deal with connections that they think are open being closed underneath them, transactions being rolled back that should have been committed, etc.
May I suggest you go to the person who requested this and find out more information on why?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability