Auto Documenter

I was wondering if sql server 2000 has an auto documenter utility that
can dump information about a database into a word, excel, or text
file. I would not need anything to complicated just table, fields,
types, sizes, and maybe indexes.

Currently I am just exporting my tables into access, and then using
the auto documenter in access to get at this information. This works
but the field types do not match exactly, and when the tables get
large this is no longer a valid solution.

Thanks,

Charliehi Charlie,
"charlie" <charlie_knudsen@.hotmail.com> ha scritto nel messaggio
news:o2qkovgbe4vnqfjsl8r72lu4av55m71qd6@.4ax.com...
> I was wondering if sql server 2000 has an auto documenter utility that
> can dump information about a database into a word, excel, or text
> file. I would not need anything to complicated just table, fields,
> types, sizes, and maybe indexes.
> Currently I am just exporting my tables into access, and then using
> the auto documenter in access to get at this information. This works
> but the field types do not match exactly, and when the tables get
> large this is no longer a valid solution.

if you like, you can have a look at a free prj of mine at my home page, wich
provides an HTML export documentation feature..
hth
Andrea Montanari
andrea.sql@.virgilio.it
http://www.asql.biz/DbaMgr.shtm
DbaMgr2k ver 0.4.0 - DbaMgr ver 0.50.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--- remove DMO to reply an HTML export documentation feature..|||Hi

There are some tools available, and previous posts have advertised them.

I personally would reverse engineer into the Enterprise Architect Version of
Visio and run the reports to an rtf file.

John

"charlie" <charlie_knudsen@.hotmail.com> wrote in message
news:o2qkovgbe4vnqfjsl8r72lu4av55m71qd6@.4ax.com...
> I was wondering if sql server 2000 has an auto documenter utility that
> can dump information about a database into a word, excel, or text
> file. I would not need anything to complicated just table, fields,
> types, sizes, and maybe indexes.
> Currently I am just exporting my tables into access, and then using
> the auto documenter in access to get at this information. This works
> but the field types do not match exactly, and when the tables get
> large this is no longer a valid solution.
> Thanks,
> Charlie

Attaching files

I have just started using ASP.net.
I have to develop a system that attaches word and PDF files to form. I also need to be able to do a full text search on the documents attached.
I'm currently using SQL server 2000 as my backend DBMS, but I have never used it to attach files. My mates recommend using BLOGS but I'm not sure how to do this and I'm not sure if I can do a full text search using this solution.
Could some body please recommend a solution to get me started.
Thanks in advanced
PaddyYou have two requirements because Word and PDF files are better stored as IMAGE while FULL TEXT uses TEXT and NTEXT. FULL TEXT is an add on to SQL Server dependent on Microsoft Search and the Catalogs must be populate to get search results. Run a search for FULL TEXT, CONTAINS, CONTAINSTABLE, FREETEXT and FREETEXTTABLE in the BOL(books online). Hope this helps.

Attach/Embed Office Document

I have an immediate need to include (attach/embed) an Office document (Word, Excel or PP) in a report generated by Reporting Services.
Can anyone point me to an example of this being done?
Can it be done at all?
Does anyone have some thoughts on how I could do it on my own if there isn't a known solution already?
Best regards,
Ryan
--= Posted using GrabIt =--
--= Binary Usenet downloading made easy =--
-= Get GrabIt for free from http://www.shemes.com/ =-
Hi
Try posting this to microsoft.public.sqlserver.reportingsvcs
John
"Ryan Pedersen" <rpedersen@.gensx.com> wrote in message
news:AfYTe.20513$FO3.2337@.bignews3.bellsouth.net.. .
>I have an immediate need to include (attach/embed) an Office document
>(Word, Excel or PP) in a report generated by Reporting Services.
> Can anyone point me to an example of this being done?
> Can it be done at all?
> Does anyone have some thoughts on how I could do it on my own if there
> isn't a known solution already?
> Best regards,
> Ryan
>
> --= Posted using GrabIt =--
> --= Binary Usenet downloading made easy =--
> -= Get GrabIt for free from http://www.shemes.com/ =-
>

