Mark Breen
marklbreen at gmail.com
Thu Jun 25 02:58:56 CDT 2009
Hello Francisco, Phew, thanks, I thought I was missing something about SQL 2005. Again, thanks for the email. A few years ago, I had to wait a year to get outlook installed on a SQL 2000 machine, if I had had blat then... Mark 2009/6/24 Francisco Tapia <fhtapia at gmail.com> > 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 > > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >