0

hi

Issue when Suspended any account the sql server database not take offline . and user can access it normally

Sql Server 2016 in my case

just what I need

— Take the Database Offline when Suspended

ALTER  DATABASE  [myDB]  SET  OFFLINE  WITH
ROLLBACK  IMMEDIATE

OR

— Take the Database Online when make it Active

ALTER  DATABASE  [myDB]  SET  ONLINE

thank you

Answered question