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...

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 ) ---------------------------------...