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

What is the new security features added in sql server 2014? : sql server security

0 Answers  

---

What is clustered vs nonclustered index?

0 Answers  

---

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

0 Answers   MCN Solutions,

---

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 Answers  

---

What is the appropriate number of test cases that you can write on a database?

2 Answers   Microsoft,

---

How would you add a section to a table?

0 Answers  

---

What purpose does the model database server?

0 Answers  

---

Explain some DBCC commands?

6 Answers  

---

What is apply operator in sql?

0 Answers  

---

What is difference between rownum and rowid?

0 Answers  

---

How to work on DTS?what is the main requirement?

1 Answers   Getit, ivan,

---

in how many ways we can use count()

2 Answers  

---