Store email with attachments & files in shared DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sdandekar - 29 Jan 2008 20:00 GMT

We are using BCM 2007 with a shared database on our W2003 server with SQL
2005 server. The sharing is working well, however files that are linked or
files part of an email are not being stored in the database. Is there a way
to store files in a shared database on a server instead of on a client PC?

Reply to this Message

Luther - 30 Jan 2008 16:52 GMT

On Jan 29, 12:00 pm, sdandekar <sdande...@discussions.microsoft.com>
wrote:

> We are using BCM 2007 with a shared database on our W2003 server with SQL
> 2005 server. The sharing is working well, however files that are linked or
> files part of an email are not being stored in the database. Is there a way
> to store files in a shared database on a server instead of on a client PC?

Email and attachments cannot be stored in the BCM db.

It's always been that way, to avoid consuming all the database space
(limited in some versions of Sql Server) with attachments.

That limitation has been relaxed in recent versions of Sql Server, so
BCM may consider changing that behavior.

If your users share the same mail server, users can open the emails
and attachments (given the right permissions and so on).

Files can be shared if they are stored with a common URL. For example,
if an Account history is linked to document \\server\folder
\foobar.doc, the document can be opened from BCM on any machine that
can access \\server\folder\foobar.doc.

Luther
http://beyng.blogspot.com/

Reply to this Message