thx leo. that helped a lot .got most of the dependent jobs. there are still some where the wrong databases have been specified ,but this would get me started. It...

thx guys for the replies,the password was not the SA or the password of the creator of the package . Luckily I was able to track down a doc which...

thx guys . Yes I made a typeo when issuing the command QUIET and also i did not leave the space between the strings

instead of typing setup /ACTION=REBUILDDATABASE /QUIET

I...

Spencer,

Thx man.that is an elegant script.it did exactly what I wanted.

Paul:

thx man

thx for the reply.this started happening after the fail-over.The DTC resource was online but was on the other node.I failed over the DTC resource to the active node and i...

Gary,

I feel bad for you man.Here is a suggestion.This may not sound conventional but it may just work.Download SQL Express and install a new instance.Stop the SQL express instance that...

thx terry .it worked

Thank you john ,It seems to be working in most cases but it is also taking away the last charecter on the right side when it value should not...

Tim,

I am thankfull that somebody has questioned my intentions.I understand that using triggers are going to be expensive.I am new to this job and I don't know of too many...

RBarry it is still giving me error saying:

The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the...

You are correct Gila.Is there a way I can implement this by modifying my existing code?At the moment it captures the table on which the data was being deleted but...

thanx for the reply

I am getting syntax errors when trying to inplement XML

The select list for the INSERT statement contains fewer items than the insert list. The number of SELECT...

Thank you praddep for the reply.Unfortunately I cannot use DDL triggers because they do not capture data being deleted from a table .They are usefull only when objects are deleted...

San,

I created a stored proc which is being called by an osql script.I then schedule this osql scrip to run every night using windows scheduler.