Try scheduling it as a job and see it it creates file.

MJ

Simply run the SQL installer again and create a new clustered SQL Instance. Note that the new instance will also need a new, unique IP address and a network name...

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

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

Try:

SELECT

*

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

where objectname = '%Dropped Table Name%'

and eventclass=47--deleted

MJ