sarath (11/7/2008)

---

Why does SQLServerCentral.com publish the same articles just written by different authors over and over again.

Just a mindless rehash of kiddie concepts, copied from elsewhere and changed here and...

Hi,

Thanks to all for giving your suggestions and thoughts, "Good comments always boost your confidence" but "Bad comments always boost your confidence to do the best as well as tell...

Yelena Varshal (12/12/2007)

---

I was surprised at the logic:

"....This link also contain CLR Triggers but they can also be a DDL trigger that is why they cannot be count under the...

rlondon (12/12/2007)

---

In this BOL page, http://msdn2.microsoft.com/en-us/library/ms178134.aspx titled Types of DML Triggers, it states After, Instead Of, and CLR Triggers are types of DML triggers. For triggers...

Hi guys,

I think question and answer both are correct. because if you people see the question read it carefully,

"How many types of DML triggers in SQL are present? (DML...

Dennis Wilson (12/1/2007)

---

I agree that the article was good and could be made even more complete with the addition of a short discussion about being unable to use the TRUNCATE...

Mike Perkins (11/28/2007)

---

Hi Prashant,

"Cascade" refers to an implicit action, such as cascade delete or cascade update. In the case of cascade delete, say you have a table Album with an...

Hi,

Actually the line which is below:

In case of TRUNCATE and DELETE, because they are deleting data from the table, the DELETE TRIGGER will fire if present and also the INSTEAD...

MudLuck (11/26/2007)

---

All,

This part of the article below has me the tiniest bit flustered as I believe it can take newbie’s down the wrong road.

Author-- "As TRUNCATE resets the identity column...

Filip Poverud (11/26/2007)

---

I rated average because:

1 - You have a type mismatch in your desription of your statements regarding the table name.

2 - You use the words remove / delete...

Mike Perkins (11/26/2007)

---

Good article, but it would also be good to explicitly tell the effect when cascade delete is turned on for a relation with another table. My guess would...

For more info regarding Truncate and Delete read the following article.

http://www.sqlservercentral.com/articles/delete/61387/

Rajnish Kumar (11/23/2007)

---

It's really too good. Topic was simple but very informative. It changed some of my views abt truncate. One of my question is DDL statement also fires some...

Paul (11/22/2007)

---

Hello.

There was a bit of redundancy in this article. Therefore, please forgive me if I overlooked your mention of a very useful byproduct of using TRUNCATE.

If your table has...

Mark Fyffe (11/22/2007)

---

Actually my mistake this does work on temp tables but it does not work on variable tables nor does the drop table command. i.e.

declare @t1 table

(

c1 varchar(10)

)

insert into...