Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    27

    Unanswered: database schema owner query

    Greetings all,

    Is there a way to query the system tables for all database objects who owner is a certain login id? If so, what is the basic query?

    Sincerely,

    Patrick Quinn
    Carlson Wagonlit Travel DBA

  2. #2
    Join Date
    Mar 2007
    Posts
    72
    select name from sysobjects where uid = user_id('<name>')

    suda

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •