Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-09 : 08:32:53
|
| Daniel writes "How can I use an ActiveX in SQL Server stored procedures?How can I run other server applications (not related to the DB) from stored proceduresThank you in advanceDaniel" |
|
|
Peter Dutch
Posting Yak Master
127 Posts |
Posted - 2003-01-09 : 09:15:25
|
| check for extended stored procedures in Books Online, maybe that's what you need |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-01-09 : 09:31:00
|
| also look at the sp_oa... stored procs==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-09 : 09:33:54
|
You can use COM stuff via the sp_OA system procedures (sp_OACreate, sp_OAMethod, etc.) See Books Online for more details.Be careful about what kind and number of COM objects you instantiate in SQL Server; they will execute in SQL Server's process space and will utilize its resources, and can really hamper performance if they are resource hogs. Putting a COM call into a trigger on a highly updated table, for example, can really tax SQL Server and maybe even bring it to a halt.Using extended stored procedures can help lighten the load somewhat, but they are more difficult to write than COM objects. Edited by - robvolk on 01/09/2003 09:35:36 |
|
|
|
|
|
|
Use of ActiveX components in stored procedures