Answer Posted / subbu

Newly introduced in Sql server 2005
======================================
DDL trigger (This trigger fired only create new table or
Drop table or Alter table).Created in either Database or
Server.
To Deploy .Net procedures.
CLR Integration.
TRY & CATCH Mehod (For Error Handling).

What is function of ROLLUP ?

1079

---

Why does sql studio use a single registered database repository? : sql server management studio

992

---

What is role playing dimension with two examples? : sql server analysis services, ssas

1000

---

Can we store videos inside the sql server table?

976

---

Can you explain important index characteristics?

987

---

What are partitioned views and distributed partitioned views?

1018

---

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

1021

---

Why do we use non clustered index?

1077

---

What is attribute? : sql server analysis services, ssas

1015

---

What is ems sql management studio? : sql server management studio

1107

---

Explain what is scheduled job and how to create it?

951

---

How do I find information about the install locations for the various instances running on a computer?

1075

---

What is a schema in ms sql server 2005?

964

---

What is primary key index?

977

---

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1939

---