Managing reporting services models

Hi everybody,

I have the following scenario: I have web application which is creting new SQL Server database each time when new customer is created in the application.

I would like to give users the possibility of creating ad hoc reports and thus I need to create new connection and report model (and deploy them to my reoport server) each time when the new database is created (report models can not use multiple databases). Does anybody knows how can I do that?

Maybe there is another approach to this kind of problem?

Thank you in advance,

Marek

You can create datasources and autogenerate models from these datasources using the SSRS SOAP API. Check out this article in BOL for information on how to get started using the SOAP API:

http://msdn2.microsoft.com/en-us/library/ms159162.aspx

Managing Customer Email Communications via SQL Server

What is the best way for an internet business to manage its email

correspondence with all it customers, given that all customer data

including their email addresses is stored in a SQL Server 2005 table.

Is there a good way for Outlook (for example) to keep an address book

synchronized with a field in the database?

You can connect to sqlserver from outlook via VBA. So, it's just a matter of query the data and update outlook.

Here is outlook vba reference.

http://www.microsoft.com/downloads/details.aspx?familyid=A1CEAD80-23E2-456F-8618-4DA50CC2C38C&displaylang=en