Hello,
I use the SQLDMO.Application Comobject to do serveral SQL tasks. My Question
is, how to remove the object correctly from memory. The background are some
problems when using SQL Server Management Studio in the same time -> My PC
does not should down any more, so I think it is an Problem of still active
comobjects.
Are the following lines correct, to remove all objects from memory again?
oSQLServer = CreateObject('SQLDMO.SQLServer')
oSQLServer:Connect( cSQLServerName )
// Some commands
// Closing all again
oSQLServer:DisConnect()
oSQLServer:Close()
oSQLServer:Destroy()
or
oSQLApp := createObject( "SQLDMO.Application" )
// Some commands:
// then closing again:
oSQLApp:quit()
oSQLApp:destroy()
regards
Olaf870
