July 2007 - Posts

• Secure SSIS step execution when running as a SQL Job

  Here is the scenario: SQL Agent account (NETWORK SERVICE or some DOMAIN ACCOUNT) does not have access to database activities in a SSIS package. You want to run a job but need to "proxy" a security account when a SSIS package runs. The following script Read More... Posted Monday, July 23, 2007 5:12 PM by mab | 0 Comments Filed under: SQL Server

• Programatic way to determine space used on all database tables

  Here is one way I have found in order to get all tables space used. Effectively it queries the sp_tables and sp_spacedused in a loop to return the data. Declare @Table_Name varchar ( 255 ), @SQL varchar ( max ) --------------------------------------------------------------------------- Read More... Posted Tuesday, July 17, 2007 6:17 PM by mab | 2 Comments Filed under: SQL Server