Jeff,

By identity column you mean IS IDENTITY = 'TRUE' which will increment the identity...

Jeff Moden (10/27/2008)

---

You have to plan on the unexpected... what happens if, someday, there's more than one operator? And what happens if you have to do a "bulk" insert...

Jeff Moden (10/27/2008)

---

Heh......

Whenever any Insert Operation occurs on tbl employee counter_ins will be increment by 1.

Jeff Moden (10/24/2008)

---

rishgup (10/24/2008)

---

You can say each trigger update each field. Say You have table employee and address, whenever data is inserted into the table employee only emp_ins field will...

[quote-0

It might effect. It depends on the rate of the data modification statements. According to the trigger that you posted, all of the triggers are updating the same...

I figure out the error in my trigger. That was silly error. now Trigger is working fine and I am getting the result which I was looking for

But my only...

Thanks to all who give suggesstions. Now my database is all set.

I set up transaction log backup every 1 hour and its working fine. And it is mirrored as...

I have database which has 2 tables tblCount with counter_ins field and tblEmployee with emp_name, emp_last, emp_add adn emp_ph fields.

There is no indexing on tables. And I want to find...

SQLBOT (10/22/2008)

---

Interesting problem.

I have a suggested approach:

Write an after trigger that adds the event's rowcounts to a counter table.

This will only get you counts AFTER the trigger is in place,...

Any suggestions????

Steve,...

GilaMonster (10/21/2008)

---

Then you should be set. That column value indicates that the log space is not been reused because a log backup is required. Once the log backup runs (check...

GilaMonster (10/20/2008)

---

You need to backup the log a lot more...

FNS (10/20/2008)

---

No, you cannot shrink the tlog on a mirrored database without breaking the mirror first.

Given that your log is 50Gb vs data at 2Gb you're going to...