import everything in stagetable and then delete first five rows

i think check u have msdb read access permission?

i don't want grant total row. can you help me in that?

the below things are not good?

1. Drop and recreate Indexes

2. DBCC DBREINDEX

3.DBCC INDEXDEFRAG

4. Rebuild indexes

5. Reorgnize indexes

i can do check table but it will lock table right?

hi,

can you share all ur experiences for all points u mentioned?

hi

my db is around 1000 gig ? checkdb will take lot of time

need some alternate fastest solutions

i have error like

the index entry for row id 94 was not found in index id 121348304584

now which method need to do and why?

thanks

thanks guys , it works

try this ----

select cast(cast(last_run_date as char(8)) as smalldatetime) from msdb.dbo.sysjobservers

in sql 2000?

i m getting following error

Syntax error converting character string to smalldatetime data type.

luke,

select cast(cast(20081003 as char(8)) as smalldatetime)

this is not working sql 2000?

yes time is 24 hrs

thanks

1.check the backup location & create folders manually.

2.check weather file exists in backup location / delete or rename it.

3.give different file name.

can you tell how to do activescript?