What are the pros and cons of creating extended stored
procedures?
- 1 Answers
- 5148 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
Is sql server a database?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is a recursive stored procedure in sql server?
How to convert a unicode strings to non-unicode strings?
What is trigger in salesforce?
What is the difference between the application object and session object?
How to copy the tables, schema and views from one sql server to another?
What happens if time-only values are provided as date and time literals?
What is difference between delete & truncate commands?
What is microsoft sql server?
Explain about the command-line tool SQLCMD?
Differentiate between truncate vs delete in mssql?
How to declare and use cursor variables?
What does it mean to normalize data?
