Interested to Buy Any Domain ? << Click Here >> for more details...
What are the pros and cons of creating extended stored
procedures?
- 1 Answers
- 5522 Views
- I also Faced
- E-Mail Answers
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 |
Describe in brief sql server monitoring ways.
How is foreign key related to primary key?
How to test odbc dsn connection settings?
What is the difference between migration and upgradation in sql server?
How can I check that whether automatic statistic update is enabled or not?
what is denormalization and when would you go for it? : Sql server database administration
What is sub-query in sql server?
Can we create clustered index on non primary key column
20 Answers ABC, CTS,
Is sql server a database?
Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?
What is dbcc updateusage?
What is exporting utility?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
