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

How many joins in sql server?

0 Answers  

---

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

0 Answers  

---

what is macro?

5 Answers   Excel, Global Innovation, Wipro,

---

How each E-R model constructs can be mapped to the relational model?

0 Answers   HCL,

---

What is Deadlock?

4 Answers   Satyam,

---

---

what is package and it uses and how can u call a package

0 Answers   Satyam,

---

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers   Cognizant, TCS,

---

What is scheduled job and how to create it?

0 Answers  

---

What is the difference between UNIQUE and DISTINCT keywords in DBMS?

1 Answers   Genpact,

---

what is index seek and index scan?

2 Answers  

---

How to check table values in sql server?

0 Answers  

---

What is 3nf normalization form?

0 Answers  

---