Thank you for your reply.

Since this is a production database, we often use it to refresh non-production databases with it so the developers will have recent data to work with.

Sounds...

the problem is that with an ERP system, we are dealing with close to 4000 tables for production. Some of these tables are quite large, for example, the tables on...

We run an ERP system. On an average, end users and automated scheduled processes submit close to 3500 reports which accesses the database non stop. Some reports are inquiry only,...

yes, certainly. Here it is.....

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N’[dbo].[TempTableToKeep]‘) AND OBJECTPROPERTY(id, N’IsUserTable’) = 1)

DROP TABLE [dbo].[TempTableToKeep]

GO

CREATE TABLE [dbo].[TempTableToKeep] (

[TempTable] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL...