Dear All, We are running SQL Server 2008 R2. We have created 2 SQL Logins having db_owner role assigned. Now we are facing following two issues: 1. We have created databases and those two users are coming by default in those databases. Now we have removed those users from Instance level Security Logins but in databases it is still coming. Is there any way that we can delete the user from all databases rather than by doing it one by one. 2. As I mentioned that we have removed those two SQL logins but when we are creating a new databases they are coming by default in those databases although they are removed from Instance > Security > Logins. How to compeletely remove the users so that they should appear again? Thanks in Advance
Have you assigned these logins as database users in the database called "model"? The model database is used as a template when creating new databases, anything you create in there (tables, stored procedures, users etc.) will be copied into the new database.