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 - 2002-01-31 : 08:13:29
|
| Paul writes "No question,I just thought you should pass onto Andy Pope the fact that he should first Disconnect the SQLServer Object in his code for error handling in long-running batch jobs. Which he posted on this site before destroying the SQLServer object. If he does not do this, then he will be creating a number of orphan SQL connections in SQL Server each time he runs the codeAll he needs to do is add aEXEC sp_OAMethod @oSQLServer, 'DisConnect'line before the EXEC sp_OADestroy @oSQLServer line!RegardsPaul McMillan" |
|
|
|
|
|
Error handling in long-running batch jobs