Then rename that daily backup file from DBNAME_mmddyyyy.BAK to mydb.bak prior to copy step using ren command.

MJ

Check whether disk io subsystem is busy whenever u get the alert. In case its not then increase the threshold.

Mj

Run the same statements after running dbcc updateusage with count_rows on the 2000 database and compare them.

MJ

Kindly post the error.

Mj

Yep.

Mj

Try the following:-

EXEC master.dbo.sp_serveroption @server=N'test', @optname=N'collation compatible', @optvalue=N'TRUE'

GO

HTH!

Manu

For user database read -->http://www.sqlservercentral.com/Forums/Topic800427-146-1.aspx

MJ

http://blogs.msdn.com/davidlean/archive/2009/09/20/tip-ssms-script-your-entire-table-including-the-data-a-hidden-gem.aspx

MJ

SELECT *

FROM

INFORMATION_SCHEMA.COLUMNS

WHERE

COLUMNPROPERTY -- get columns where is_identity = 1

(

...

Overview of memory dump file options for Windows Vista, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows XP, and Windows 2000

http://support.microsoft.com/kb/254649

Normally 1.5 times rule is required for...

Tiggers can be disabled in 2000.

ALTER TABLE tablename DISABLE TRIGGER triggername.

MJ

Under SSMS he can't unless he is a member of sysadmin server role.

MJ

MJM,

Your script give error on 2005 SP2.

Msg 207, Level 16, State 1, Line 32

Invalid column name 'is_sparse'.

Msg 207, Level 16, State 1, Line 33

Invalid column name 'is_column_set'.

MJ

dbcc updateusage with count_rows

sp_updatestats

Rebuild all indexes (individually)

DBCC for DATA_PURITY

Change page verification to CheckSum (from Torn page)

Create a new backup

Perform test by the application team(s)

MJ

if there is a chaqnge in the table how will that be replicated?

Changes will be replicated based on the transactional replication schedule that you specified during configuration.

MJ