Store email with attachments & files in shared DB

[sdandekar]

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?

 

[Luther]

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 linkedor
files part of an email are not being stored in the database.  Is there away
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/