Skip to main content

Featured post

How to Insert line break in Text component in React Native

Hi, I was developing an application in react native.I have to handle lots of text data in this small react native application.I have used  Text component in react native many times. While working on this application,i had a requirement to display some text content with line breaks.I will explain it clearly with an example.I want to display a text as shown below  Welcome Please subscribe my channel I wrote react native code as shown below <View> <Text> Welcome Please subscribe my channel </Text> <View> When i run these lines of code,It will display text as shown below Welcome Please subscribe my channel   - instead of displaying in two lines with line break,it displays in a single line.So i have to find a solution to insert line break in Text component in React Native.After lots of research,i found a clean solution as shown below <View> <Text> Welcome{"\n"} Please subscribe my channel </Text> <View> Here ...

How to Create SQL Database Mail Profile and How to Configure SQL Database Mail in SQL Server 2008 SQL Server 2008 R2 SQL Server 2014

Hi friends, I will show how to enable SQL Database Mail  Configurations Step by Step with pictures


Step-1 



I am going to open  SQL Database Mail Configuration Wizard 






Step-2


Click YES





Step-3


Click NEXT 





Step-4

 

Select Set up Database Mail by performing the following tasks


Click NEXT




Step-5


you can give any name for Profile name and Description


For me Profile name - SQLMAIL

             Description - SQL Database Mail


Click ADD





Step-6


Server name:      smtp.gmail.com

Port number:       587


Make sure that  This Server requires a secure connection(SSL) checkbox is marked

you have to give a Gmail account and it's password for basic authentication.


This Gmail account is used as  the from email address for the future emails


User name , Password   and Confirm Password must be correct 


Click OK




Step-7


Click ADD




Step-8


Select Default Profile as YES for SQLMAIL profile 


Click NEXT 




Step-9


Click NEXT





Step-10



Click FINISH






Step-11


Click CLOSE





Step-12


Now We can check our SQL Database Mail Configuration working correctly by using Send Test E-Mail 





Step-13

You have to give receiver email id in To box





Step-14



Click OK






Now Check the receiver email inbox and make sure that you have received a test mail using SQL Database Mail Configuration 


These Steps can be used to configure SQL Database Mail options in SQL Server 2008,SQL Server 2008 R2,SQL Server 2014 
etc