Post reply

sp_spaceused into table and DTS package logging

  • March 15, 2011 at 8:44 am

    #389052

    1) Can we load the output (2 record sets) of sp_spaceused into an table? I need to load both the result sets into either one/two separate tables.

    2) Also in SQL 2000, with package logging enabled, does it log only when the entire package is run or does it logs even when we run only some tasks in the package?

  • March 15, 2011 at 12:56 pm

    #1299073

    For question 1, by running a profiler trace while executing sp_spaceused or looking at the code in sys.sp_spaceused you should be able to find the statements executed and modify them to do the inserts you require.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

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

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