Nested triggers means that an update to a table in a trigger can fire triggers on that table, providing it's not the same table. So, say you have Table1 that...

karthikeyan (2/2/2009)

---

how much cost do we need to complete the course?

whether choosing 'DB' as a research topic is the best option or not. is there any limitations in choosing...

What's CA?

Why?

Any triggers on the table?

Since you're new to this, read them all. The books are...

That's only possible if recursive triggers are enabled. It's a database-level option and it's disabled...

myst.black (2/2/2009)

---

So that is what we need, a "snapshot" (i'm using snapshot for lack of a better word) that can then be taken in by the database on the other...

I'd also recommend T-SQL Fundamentals by Itzik Ben-Gan. I've only glanced through it, but it looks good.

Yup. That's...

Unless I'm badly misreading,...

I'll change the avatar back in a few days. That's the second comment about the haircut.

Funny thing is, it's not far different from...

Why? There shouldn't be any problem. Take full backups...

From a quick glance, this doesn't need a cursor at all.

One question - if all 5 of the carrier names are blank, do you want 5 records in the table...

Marios Philippopoulos (2/2/2009)

---

Wow, that was something I didn't know, but makes sense the way you put it.

Not that I don't believe you, but can you post a link that mentions...

Arun (2/1/2009)

---

When I try to implement log shipping, I realize that I cannot full backup of the databases. My database sizes are over 100 GB, so its not possible...