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 |
|
mimei
Starting Member
3 Posts |
 Posted - 2005-09-15 : 03:15:38
|
| Hello How can I call a Stored Procedure inside of another SP where the "calling SP" does not wait until the "called SP" is finished? So that it just goes to the next step in the code And how can I check at a later time if the "called SP" was successfull finished? I think it has something to do with "dbsqlend" but i have no idea how to use that. Thanks a lot for help Greets Michael |
|
|
mimei
Starting Member
3 Posts |
Posted - 2005-09-15 : 03:17:40
|
| add:I also found this Tutorial:[url]http://databasejournal.com/features/mssql/article.php/3427581[/url]This text is exactly what I am looking for, so i made the Example, but it did not work.The SP works when I start it this way: "exec usp_async"The code which i have to run in the Query Analyzer gives me no error.Do i have to set special rights or something or did i forget something?Or is this solution nod good and I have to try an other way? |
 |
|
|
|
|
|
Stored Procedure: Asynchron Call