Post reply

EnumOwnedObjects method on SMO User object does not return any owned objects

  • November 11, 2008 at 1:46 am

    #195932

    Dim OwnedObjects () as URN

    OwnedObjects = smoUser.EnumOwnedObjects

    Why OwnedObjects is always empty?

    If I use DMO as follows then the list is fine:

    Dim objList As SQLDMO.SQLObjectList

    Set objList = dmoUser.ListOwnedObjects(SQLDMOObj_AllDatabaseObjects)

    Please help.

    Joginder Nahil

    http://www.starprint2000.com

  • November 11, 2008 at 7:34 pm

    #897273

    This looks more of a bug. What version of SQL and Service pack are you on. I would suggest to go for a higher cumulative update.

    Thanks!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply