Can I create and share snapshot folder on computer running IIS, but not computer running S

Hi all,
Usually , I will create a snapshot folder and share it on computer
running SQL Server for MR.
Now I have a question:
Can I create a snapshot folder on another computer which is running
IIS (For merge replication with SQL CE). The computer which is running
SQL Server was not installed IIS,just be installed SQL Server only.
Thanks,
The short answer is yes. Indeed, this would probably be considered the
"accepted" configuration -- one computer running IIS and one computer
running SQL Server. You are simply creating a virtual directory that your
publication is pointing toward to deposit the snapshot. However, your
publication must be able to access that virtual folder and if connectivity
is an issue then I would see you having problems. Note also that your SQLCE
server agent must be located in that virtual folder.
<pikctsach@.yahoo.com> wrote in message
news:55433649.0506201927.76979a0a@.posting.google.c om...
> Hi all,
> Usually , I will create a snapshot folder and share it on computer
> running SQL Server for MR.
> Now I have a question:
> Can I create a snapshot folder on another computer which is running
> IIS (For merge replication with SQL CE). The computer which is running
> SQL Server was not installed IIS,just be installed SQL Server only.
> Thanks,

Can a Snapshot report be created programmatically?

Can I create a Snapshot report with parameters programmatically in RS 2000 or RS 2005? If this can be done what is the command for it? Thanks.

Yes. The report has to be set to Snapshot Execution and has to have default values. The SOAP method to call is UpdateSnapshot.

If you want to create a history snapshot then you can call CreateReportHistorySnapshot.

You can not set the parameters when calling these parameters. If you want the parameters different then you must first set the report parameters then call one of the above methods.

-Daniel

|||

Hi Daniel,

Thanks for the tip... you put me in the right direction. Now, how do I change the parameters before getting a Snapshot? Can I save the result in my own table instead of the History table?

|||

You need to call SetReportParameters to set the parameters. The history snapshot will be saved to the History table. Can you explain why you would want to save it elsewhere?

-Daniel

|||I was planning to use my own database to save the snapshot for ease of maintenance and backup, besides, using the SnapshotDate and converting it to another format before using it is extar work! I guess I can use the RS History Table for now. One thing though, when I get a snapshot, the date in History table doesn't match with the snapshot date! Any idea why? Thanks.|||

I assume you mean the snapshot datetime stamp used as URL access parameter to render history snapshot. The snapshot datetime value is always based on UTC time which is independent of your local timezone, while the date in the internal catalog tables depends on your server timezone settings.

-- Robert