Iam with you on that .

Hi

I doubt whether a single procedure that detects updates on any of the tables and updates the date column is possible.

You can write update triggers on the tables or

The procedure...

whats the error?

Chris Morris (12/9/2008)

---

That's...

Iam not sure how much you can automate this task or would even want to automate unless iam dealing with a very large number of changes.

Anyway i do it manually...

Hey... why are you reindexing every 4 hrs?

Hi

Your requirement seems pretty simple. Dont think you need the actual code...Just lookup the BOL on how to create procedures.

Make sure you are doing the inserts inside a transaction.

You...

thanks for the list.

Do you mean to say insert real time production data into development db. Then how will you put the data back to production?

What i would suggest is

Create a development...

ALZDBA (12/3/2008)

---

A parent row can have more than one child rows in a child...

Probably these "child" tables have Fkey relationships with other tables.

Another masterpiece.

Small typo -

You have a single quote missing at the end of the date for the code under OLD fashioned swap.

"SET @EndDate = '2008-01-15 "

You could use locking hints like TABLock or HoldLock. Alternatively you could set a higher transaction isolation level and do your inserts. Bear in mind that these have their own...

GilaMonster (12/1/2008)

---

Depends what you're doing.

Usually derived tables are less intensive because there's no interim storage and no need to insert stuff somewhere and then query it out. If you're...

i think i got this from some code written by Jeff Modem 🙂