T-SQL Tuesday #015: Automation: I am very much interested to participate in the T-SQL Tuesday event party. I have seen the T-SQL Tuesday logo and article in one of my favorite SQL server blog Gail Shaw. I found the Adam Machanic ( Blog | Twitter ) via Google but, I did not find the required information so, I wrote an email to him and he has sent me the link to topic http://sqlasylum.wordpress.com/2011/02/01/invitation-to-t-sql-tuesday-15-automation-in-sql-server. Thanks to Adam Machanicfor doing this wonderful job. This is my first T-SQL Tuesday post. I have referred some of T-SQL Tuesday blog post. This month Pat Wright is hosting and has given us the…
-
-
Setup the Database mail in SQL server using Gmail account
How to setup the DB mail using Gmail account In this article I am going to show the database mail setup steps with screen shots. When I tried to test one of my automation procedure in my friend’s laptop I got number of errors.Then I Goggled and found the solution. Here I am going to share my experience. Database mail is introduced in SQL server 2005 onwards. It is the replacement of the SQLMail with new features. Step by Step DB Mail setup Screen shot After click the send test e-mail go and checks your mail box. While i was testing in SQL server 2005 (9.0.1399) version i got…