Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What are the pros and cons of creating extended stored
procedures?

Question Posted / guest


What are the pros and cons of creating extended stored procedures?..

Answer / 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

More SQL Server Interview Questions

What is create command?

0 Answers  

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,

What command do we use to rename a db?

5 Answers   IBM,

What is user-defined scalar function?

0 Answers  

how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers   TCS,

How to select true false based on column value in sql server?

0 Answers  

What are ddl (data definition language) statements for tables in ms sql server?

0 Answers  

How column data types are determined in a view?

0 Answers  

Explain the database you used in your final year project?

0 Answers   Wipro,

What is an example of a primary key?

0 Answers  

What is stretch database in sql server?

0 Answers  

What’s the use of custom fields in report?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories