Verizon SMTP Port 587

DNN Expert posted on April 30, 2010 06:56

Configure Outlook to use port 587 for sending email In order to change your port 25 settings to port 587 in Outlook, you must do the following: ...

Posted in: E-Mail

Actions: E-mail | Permalink | Comments (0)

30

SQL SPLIT Function

DNN Expert posted on April 30, 2010 05:15

Add the helper SPLIT function to your database CREATE FUNCTION dbo.Split ( @List nvarchar(2000), @SplitOn nvarchar(5) ) RETURNS @RtnVal...

SQL, FUNCTION

Posted in: Microsoft SQL Server

Actions: E-mail | Permalink | Comments (0)

23

DNN Expert posted on April 23, 2010 06:48

Solution was to configure the NTLM security. From Windows 7, click start, type local and open the Local Security Policy Manager. Sele...

Actions: E-mail | Permalink | Comments (0)

21

DNN Expert posted on April 21, 2010 04:54

Within a stored procedure use an IF STATEMENT to check a parameter for a NULL VALUE if( @CustomFieldID is null) begin print 'NUL...

Posted in: Stored Procedures

Actions: E-mail | Permalink | Comments (0)

19

DNN Expert posted on April 19, 2010 05:25

Get the date and time in C# vDate = Convert.ToString(System.DateTime.Today.Date.ToShortDateString()); vTime = Convert.ToString(System.DateTi...

Date, Time

Posted in: C Sharp - C#

Actions: E-mail | Permalink | Comments (0)