Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In an enterprise environment, is it better to delete limited access SQL accounts, or simply disable them?

share|improve this question

migrated from Oct 21 '11 at 18:18

This question came from our site for computer enthusiasts and power users.

I would say that it strongly depends on the requirements of your "enterprise environment" – the-wabbit Oct 21 '11 at 18:26
up vote 5 down vote accepted

If you aren't going to be using them anymore, delete them. Disabling them will have the effect of them not being accessible but if you are truly done with them, keeping your security dialog clean and master database clean of unused/unneeded logins makes sense.

Perhaps disable them for a week or so and make sure no jobs, no processes, no apps, etc. are using them you can then remove them to clean them up...

share|improve this answer

It does not really matter. SQL Server 2008 is not like SQL Server 2000 where schema/roles meant trouble.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.