Saving full-text catalog to different location than default

Hi,
I am writing a database install application that will also create
full-text catalogs on specified data tables. Thanks to help I got
here, this works just fine.
I would also like to store these catalogs to a location different than
default provided by SQL Server. I can retrieve catalog name and
prompt user for a new location so far but how to store it to that
location.
How can I do that?
Thank you,
any help will be appreciated.
_dino_
sp_fulltext_catalog allows you to place it where ever you want. here is a
link describing it.
http://msdn.microsoft.com/library/de...fa-fz_1m07.asp
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dino Buljubasic" <dino@.noplacelikehome.com> wrote in message
news:ha92f1lobmt3c2qit0p7mqa3s5grid4jr1@.4ax.com...
> Hi,
> I am writing a database install application that will also create
> full-text catalogs on specified data tables. Thanks to help I got
> here, this works just fine.
> I would also like to store these catalogs to a location different than
> default provided by SQL Server. I can retrieve catalog name and
> prompt user for a new location so far but how to store it to that
> location.
> How can I do that?
> Thank you,
> any help will be appreciated.
> _dino_
|||Thank you, appreciate the help.
_dino_
On Wed, 3 Aug 2005 17:03:14 -0400, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:

>sp_fulltext_catalog allows you to place it where ever you want. here is a
>link describing it.
>http://msdn.microsoft.com/library/de...fa-fz_1m07.asp

save PDF with specified name

Hi pals,
I am asking you for your wisdom: When user click to:
/ReportServer?/test/This+Is+Test&rs:ClearSession=true&rs:Format=PDF&OrderID=532
I want to:
1. define the name of PDF, I have always "This Is Test.pdf" and I want to
change it
let say "Document 532.pdf"
2. open PDF in new window, I don't want open/save dialog
I s there any guide how to do this ?
Thanks a lot, first point is more important to me.
--
BranoIng. Branislav Gerzo wrote:
> Hi pals,
> I am asking you for your wisdom: When user click to:
>
/ReportServer?/test/This+Is+Test&rs:ClearSession=true&rs:Format=PDF&OrderID=532
> I want to:
> 1. define the name of PDF, I have always "This Is Test.pdf" and I
> want to change it
> let say "Document 532.pdf"
> 2. open PDF in new window, I don't want open/save dialog
> I s there any guide how to do this ?
> Thanks a lot, first point is more important to me.
I've done the following:
Create an aspx-page. Put a reference of the reportserver-webservice into
your aspx-page, render the report in the page-load-event and write the data
(byte()-type)
into the response-object. So you can see your report as html
Put another button on your webpage wich will open the same page in another
window, render the report with the needed format (i.e. pdf) and set the
right response.AddHeader settings.
Code-Snippet in my page-load
Dim rservice as New ReportingService
rservice.Credentials = System.Net.CredentialCache.DefaultCredentials
Dim outputdata as byte()
outputdata = rservice.render(all params and settings include
rendering-format etc.)
Dim fileout as string = your needed-filename with extension
Response.Clear
Response.ContentType = 'set here the right mimetype!!!
If mimeType <> "text/html" Then
Response.AddHeader("Content-Disposition", "attachment; filename=" &
fileout)
End If
Response.BinaryWrite(outputdata)
regards
frank
www.xax.de