To continue the FIND-FilegroupFull post on the filegroups, here is the most common question on the forums to get which object reside under which filegroup if there are multiple ones associated: select si.rows as 'Rows', SO.Name as Table, SI.name as 'Index', SFG.groupname as 'Filegroup'...
Here is the another TSQL script from BOL to find the CHECK constraints that depend on a specified CLR user-defined type? USE <database_name>; GO SELECT SCHEMA_NAME(o.schema_id) AS schema_name ,OBJECT_NAME(o.parent_object_id) AS table_name ,OBJECT_NAME(o.object_id) AS constraint_name FROM sys.sql_dependencies...
You may be aware OBJECT_NAME function can be use to return the database object name, I think since SQL 2000 when system functions are used the parameter of a system function is optional, the current database, host computer, server user, or database user is assumed. Also these system functions can be...