Interested to Buy Any Domain ? << Click Here >> for more details...
What are the pros and cons of creating extended stored
procedures?
- 1 Answers
- 5492 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is built-in function?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
Explain about protocol layer present in SQL server?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What are sparse columns?
What is the boxing and unboxing concept in .net?
Explain “row_number()” in sql server with an example?
What is a subquery in a select query statement in ms sql server?
What is transactional replication?
Should you normalize audio?
what is denormalization and when would you go for it? : Sql server database administration
What are the advantages of paper records?
Explain trigger and its types?
Which tools are available to manage SQL Azure databases and servers?
What are views used for?
