Re: DTS fails on Stored Procedure warning

you can setup an option when you call a dbcc command
generally there is a "no_msg" (or an option like this; read the BOL) which disabled output except in case of errors.


"Mo" <Mo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:72063C0B-8791-4666-90A0-8C7C645C2ADF@xxxxxxxxxxxxxxxx
Hi,
I am calling a stored proc from a DTS package in SQL 2000 using Execute SQL
step & when I try to execute it from DTS, I get 'failed on execution', but
when I run the stored proc manually, it runs fine, but gives a couple of
warnings:
Warning: Null value is eliminated by an aggregate or other SET operation.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.

Any ideas why this happens?
Thanks,
Mo



.

Relevant Pages

  • Re: Access sometimes wont use index of linked view
    ... DBCC DBREINDEX or DBCC INDEXDEFRAG? ... SELECT * FROM foo ORDER BY fldSorting; ... If i execute this in the query analyzer, ...
    (microsoft.public.sqlserver.clients)
  • Re: Access sometimes wont use index of linked view
    ... DBCC DBREINDEX or DBCC INDEXDEFRAG? ... SELECT * FROM foo ORDER BY fldSorting; ... If i execute this in the query analyzer, ...
    (microsoft.public.sqlserver.clients)
  • Re: Shrinkfile does not find the file
    ... could you execute the below ... > command to get the logical name for that database. ... > After that use this logical name in DBCC SHRINKFILE command and try. ...
    (microsoft.public.sqlserver.server)
  • Re: Shrinkfile does not find the file
    ... could you execute the below ... command to get the logical name for that database. ... After that use this logical name in DBCC SHRINKFILE command and try. ...
    (microsoft.public.sqlserver.server)