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 dbcc? Give few examples.

0 Answers  

What is surrogate key? : sql server analysis services, ssas

0 Answers  

What is the difference between DATETIME2 and DATETIME?

0 Answers   Infosys,

What is a transactions?

0 Answers  

What is the system function to get the current user's user id?

3 Answers   TCS,

How many types of Cursor in SQL SERVER?

1 Answers  

Does hive support indexing?

0 Answers  

Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,

how to select 5 to 7 rows from a table, which contains 10 rows?

21 Answers   IBM,

what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 Answers  

what is index seek and index scan?

2 Answers  

What is the full meaning of dml?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories