Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 dbo on all

Author  Topic 

WildMan
Starting Member

22 Posts

Posted - 2001-02-22 : 12:02:59
Hello,

How do I create a login to a database that will assign dbo to everything that is created in that specific database?

Now I have a joey login to my database but it assigns it self as joey.table, joey.view, joey.stored_procedure.

How do I get is so it will be dbo.table, dbo.view, dbo.stored_procedure while using the joey login account for that database.

Thanks,

Joey

   

- Advertisement -