Getting MS SQL Database size using ColdFusion
March 25, 2008
Someone asked how to retrieve the size of all MS SQL Server databases using Coldfusion. There is a handy built in stored procedure called sp_spaceused which will do the job for you.
<cffunction name="GetAllDatasources" returntype="struct" output="false" hint="I get a structure of all the available datasources."> <cfset var factory = 0 /> <cfset var dsService = 0 /> <cfset var stDatasources = 0 /> <!--- Get CF "factory" ---> <cfobject action="CREATE" type="JAVA" class="coldfusion.server.ServiceFactory" name="factory" /> <!--- Get datasource service ---> <cfset dsService=factory.getDataSourceService() /> <cfset stDatasources = dsService.getDatasources() /> <cfreturn stDatasources /> </cffunction> <cfloop collection="#GetAllDatasources()#" item="item"> <cftry> <cfstoredproc procedure="sp_spaceused" datasource="#item#"> <cfprocresult name="qryResult" /> </cfstoredproc> <cfdump var="#qryResult#" /> <cfcatch>Not MS SQL Server</cfcatch> </cftry> </cfloop>
- Posted in:
- SQL
- ColdFusion
No comments
Leave a comment
If you found this post useful, interesting or just plain wrong, let me know - I like feedback :)
