locked
stored procedures RRS feed

  • Question

  • In stored procedures, What does the "[dbo]" stands for ?

     

    for example :

     

    ALTER PROCEDURE [dbo].[addNewPersonInRoom]

    Saturday, September 13, 2008 4:27 AM

Answers

All replies

  • It stands for object owner.

    Saturday, September 13, 2008 4:30 AM
  • Generally,object's default owner is "DBO".
    Saturday, September 13, 2008 4:32 AM
  •  

    Thank you , found the answer:

     

    There are two "dbo" in SQL Server, one is Database Owner and one is Database Object Owner, dbo is a user with permissions to perform all activities in a database. Each database has this special user called dbo, user dbo cannot be deleted and is always present in every database. Database owners and object owners have no separate logins the user dbo is part of sysadmin fixed role or db_owner fixed database role. Any objects created by members of the sysadmin fixed server role (or by the dbo user) belong to dbo.

    Saturday, September 13, 2008 4:38 AM