george sibbald (7/9/2010)

---

no best practice as to no of filegroups. Maybe a primary plus one more to act as default group for user data.

If you decide at some point you...

To partition a table my...

george sibbald (7/9/2010)

---

Unless you specify a filegroup in the create statement all the data would get written to the data file in the primary group.

to get data to write to...

Super. I appreciate a concrete example of using sp_send_dbmail in a production environment.

Thanks!

Interesting, so your profiles reflect the email account you are sending from rather than the who you are sending to. So, when you have more than one person that...

I personally appreciate the post. I will piggy back on this post once the originator has made their comments. I have some questions....:-)

Thank you Eralper. The link answers my question.

In summary, sp_send_dbmail is a stored procedure which can be called out from within the application to trigger database mail to...

I am going straight out of the MS SQL Server 2008 Training Kit, chapter review for Policy Based Management. Suggested Practice:

"Configure policies to checkthe membership of the sysadmin and...

Cool!

Can you share the syntax of it, minus any proprietary or private information?

it's not DB Mail configuration I'm wondering about. It's the layer in between the table (that has the customer's email) and DB mail (used for sending notifications for events)...

I have personally used this one and it works:

http://www.delphifaq.com/faq/databases/mssql/f676.shtml

Minaz Amin, thank you for getting me to this point.

And folks, gmail works. Just make sure to put your gmail email into the user name field, not just the...

made the advised changes (port 587 and SSL security checked). Getting same error:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail...

Thanks for hanging in there with me and for the snapshots.

Here are my settings:

Email address: aitchk.candoo@gmail.com (working gmail address)

Reply email: aitchk.candoo@gmail.com

Server Name: smtp.gmail.com

Port number 465

Basic authentication

Username: aitchk.candoo

Password:...

Bear with me please.... SMTP services are installed on the OS.

I have gone to Database Mail -> Configure Database Mail and put in these settings:

Account Name: TestAccount

Description: Test Account

E-mail Address:...