第242章被困百草堂 (5 / 9)
         set @rows = @rows + @@rowcount

         -- assembly referenced by udf, sp, uda, trigger

         insert #t1 (object_id, object_name, object_db, object_type, relative_id, relative_name, relative_schema, relative_db, relative_type, schema_bound, rank)

         select asm.assembly_id, asm.name, t.object_db, @assm, t.object_id, t.object_name, t.object_schema, t.object_db, t.object_type, 1, @iter_no + 1

         from #t1 as t

         join sys.assembly_modules as am on ((am.object_id = t.object_id) and (am.assembly_id >= 65536))

         join sys.assemblies as asm on asm.assembly_id = am.assembly_id

         where @iter_no = t.rank and t.object_type in ( @udf, @sp, @uda, @tr) and (t.object_svr IS null and t.object_db = db_name())

         set @rows = @rows + @@rowcount

         -- Partition Schemes referenced by tables/views

         insert #t1 (object_id, object_name, object_db, object_type, relative_id, relative_name, relative_schema, relative_db, relative_type, schema_bound, rank)

         select ps.data_space_id, ps.name, t.object_db, @part_sch, t.object_id, t.object_name, t.object_schema, t.object_db, t.object_type, 1, @iter_no + 1

         from #t1 as t

         join sys.indexes as idx on idx.object_id = t.object_id

  The content is not finished, continue reading on the next page

更多完整内容阅读登陆

《墨缘文学网，https://wap.mywenxue.org》