Hi Peter

Thanks for reply. Unfortunately query is executing for last 8 hours.. So I understand if we kill it.. it will take equal time to roll back.. Am I correct?

Also,...

Hi Aaron,

Thanks for the same. Even I beleive so...

Do u have any other guess why the SP performance is decreasing gradually?

Regards

Utsab

Hi

The owner was sa.. This is the part what I cann't understand. I went through the log and found nothing which could interest me on it

Thanks Again Noel/CVM. But I did no change on the server. Something happened by itself. Can it be for some serious security issue?

I am facing it first time

Hi Noel

Thanks for the tips.. But we do not removed any login from the server now..So I am totally confused how this could happen

Hi

Thanks all for your response. I forwarded the trigger based suggestion [Highlighting that the trigger will be dropped only after 1...

Hi

Could any one kindly provide any advice?

Thanks

Utsab Chattopadhyay

On the same issue.. could any one please tell if DBGHOST locks the schema while it is scripting out some database?

Regards

Utsab Chattopadhyay

Thanks for the reply. But per me it will not be possible as I need to take PKX value for each relevant row [That is...

Thanks a lot.. It worked perfectly

Regards

Utsab Chattopadhyay

Thanks a lot Alex...  

Regards

Utsab Chattopadhyay

Thank u guys and sorry for reverting back so late..

Thank for your help

Regards

Utsab Chattopadhyay

Thanks Site owners. I am still struggling and started to believe that may be we need to write a .net script for it. Any other thoughts please?

Regards

Ya Rich... I do guess the same. Perhaps SQLCompress.net is doing some thing which makes the data transfer also impossible.

Anyway thanks a lot for you time. .

Hi Rich

Thanks for the response. Source is nvarchar(max) and destination is varbinary(max) [This is taken predefined by SQLCompress.net]

Could you plz tell, what data conf. will I use for the output...