>SQLEXEC(gnConnHandle , [INSERT INTO dbo.contacts (firstname,lastname) SELECT fname,lname FROM kba_data.contacts]) > >SQLDISCONNECT(gnConnHandle ) >>
SQLEXEC(gnConnHandle , [INSERT INTO dbo.contacts (firstname,lastname) SELECT fname,lname FROM kba_data.dbo.contacts])Also always test the return value of SQLEXEC and use AERROR() when it's -1.