Try attached script and comment out last line(EXECUTE sp_executesql @sp3--+'GO') till you are satisfied with output.

MJ

select distinct object_name(syscolumns.id),

syscolumns.name As CalculatedColumn ,

syscomments.text as TheCalculation,

isnull(object_name(SYSINDEXKEYS.id),'No Index Using This CalculatedColumn') As IndexName

from syscolumns

inner join syscomments on syscolumns.id=syscomments.id

left outer join sysindexes

on syscolumns.id=sysindexes.id

left outer join SYSINDEXKEYS...

Better specify autogrowth in multiple of MB's rather than in terms of percentage.

MJ

Try the below mentioned code on test server.

DECLARE @tbl TABLE

(

RowText varchar(max)

)

INSERT INTO @tbl

exec sp_helptext 'dbo.test1'

DECLARE @sp-2 varchar(max)

SELECT @sp-2 = ISNULL(@sp, '') + RowText

FROM @tbl

SET @sp-2 = REPLACE(@sp, 'AS', '/****************************

SQL2008 COMPLIANT...

declare @DBFileName sysname

declare @TargetSizeMB int

declare @ShrinkIncrementMB int

-- Set Name of Database file to shrink

set @DBFileName = 'ENTERDBFILENameHere'

-- Set Desired file size in MB after shrink

set @TargetSizeMB = 1000--For example

--...

Try running 'select RWA_ID from Prod_Table with (nolock)

where disp_id = 32' on main db and see how much tie it takes exactly.

MJ

Got my answer--Still need to include 'update statistics' but with FULLSCAN,columns only option.

Thanks for reading!!

MJ

Load Time Delay= Destination Database waits before it restores the T-Log

It needs to be on a different line. After your DBCC CHECKDB statement completion.

MJ

Have you gone thru pablo's advice mentioned on

http://www.sqlservercentral.com/Forums/Topic454943-5-1.aspx

MJ

You can make use of database mail to send mail to end users before killing their processes.

Another way is to use NET SEND command if messenger service is enabled.

Example:

select 'EXEC...

Try to delete in batches.

Example:-

DECLARE @rc int

SET @rc = 1

SET ROWCOUNT 10000--Batch Size based on what is fine for you

WHILE @rc > 0

BEGIN

DELETE FROM Tablename

WHERE <your criteria>

SET @rc =...

Try:

SELECT

*

FROM ::fn_trace_gettable('TraceFilePath\FileName.trc', DEFAULT)

where objectname = '%Dropped Table Name%'

and eventclass=47--deleted

MJ

Only possible with t-sql commands.

When you create your backup you can specify a password for the backup file. Then when you want to restore the backup, the password must be...

Better try stopping the agent first and then see if you can drop th table.

MJ