hi,
I am executing a restore database (MS SQL Server 2005) from perl dbi.

but restore stops after printing this message [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 168 pages for database 'aks1', file 'DBA_Test' on file 1. (SQL-01000)

if run the restore database from sqlcmd, i get following output
Processed 17632 pages for database 'aks1', file 'DBA_Test_Kline' on file 1.
Processed 2 pages for database 'aks1', file 'DBA_Test_Kline_log' on file 1.
RESTORE DATABASE successfully processed 17634 pages in 15.656 seconds (9.226 MB/sec).


how can i make my dbi to continue executing after getting informational messages.

thanks
AK

i changed prepare to include an option solved the problem
my $sth = $db->prepare( $sql, { odbc_exec_direct => 1})