Hi John, what you could do ist to write some sql-statements that retrieve exactly the values you need. In general I use the SQL-Profiler to record the statements I need. Therefore I open the Enterprise Manager and Display the properties of a certain database while having the SQL-Profiler recording every SQL-Statement. From the resulted Statements I extract the ones important to me. For example retrieving every Table or view from a certain database:
Select Name from SysObjects Where XType = 'U' It's a little complicated to find the statements you need, but much easier than writing the statements yourself searching the SQL-Server help. You then could run a scheduled task on the cf-server in order to monitor the activity on the server. (But not too often, since it could hurt performance). BTW: Here two statements that returns the size of a certain database: Use [Databasename] SELECT o.fileid, o.name, o.filename, o.groupid, o.size, o.maxsize, o.growth, o.status FROM dbo.sysfiles o WHERE o.groupid = (SELECT u.groupid FROM dbo.sysfilegroups u WHERE u.groupname = N'PRIMARY') and (o.status & 0x40) = 0 Go SELECT fileid, name, filename, size, growth, status, maxsize FROM dbo.sysfiles WHERE (status & 0x40) <> 0 Go But you need to have access to the master database in order to retrieve this information. If you need any further information, just contact me off the list. <cfgreetings name="Gert Franz" location="Switzerland" email="[EMAIL PROTECTED]" function="Railo Core Developer"> John Lucania schrieb: >I want to monitor the sql server connected to CFMX. > >What I want is: > >- the total sizes the sql server drives >- free sizes the drives >- size of each database > >in cfmail. > >Any ideas? > >Please advise. > >jl > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230808 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
