creating login and schema in sql 2005 sp2

[kodaksmile]

Question - ran into an issue today trying to create a new login and user as well as a default schema. I got around it by adding a schema, creating a login with only public permissions, then changing the owner of the schema to this new login and granting it dbo in the db (required for install).. Is there an easy way to create a user and schema together?

 

[mrdenny]

You have to create the login first, or create the schema, then change the owner of the schema.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog