Answer / guest

The pros are that you can implement additional
functionality and access data from DLLs from within SQL
Server. If you need to do something that can be done only
in C or C++, or if you have data that can be accessed only
outside of SQL Server, you can still provide a link to it.
The biggest con to extended stored procedures is that they
run in the same process space as SQL Server. So an errant
DLL could overwrite memory and cause SQL Server to crash or
even corrupt data. The biggest safeguard against these
problems is thorough testing of the procedure

Explain what is cte (common table expression)?

0 Answers  

---

Explain DBCC?

0 Answers   QuestPond,

---

Can we join two tables without primary key?

0 Answers  

---

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers  

---

What is query optimization process?

0 Answers  

---

Does sql server 2000 full-text search support clustering?

0 Answers  

---

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 Answers  

---

What is the difference between insensitive and scroll cursor?

0 Answers  

---

Explain how dts is used to extract, transform and consolidate data?

0 Answers  

---

Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  

---

What is identity?

0 Answers  

---

How to find the source of a table in sql server?

0 Answers  

---