Run SQL Query on Different Thread of SQL

In One Stored procedure i m calling two - three different stored
procedure . Can i run sub Stored Procedure (Calling Procedure ) in
different SQL threads
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Dharmesh Doshi wrote:
> In One Stored procedure i m calling two - three different stored
> procedure . Can i run sub Stored Procedure (Calling Procedure ) in
> different SQL threads
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
You can kick off multiple jobs to to this. You can also call the
procedures from your app asynchronously from ADO or kick off multiple
threads if your app uses .Net.
If Proc1 calls Proc2 and Proc3, though, and I needed to run them
asychronously, I might kick them off separately from the app once Proc1
completed. Or you can create jobs in Proc1 that kick off and immediately
run Proc2 and Proc3.
David Gugick
Imceda Software
www.imceda.com

Run SQL Query on Different Thread of SQL

In One Stored procedure i m calling two - three different stored
procedure . Can i run sub Stored Procedure (Calling Procedure ) in
different SQL threads
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Dharmesh Doshi wrote:
> In One Stored procedure i m calling two - three different stored
> procedure . Can i run sub Stored Procedure (Calling Procedure ) in
> different SQL threads
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
You can kick off multiple jobs to to this. You can also call the
procedures from your app asynchronously from ADO or kick off multiple
threads if your app uses .Net.
If Proc1 calls Proc2 and Proc3, though, and I needed to run them
asychronously, I might kick them off separately from the app once Proc1
completed. Or you can create jobs in Proc1 that kick off and immediately
run Proc2 and Proc3.
David Gugick
Imceda Software
www.imceda.com

Run SQL Query on Different Thread of SQL

In One Stored procedure i m calling two - three different stored
procedure . Can i run sub Stored Procedure (Calling Procedure ) in
different SQL threads
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!Dharmesh Doshi wrote:
> In One Stored procedure i m calling two - three different stored
> procedure . Can i run sub Stored Procedure (Calling Procedure ) in
> different SQL threads
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
You can kick off multiple jobs to to this. You can also call the
procedures from your app asynchronously from ADO or kick off multiple
threads if your app uses .Net.
If Proc1 calls Proc2 and Proc3, though, and I needed to run them
asychronously, I might kick them off separately from the app once Proc1
completed. Or you can create jobs in Proc1 that kick off and immediately
run Proc2 and Proc3.
David Gugick
Imceda Software
www.imceda.com

Run a MS Access Sub from DTS pkg??

Does anyone have any experience with running an Access subroutine from a DTS package (vbscript)? I've tried using the Call function & get the following error. (also tried changing the sub to a function, but still get the error)

Error Source: DAO Properties

Error Description: Error Code 0
Error Source = Microsoft VBScript runtime error
Error Description: Type Mismatch: 'Att4Sum2'

Error on Line 8

Property not found.

Here's my vbscript code in the DTS package:

Function ExportAttachmentData()
Dim objDB
Set objDB = CreateObject("Access.Application")
objDB.OpenCurrentDatabase("C:\DBReports.mdb")
Call Att4Sum2
objDB.CloseCurrentDatabase
objDB.Quit
ExportAttachmentData = DTSTaskExecResult_Success
End Function

Thanks!
Brianbump bump bump