Browse by Tags

All Tags » sql server » system   (RSS)
Ways to make best use of INFORMATION_SCHEMA Views - Stored procedures & Functions?
15 October 07 05:59 AM | SQL Master | 2 Comments   
How many of you took help from using INFORMATION_SCHEMA views in SQL Server? Have you ever wondered in returning the informaiton of a Stored procedure or function, you may be thinking using SP_HELPTEXT would get you. Parts of the solution is yes with Read More...
TSQL to get an index age in a database
06 September 07 06:37 AM | SQL Master | 2 Comments   
SELECT ‘Index Name’ = ind . name , ‘Statistics Date’ = STATS_DATE ( ind . object_id , ind . index_id ) FROM SYS.INDEXES ind WHERE OBJECT_NAME ( ind . object_id ) = ‘Table_Name’ Read More...
Filed under: , , ,
TSQL to generate GRANT statements from a database
17 August 07 03:45 AM | SQL Master | 2 Comments   
select p . state_desc + ' ' + p . permission_name + ' OBJECT::' + s . name collate Latin1_general_CI_AS + o . name collate Latin1_general_CI_AS + ' TO ' + u . name collate Latin1_general_CI_AS + 'GO' , p .* from sys.database_permissions p inner join sys.objects Read More...