Interested to Buy Any Domain ? << Click Here >> for more details...
What are the pros and cons of creating extended stored
procedures?
- 1 Answers
- 5677 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 pivot and unpivot?
what is the main function of a query parameter?
Explain syntax for disabling triggers?
How to get nth highest salary from employee table.
What is policy management?
what's the maximum size of a row? : Sql server database administration
whats the maximum size of view state??
What is tabulation?
How to transfer a table from one schema to another?
What is ddl command?
Does partitioning improve performance?
what are candidate key, alternate key and composite key? : Sql server database administration
How do you create a data source?
What do you understand by replication in sql server?
What is full outer join in sql server joins?
