Browse by Tags

All Tags » object_name » sql server   (RSS)
SQL Server- TSQL to see which object reside under which file groups?
24 December 07 03:40 AM | SQL Master | 3 Comments   
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', Read More...
How do I find the CHECK constraints that depend on a specified CLR user-defined type?
11 December 07 08:23 AM | SQL Master | 2 Comments   
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) Read More...
Enhancement to OBJECT_NAME metadata function and a new OBJECT_SCHEMA_NAME metadata function
16 July 07 01:53 AM | SQL Master | 1 Comments   
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 Read More...