Francisco Tapia
fhtapia at gmail.com
Wed Jun 24 09:45:38 CDT 2009
Blat is great for Sql Server 2000 simply because you can implement email for your server without also installing Outlook. I just don't like Outlook as an email client. It is buggy for me, and has always caused me pains. With Google's Desktop Search (or Vista's indexing search) I was finally able to get a hold of all my email vs the sloooooow email search from Outlook. I personally would NOT use the blat solution on a Sql Server 2005 system. Database Mail is sooo much easier and nicer to use. Blat is a great tool for any of your legacy 2000 systems. Here were I work at I have a mixture of Sql Server 2000 / 2005 and (recently 2008) servers. The 2000 servers at this point are not ready to be retired, the hardware is still under warranty and has plenty of redundancy. However, Email is required from these systems and I've been using Blat for a number of years on these systems :). -Francisco http://sqlthis.blogspot.com | Tsql and More... On Wed, Jun 24, 2009 at 1:15 AM, Mark Breen <marklbreen at gmail.com> wrote: > Hello Susan and Francisco > I wish I know about blat a few years ago when I was struggling to get > outlook installed on a SQL Server. > > With 2005 though, is there some hidden benefit that I am missing in your > blat code, over the following code. > > I have met quite a few people of the the last ten years that do not like to > use SQL Sever mail, but I have used it with never one complaint for close > to > ten years now. For me it gives me very quick to implement email > facilities. > > Thanks for blat, > > Mark > > > EXEC msdb.dbo.sp_send_dbmail > @profile_name = 'Server4DBMail', > @recipients = 'mark.breen at gmail.com', > @query = 'Select * from MyTable', > @body = 'Hello World, here is the contents of the table', > @subject = 'More SQL Server email', > @attach_query_result_as_file = 0 > ; > > > 2009/6/23 Susan Harkins <ssharkins at gmail.com> > > > <http://www.devx.com/dbzone/Article/42178> > > > > Sending E-mail from SQL Server 200X > > > > Susan H. > > _______________________________________________ > > dba-SQLServer mailing list > > dba-SQLServer at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > > http://www.databaseadvisors.com > > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >