Interested to Buy Any Domain ? << Click Here >> for more details...
What are the pros and cons of creating extended stored
procedures?
- 1 Answers
- 5554 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 are the different types of data sources in ssrs?
Can you pass expressions to stored procedure parameters?
What is full outer join in sql server joins?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What have included columns when we talk about sql server indexing?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
what stored procedure can you use to display the current processes? : Sql server administration
How is sql server used?
What is the difference between for trigger and after trigger?
What is the recovery model? List the types of recovery model available in sql server?
How can you tell if a database object is invalid?
Find columns used in stored procedure?
Write query to return all rows sql?
How to enable tcp/ip protocol on a sql server?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
