Thank you Gila..

Infact I had never seen that forum.

Once again thanks.

Hi,

Yeah I know it's not. but I have seen people replying to such queries as well. Was just trying since many DBAs visit this site.

And of course there is section...

Thanks,

I answered like that. Wanted to confirm.

Once again thanks.

Thanks for quick reply.

Any idea on my first question..?

akash.suryan (6/22/2009)

---

Hi Bryan van ritter,

Interesting to know that you work in Netherlands, I always want to work and live in netherlands though I does not belong to Nethlands I am...

Dear All,

Sorry for not replying. Am at client's office sine 2 days.

Cant open the site there. will go back to my office on monday and will...

UPDATE T1

SET T1.ColC = T1.ColA - T1.ColB,

T1.ColA = T2.ColC

FROM Tab1 AS T1

JOIN Tab1 AS T2

ON T1.PKey...

Thanks a lot.

Just one more doubt.

How can we utilise FIRE_TRIGGERS option.?

Has it to do something with the problem am facing.?

I will suggest the second option...

No other way to fire it automaticaly for each row..?

Backup is most latest.

Have not updated statistics or indexes at all.

Parameters are also same. Execution plan I need to check..

Thanks.

John Marsh (6/4/2009)

---

Hello,

Can you see any blocking occurring when the Query is run on the Live DB?

Also, when you say the DBs are the same, I assume you mean the...

Thanks for your quick reply.

No I din'y reboot. I just tried to open the DESIGN by right clicking on it in SSMS.

You need to...

And you can restore as well..........