Data Modeling Evangelist Kaien Kim's Blog

select col.table_catalog, col.table_name, col.column_name, obj2.name as SP_Name, obj2.id as SP_ID from sysdepends dep, sysobjects obj, sysobjects obj2, information_schema.columns col where dep.depid = obj.id and dep.id = obj2.id and obj.name = col.table_name and col.column_name = 'ssn' and obj2.xtype='P' group by col.table_catalog, col.table_name, col.column_name, obj2.name, obj2.id etc... sp_ta..

Syntax sp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner' Arguments [ @objname = ] 'object' Is the name of an existing table, view, user-defined function, or stored procedure in the current database. object is an nvarchar(776), with no default. object can be qualified with the owner of the existing object, in the form existing_owner.object if the schema and its owner have the..