Post reply

showcontig in a job: only 71(rows) output

  • December 10, 2004 at 7:18 am

    #87215

    I have a job setup us sp_foreachdb and outputing the showcontig to a file.  The problem I am having is I only get 71 rows for each database.  There should be 600-1500 rows per database for this particular SQL Server instance.

     

    I have other jobs returning more than 71 rows of data, but they are not using the tableresults.

    Any ideas on getting all rows?

     

    Joseph

  • December 10, 2004 at 9:36 am

    #533369

    Joe,

    If you run this interactively, does it return more data? Is the limit 71 total or per database (so 71 x no of databases)?

  • December 10, 2004 at 11:01 am

    #533387

    Yes, if you run it interactivally you get all the rows.

    I am using MSX to push this script down to 16 instances running on 10 servers.  I have created the same job locally on serveral servers an get the same resultes (71 rows).

    Right now the only other thing I can think of, is create a cursor and select from the cursor to see if I can get all the output to the file.  I really don't want to create a physical table to keep all this information in.

     

    thanks,

    Joseph

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply