cteDailyGrowth AS (

--using the row number, join the drive free table to itself, offset by one day. this gets the free

-- space for each drive on that day and also...

This tells...

• This reply was modified 5 years, 2 months ago by  bonagiris9.

I recently implemented this procedure in our test environment, and I don't see any data in Drivespace. Not sure why it is not populating the data in Drive...

I don't think that is the issue, if i remove the line Create procedure dbo.trackdrivespace as and Begin it works fine. the data gets inserted into trackdrivespace.

CREATE PROCEDURE dbo.TrackDriveSpace

AS

DECLARE @dtmNow...

I recently implemented this procedure in our test environment, and I don't see any data in Drivespace. Not sure why it is not populating the data in Drive space table....