What are the pros and cons of creating extended stored
procedures?
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
Can you index views?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What is indexing a document?
How do I save a stored procedure in sql server?
What is transaction server auto commit?
How can I tell if sql server is 32 or 64 bit?
can any body tell me how to know the password of current user in sql server
What are the system database in sql server 2005?
How can a user-defined datatype be created?
What happens if null values are involved in boolean operations?
explain different types of constraints? : Sql server database administration
What language is sql server written in?
What is save transaction and save point?
Can sql servers linked to other servers?