I was checking one document somewhere on the web and then had given the sysadmin role to the user and so now if I connect as user ABC and create...

Steve

CAn you suggest if I can give the user some privilige so that whenever he is creating the new table it will automatically be created with dbo.table and not with...

Thanks Steve for you greate response. Actually I am new to Sql server and earlier working with Oracle. In Oracle I can grant create table priviliges and revike Drop table...