Does anyone have a suggestion/example on how I can use SP_MSforeachtable to drop all tables in a database that have 0 rowcount...ie no data in the table
Make sure you open SSIS package and save it using the same login that you are using to run the SQLAgent service under. The 'sensative data; that is being...