Nope. DBCC CHECKDB ... is a builtin statement of MS SQL Server used to check the status of a database, while the dbo.dbAdm_Daily is a stored procedure and stored procedures should be executed using the EXEC keyword (you do not have to use the EXEC, but only if the procedure call is the very first statement in a batch.

I just tried to call the procedure without the EXEC ... did not make any difference.

In either case both the commands work just fine in Query Analyzer, both execute using $dbh->do(...), but I have to use the prepare+execute to be able to capture the messages and that only works for the DBCC command. God only knows why :-(

Jenda
Support Denmark!
Defend the free world!

In reply to Re^2: DBI+MS SQL, capture prints from stored procedures by Jenda
in thread DBI+MS SQL, capture prints from stored procedures by Jenda

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.