tag:blogger.com,1999:blog-4149930.post7829806100275690577..comments2023-08-10T10:53:35.019-04:00Comments on SQL Soundings: Deleting User Objects in Master DatabaseLarry Leonardhttp://www.blogger.com/profile/01248746755565439137noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-4149930.post-39051424798011324522013-02-04T12:47:07.078-05:002013-02-04T12:47:07.078-05:00If your database has multiple schemas other than d...If your database has multiple schemas other than dbo or whatever your logged in user defaults to, modify the cursor as follows<br /><br /> SELECT s.name + '.' + o.name, o.type_desc<br /> FROM sys.objects o<br /> join sys.schemas s on s.schema_id=o.schema_id<br /> WHERE o.is_ms_shipped = 0Barrakodahttps://www.blogger.com/profile/17777597560536055480noreply@blogger.com