Aug
18

The log file for database ‘dtsPackageName’ is full.

DTS error:

The log file for database ‘dtsPackageName’ is full. Back up the transaction log for the database to free up some log space.

Solution:

backup log epack_dev with TRUNCATE_ONLY

May
14

String Functions (Len, Left, Right, Mid)

<%
dim myvar
myvar = “1234567″

response.Write(myvar & ” is the variable<br/>”)

response.Write(len(myvar) & ” characters long<br/>”)

response.Write(left(myvar,3) & ” are the <b>left</b> three characters<br/>”)

response.Write(right(myvar,3) & ” are the <b>right</b> three characters<br/>”)

response.Write(mid(myvar,3,3) & ” : Mid(MyString, StartPos, NumChars)<br/>
%>

Output:

1234567 is the variable

7 characters long

123 are the left three characters

567 are the right three characters

345 : Mid(MyString, StartPos, NumChars)

May
13

ASP: Find the length of a string using len and lenB function

my_string=”Welcome to MySite.com”

Response.Write ( my_string )

Response.Write “Length of this string = ” & len(my_string)

Response.Write “Number of bytes Required for this string = ” & lenB(my_string)

The output of this will also show the number of bytes required. Here in this case it will print this .

Welcome to MySite.com

Length of this string = 21

Number of bytes Required for this string = 42