View Single Post
  #1 (permalink)  
Old 01-19-10, 13:29
aksaravanan aksaravanan is offline
Registered User
 
Join Date: Dec 2007
Posts: 2
DBI continuing execution after a warning/informational message

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
Reply With Quote