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 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
