Enterprise Manager

Non-sysadmins create tables under own schema

When using SQL Server 2000 and the user doesn't have sysadmin rights, and their login isn't mapped to the dbo user within the database all objects created will be, by default created under the user schema. This is the normal behavior of SQL Server 2000.  In order to allow users who are not...