SQL Server Performance

Schema

Discussion in 'SQL Server 2008 General DBA Questions' started by RVG, Dec 17, 2010.

  1. RVG Member

    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.
  2. satya Moderator

Share This Page