Activate a large number of SQL User

Question

Hi, after importing a database with the wizard, will all SQL users is disabled. Can I connect an ALTER LOGIN? For example, ALTER LOGIN (SELECT name FROM WHERE sys.sql_logins is_disabled = '1 'AND default_language_name =' German ') ENABLE. THX

Answer 1

Hello,

Please try to adapt to your needs the script provided by Madhu on the following thread:

http://social.msdn.microsoft.com/forums/en-us/sqldatabaseengine/thread/2A115866-51F1-4253-A874-EE10FFD3314D

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Hi Alberto,

thank you. Yes it works :-).

Sir_Walles