Attach/Embed Office Document

I have an immediate need to include (attach/embed) an Office document (Word,
Excel or PP) in a report generated by Reporting Services.
Can anyone point me to an example of this being done?
Can it be done at all?
Does anyone have some thoughts on how I could do it on my own if there isn't
a known solution already?
Best regards,
Ryan
--= Posted using GrabIt =--
--= Binary Usenet downloading made easy =--
-= Get GrabIt for free from http://www.shemes.com/ =-Hi
Try posting this to microsoft.public.sqlserver.reportingsvcs
John
"Ryan Pedersen" <rpedersen@.gensx.com> wrote in message
news:AfYTe.20513$FO3.2337@.bignews3.bellsouth.net...
>I have an immediate need to include (attach/embed) an Office document
>(Word, Excel or PP) in a report generated by Reporting Services.
> Can anyone point me to an example of this being done?
> Can it be done at all?
> Does anyone have some thoughts on how I could do it on my own if there
> isn't a known solution already?
> Best regards,
> Ryan
>
> --= Posted using GrabIt =--
> --= Binary Usenet downloading made easy =--
> -= Get GrabIt for free from http://www.shemes.com/ =-
>

Attach/Embed Office Document

I have an immediate need to include (attach/embed) an Office document (Word, Excel or PP) in a report generated by Reporting Services.
Can anyone point me to an example of this being done?
Can it be done at all?
Does anyone have some thoughts on how I could do it on my own if there isn't a known solution already?
Best regards,
Ryan
--= Posted using GrabIt =--
--= Binary Usenet downloading made easy =--
-= Get GrabIt for free from http://www.shemes.com/ =-Hi
Try posting this to microsoft.public.sqlserver.reportingsvcs
John
"Ryan Pedersen" <rpedersen@.gensx.com> wrote in message
news:AfYTe.20513$FO3.2337@.bignews3.bellsouth.net...
>I have an immediate need to include (attach/embed) an Office document
>(Word, Excel or PP) in a report generated by Reporting Services.
> Can anyone point me to an example of this being done?
> Can it be done at all?
> Does anyone have some thoughts on how I could do it on my own if there
> isn't a known solution already?
> Best regards,
> Ryan
>
> --= Posted using GrabIt =--
> --= Binary Usenet downloading made easy =--
> -= Get GrabIt for free from http://www.shemes.com/ =-
>

Attach or append an Office document to a report

I have an immediate need to embed or attach an Office document (Word, Excel and Power Point) into or to a report.
Say that I have 5 rows of data and each row has a physical file that I want to include in the report just like you would an image.
Can someone point me in the right direction? Is this even possible?
Thanks,
Ryan Pedersen
--= Posted using GrabIt =--
--= Binary Usenet downloading made easy =--
-= Get GrabIt for free from http://www.shemes.com/ =-The closest you can get is to add a "Jump to URL" navigation action and
generate a URL that points to the Office documents. The target location of
the documents can be a network share, or you can just directly upload the
Office documents as resources on the report server and then generate a URL
that points back to the report server virtual directory and uses RS URL
access to identify the resource stored in the report server database.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ryan Pedersen" <rpedersen@.gensx.com> wrote in message
news:%23L%23qmELtFHA.1252@.TK2MSFTNGP09.phx.gbl...
>I have an immediate need to embed or attach an Office document (Word, Excel
>and Power Point) into or to a report.
> Say that I have 5 rows of data and each row has a physical file that I
> want to include in the report just like you would an image.
> Can someone point me in the right direction? Is this even possible?
> Thanks,
> Ryan Pedersen
>
> --= Posted using GrabIt =--
> --= Binary Usenet downloading made easy =--
> -= Get GrabIt for free from http://www.shemes.com/ =-
>