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 |
|
Bex
Aged Yak Warrior
580 Posts |
 Posted - 2009-08-25 : 03:36:32
|
| I have a procedure that calls multiple procs to populate several tables in a database (1 parent table and 17 child tables). This was taking time as the operations were sequential. I created an SSIS package to insert into the header, and then simultaneously called the procs to populate each child table.I was informed by a colleague that they believe I can do asynchronous procedure calls in SQL. Is this true? If so, then how do I do this, as it would be great to eliminate the need for SSIS?ThanksHearty head pats |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-25 : 04:55:26
|
| You can use Service Broker for this. Have a look at this:http://rusanu.com/2009/08/05/asynchronous-procedure-execution/ |
 |
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2009-08-25 : 06:01:39
|
| Hi ThereThanks for your reply. This may be a stupid question (as I'm not overly familiar with Service Broker), but does that come as part of a custom install of sql server, or is it an option to install? (as with anaylsis services, ssis, etc). If it IS part of the normal install, then I can utilise it............If not, then I can't as we are constrained by what a client already has. We can make recommendations, but if there is a method that does not involve having to use SSIS, service broker, etc, it would be preferable.Hearty head pats |
|
|
|
|
|
|
|
|
Asynchronous execution of procedures