PROCEDURE GIBS_SEO_Content nvarchar(50) = null   AS BEGIN if (len(@city)=0) begin set @city=null end   SET NOCOUNT ...

[Read the rest of this article...]

Handy for various DNN modules that required a pipe seperated list of states. This list is for StateCode.  

Script to shrink the DNN log file. use inetDNN_DATABASENAME GO BACKUP LOG inetDNN_DATABASENAME WITH TRUNCATE_ONLY GO DBCC SHRINKFILE (inetDNN_DAT...

[Read the rest of this article...]

<add key="PersistentCookieTimeout" value="20160" />

CREATE PROC SearchAllTables ( @SearchStr nvarchar(100) ) AS BEGIN -- Copyright © 2002 Narayana Vyas Kondreddi. A...

[Read the rest of this article...]

<httpRuntime useFullyQualifiedRedirectUrl="true" maxRequestLength="28576" requestLengthDiskThreshold="8192" executionTimeout="4600" />

Create an Inline Scroll Box using CSS.  

  ' INSERT COMMA IN STRING inString="020312181920" strLen=len(inString) xx=1 for x=0 to strLen -2   inPart=mid(instring,xx,2)
...

[Read the rest of this article...]