SQL Server Performance Forum – Threads Archive
Schema IssueI am confuse with new schema concept introduced in SQL Server 2005. I have created new schema as ‘IT’ and user ‘A’ who login using WIndows NT login i have made default schema for that user as ‘IT’ but when user execute any query as SELECT * FROM <TableNAME>, a user is getting error as object is not present but when user write query as SELECT * FROM IT.<Tablename>, user is not getting error.
As per my understanding if user ‘A’ has default schema as ‘IT’ then user can access that schema objects without writing schema name.
Please provide me input what could be best practice of using schema