I want to use CF to run a SHOWCONTIG and send the results via an email and i'm
thinking of a way to get it to show em the results.
Can i set the results into an OUT VARIABLE and then have CF take that out var and
display that?
DECLARE @id int, @indid int
SET @id = OBJECT_ID('tblBenefit')
SELECT @indid = indid
FROM sysindexes
WHERE id = @id
AND name = 'aunmind'
DBCC SHOWCONTIG (@id, @indid)
Bill Wheatley
Senior Database Developer
Macromedia Certified Advanced Coldfusion Developer
EDIETS.COM
954.360.9022 X159
ICQ 417645
______________________________________________________________________
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
