are you looking at this through the query analyzer or through a cfmx query using cfquery?
tw -----Original Message----- From: DDB Lists [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 9:14 AM To: CF-Talk Subject: Re: sp_SpaceUsed system stored procedure... actually for me it returns two recordset like this: database_name database_size unallocated space ABCON 52.88 MB -64.43 MB and the second one reserverd data index_size unused 119096 KB 19440 KB 89216 KB 10440 KB so maybe it is working but you are not picking up the correct recordset ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 2:51 PM Subject: RE: sp_SpaceUsed system stored procedure... > ok, now it gets weirder. > if I run another system stored procedure, its fine, show the data and > everything. sp_SpaceUsed however still doesn't work. no matter the > table/datasource I use it against. > > things I know: sp_SpaceUsed, returns only 1 line of results, with > counts in it, for kilobyte usage and some other diagnostic stuff..... > > hasn't anyone else used this to get the stats from the SQL Server? > > toyn > > > -----Original Message----- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, June 24, 2002 8:42 AM > To: CF-Talk > Subject: RE: sp_SpaceUsed system stored procedure... > > > also, I have tried to make a Datasource for the "Master" database, > where the actual sp_SpaceUsed stored procedure resides, to no avail, > still doesn't work. no records. > > very strange. > > tony > > > -----Original Message----- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Sunday, June 23, 2002 12:46 PM > To: CF-Talk > Subject: RE: sp_SpaceUsed system stored procedure... > > > 100% in cf5! > > very odd that it doesnt work now.... > > tony > > -----Original Message----- > From: Chris Kief [mailto:[EMAIL PROTECTED]] > Sent: Saturday, June 22, 2002 5:25 PM > To: CF-Talk > Subject: RE: sp_SpaceUsed system stored procedure... > > > Has this worked before under CF5? > > I have always used the <cfstoredproc> and <cfprocparam> tags when > calling stored procedures. > > Chris > > > -----Original Message----- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Saturday, June 22, 2002 1:43 PM > To: CF-Talk > Subject: sp_SpaceUsed system stored procedure... > > hi there. > > using cfmx and this query > > <cfquery name="GetDbaseData" datasource="Reports"> sp_SpaceUsed > Reports </cfquery> > > to get the database usage stats for the reports database, returns > nothing. is there somethin in cfmx that inhibits system stored > procedures from running correctly? when i try to get any of the > results, nothing shows up? same query ran in query analyzer, gives me > exactly what i am looking for. > > very odd.... > > tony > > tony weeg > [EMAIL PROTECTED] > www.revolutionwebdesign.com > rEvOlUtIoN wEb DeSiGn > 410.334.6331 > > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists