• Kenneth.Fisher (4/19/2013)


    You can use the object property isMSShipped to help you find user created objects.

    SELECT *

    FROM sys.objects

    WHERE objectproperty(object_id, 'ismsshipped')=0

    good one Kenneth..

    I was not aware of property 'ismsshipped'

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/