Answer / Krishna Gopal

Extended stored procedures are native system procedures that can call operating system functions or third-party applications. They provide a way to perform operations outside the scope of T-SQL. To instantiate a COM object in T-SQL, you would use OLE Automation (OLE DB provider for SQL Server or ADO).

How are the unique and primary key constraints different?

1 Answers  

---

What is 3nf normalization?

1 Answers  

---

What is the difference between resultset and resultsetmetadata?

1 Answers  

---

How to change location of errorlog in SQL?

2 Answers   ABC, IBM,

---

What is the difference between TRUNCATE and DROP?

1 Answers  

---

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1 Answers  

---

What is partition, how will you implement it? : sql server analysis services, ssas

1 Answers  

---

Some queries related to SQL

1 Answers   Motorola,

---

application server is slow what may be the problem

1 Answers   Microsoft,

---

What is the purpose of grouping data in a report?

1 Answers  

---

How can we write or define DDL statements in Sql server and DML statements?

3 Answers  

---

What are indexes in ms sql server?

1 Answers  

---