Reorganize of index is always online by-Default and we run it off hours less transaction.

Thanks to your idea

every thing is working fine i created alert after i posted this and it is working fine....

already done that !!

thanks for the idea where i can get but this is what i need to monitor Error: 1105, Severity: 17

will that for primary file group or t log file group or for all ?

thanks look like i get what i was looking for........ will post the entire process step by step so that other can get the details and use it in there...

hi,

well as for now no 3rd party tool & WMI Alert can you pass me the script or any link through which i can get some idea........

Dude try like in the where condition

Post the error we can then may provided you the solution.....

plz check this query it will be helpfull

select 'exec sp_help' + name from sys.objects where type_desc = 'User_table'

copy the output and then run it @one shot

the best way is to use this script for log file size shrink

DBCC SHRINKFILE ( file , target_size

...

no the script is just an example the query has different column and table name.

well i want to know is that will that Nolock will be helpful or not for...

u need to add (deadlock-list) in ----> Like ''''%Deadlock encountered%''''

in the below query.

@query = ''select logdate, procInfo, ERRORLOG from tempdb.dbo.ErrorLog where Id >= (select TOP 1 Id...

yes by sp_msforeachdb

do u have any better script or any script please put on the forum.