query analyzer ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 3:18 PM Subject: RE: sp_SpaceUsed system stored procedure...
> 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 > > > > > > > > > > > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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