SQLDMO

[calenkl]

wat platform u r using ?

if Win98, u must first configure ur SQL server authentication for the user to access...

if WinNT, as long as u r accessible to the specific Database & Server, then u can just connect to it using..SQLDMO with creating one SQLServer object....

dim objSQLServer as SQLDMO.SQLServer
set objSQLServer = new SQLDMO.SQLServer

objSQLServer.Connect "ServerName",["Login"],["Password"]

set objSQLServer = nothing

for WinNT the 2nd & 3rd parameter can just ignore...
but for Win98 or Win95....
u must provide this two...with configuring the Database Login User prior to perform this Statement....

hope it's useful to u....!

anyway...i'm stuck in applying Transaction Log...any ideas ???