Answer Posted / bed singh

1. Triggers can only be implemented on tables or views but
Stored Procedure in independent code that can be specific
to database.

2. Triggers are automatically run but stored procedures are
not automatically run and they have to be called explicitly
by the user.

3. we can write a stored procedure within a trigger but
cannot write a trigger within a stored procedure.

4. Trigger is attached to table or view and is fired only
when an INSERT, UPDATE, and/or DELETE occurs, while a
stored procedure executes at any time when it is called.

What are drilldown reports?

150

---

What are the types of indexes?

1067

---

What are the advantages dts has over bcp?

979

---

1 01 101 01010

2036

---

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8135

---

What are the restrictions applicable while creating views? : SQL Server Architecture

1008

---

How do I view a trc file?

925

---

What does asynchronous call backs means?

1129

---

how can u get last observation in an unknown dataset ?

2422

---

What is use of dbcc commands?

1049

---

How to connect sql server management studio express to sql server 2005 express?

1012

---

Does full backup break log chain?

947

---

How many columns can exist together per table?

1140

---

Explain about service Broker functions?

1018

---

Do you know what guidelines should be followed to help minimize deadlocks?

957

---