Backup or Restore with Stats clause

hi,
I am using Delphi for programing and i am using adocommand for my sql.
I write restore sql with stats clause like this,
"RESTORE DATABASE FINANCE
FROM DISK=C:\FINANCE.BCK
WITH STATS=10"
My problem is how can I read STATS results for my "Progress Bar" process.
Please help?
Best Regards
N.nsal Uslubas
You can add an InfoMessage event handler to your connection object to get
these messages. See
http://msdn.microsoft.com/library/de...fomessage.asp.
Hope this helps.
Dan Guzman
SQL Server MVP
"N.nsal Uslubas via droptable.com" <forum@.droptable.com> wrote in message
news:54015C3C60232@.droptable.com...
> hi,
> I am using Delphi for programing and i am using adocommand for my sql.
> I write restore sql with stats clause like this,
> "RESTORE DATABASE FINANCE
> FROM DISK=C:\FINANCE.BCK
> WITH STATS=10"
> My problem is how can I read STATS results for my "Progress Bar" process.
> Please help?
> Best Regards
> N.nsal Uslubas

Backup or Restore with Stats clause

hi,
I am using Delphi for programing and i am using adocommand for my sql.
I write restore sql with stats clause like this,
"RESTORE DATABASE FINANCE
FROM DISK=C:\FINANCE.BCK
WITH STATS=10"
My problem is how can I read STATS results for my "Progress Bar" process.
Please help?
Best Regards
N.Ünsal UslubasYou can add an InfoMessage event handler to your connection object to get
these messages. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdevtinfomessage.asp.
Hope this helps.
Dan Guzman
SQL Server MVP
"N.Ünsal Uslubas via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:54015C3C60232@.SQLMonster.com...
> hi,
> I am using Delphi for programing and i am using adocommand for my sql.
> I write restore sql with stats clause like this,
> "RESTORE DATABASE FINANCE
> FROM DISK=C:\FINANCE.BCK
> WITH STATS=10"
> My problem is how can I read STATS results for my "Progress Bar" process.
> Please help?
> Best Regards
> N.Ünsal Uslubas

Backup or Restore with Stats clause

hi,
I am using Delphi for programing and i am using adocommand for my sql.
I write restore sql with stats clause like this,
"RESTORE DATABASE FINANCE
FROM DISK=C:\FINANCE.BCK
WITH STATS=10"
My problem is how can I read STATS results for my "Progress Bar" process.
Please help?
Best Regards
N.nsal UslubasYou can add an InfoMessage event handler to your connection object to get
these messages. See
http://msdn.microsoft.com/library/d...nfomessage.asp.
Hope this helps.
Dan Guzman
SQL Server MVP
"N.nsal Uslubas via droptable.com" <forum@.droptable.com> wrote in message
news:54015C3C60232@.droptable.com...
> hi,
> I am using Delphi for programing and i am using adocommand for my sql.
> I write restore sql with stats clause like this,
> "RESTORE DATABASE FINANCE
> FROM DISK=C:\FINANCE.BCK
> WITH STATS=10"
> My problem is how can I read STATS results for my "Progress Bar" process.
> Please help?
> Best Regards
> N.nsal Uslubas