January 23, 2006 at 12:56 pm
you guys ever see that script?? yes?? well if you ever tried to modify it, then
you must have realized how tough it is right? it's very useful, but difficult to
customize.
question is this... what can i use to convert results from tsql-queries & procedures
such as (select * from sys..), and sp_helpdb into html format?
i would like to convert the output to html, much like the author of the (comprehensive..) script. if i can find what tool he used to crank out the HTML,
that would be sweet.
i'll go ahead, and post my script when it's completed in here.
question remains... what was the tool??
any one have any ideas?
_________________________
January 23, 2006 at 1:27 pm
Seems to me that you can code a generic script which cycles through every recordset and then cycles through every row with every column, it wouldn't be hard at all... Could be done with a simple script, actually, without much work because you'd just be using looping structures and object collections.
K. Brian Kelley
@kbriankelley
January 23, 2006 at 2:16 pm
well... i can get the information needed. i just
want the results to be in html format so i can
save a page per server as a form of documentation.
much like this:
http://qa.sqlservercentral.com/scripts/viewscript.asp?scriptid=1005
i tried to mod this script, and was just too complicated
with all the cell structure, and declarations.
so looking for the same tool they used to create
the html ouput. maybe i can set up my 'html' report
for only what i want. using the usual system sp's like sp_helpdb, sp_helpserver and selects like select * from sys...
see what i'm trying to do?
_________________________
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply