You have one database invoking remotely another database's process through web services.

Web Services are capable of dealing with large amounts of data to transfer, but in that case you would...

Remember that SQL Server 205 incorporates Execute As, that permits the use of fine-grained permissions to "executable" objects, like a Stored Procedure, or a given step of a job.

You should...

I will try to give you a possible answer to what I gather are your concerns.

You can design your security setup for the Web Services Invoker (SQL Server) in such...

The process of converting data to the RTF format is basically a data transformation routine.

Even though it can be conceived as a back-end type of process, it might not be...

When it comes to CLR integration in SQL Server, let's keep in mind the main objective of having .NET on SQL Server: to have an alternative language paradigm that is...