Public string ReplaceWithBR(string target) {  Regex regex = new Regex(@"(\r\n|\r|\n)+"); string newText = regex.Replace(target, "<br />...

[Read the rest of this article...]

Functions

Below you will find a few generic SQL queries for generating reports on DNN Users. Last Activity: SELECT     Users.Username, Use...

[Read the rest of this article...]

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: ...

[Read the rest of this article...]

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

[Read the rest of this article...]

SQL, FUNCTION

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

[Read the rest of this article...]

Networking, Windows 7 Professional

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

[Read the rest of this article...]

Stored-Procedure, Null-Value