• do you mean if the test login owns any objects? I used the following query to check if the login 'test' owns any object, the result is it doesn't own any objects.

    SELECT

    so.name AS 'ObjectName'

    ,su.name AS 'OwnerName'

    FROM sysobjects so

    JOIN

    sysusers su

    ON so.uid = su.uid

    WHERE xtype <> 's'

    ORDER BY 2