Interested to Buy Any Domain ? << Click Here >> for more details...
What are the pros and cons of creating extended stored
procedures?
- 1 Answers
- 5589 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
How do you delete a data source?
what stored procedure can you use to display the current processes? : Sql server administration
How to drop an existing table?
What is tablesample?
What are the components of sql server service broker?
What authentication modes does sql server support?
What is the contrast between sql and mysql?
What are exact numeric data types in ms sql server?
What is snapshot report?
Which are the important points to note when multilanguage data is stored in a table?
What are the differences between web role and worker role?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Explain alternate key, candidate key and composite key in sql server?
Why are sql functions used?
How many categories of data types used by sql server?
