Here is the script I have used to list the information regarding database objects such as tables, indexes and file groups along with their file names : ( extracted from Technet ) select 'table_name'=object_name(i.id) ,i.indid ,'index_name'=i.name ,i.groupid
Read More...
I have had an interesting discussion in SSP World about how to grant access & privileges to handle SSIS packages in a high availability and Disaster Recovery scenario. As you may be aware that privilege involves having access to Distributed COM components
Read More...