Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unwanted user shows up in every database

Status
Not open for further replies.

JuanSanchez

Programmer
Oct 16, 2000
24
US
Every time I create a new database on of my users is auto populated into the users.
I am always there as the DBO and this other user automatically shows up.

How did this happen?
Does anyone know how to do this, I would like certain users to be auto added?
Does anyone know how to stop this once the user is no longer needed?
 
Each time you create a database, SQL Server uses the model database to create it. Add or remove your users from that database and you should get what you want.

Good Luck.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top