Hi, I have created a login and user on the server. But I was thinking ways to create a schema when we are creating login, user , schema at one time using the SSMS. Can any one explain how this would work? And more thing is, When I specify the default schema to db_reader, creating an object does really create the object in db_reader schema? Thanks, Ravi Varma.
FOr all your doubts on schema and user refer to http://msdn.microsoft.com/en-us/library/ms190387(v=SQL.100).aspx link and when the schema is assigned all the objects created by that user will have same schema attached.
