MOSS Moving Database Server

July 21, 2009
Tags: , ,

There would appear to be many different types of methods to move database servers for the MOSS Databases. the steps below have worked well for me: Build new SQL Server (4xCPU and 4GB RAM) or use exsisting Enable new SQL Server for TCP/IP and listen to all ports Open SQL Server Configuration Manager   Create [...]

1
Filed under:
Microsoft by Luke Smith

ASP SQL Nested Loop doing the Loop

September 24, 2008
Tags: , , , ,

Nesting the loop, Important thing to note make sure that you use recordset   <%@ LANGUAGE=”VBSCRIPT” %> <% response.cachecontrol = “Public” %> <%Response.Buffer = False%> <HTML> <HEAD> <TITLE>Title</TITLE> </HEAD> <% Set conn= Server.CreateObject(“ADODB.Connection”) conn.ConnectionTimeout = Session(“Support_ConnectionTimeout”) conn.CommandTimeout = Session(“Support_CommandTimeout”) conn.Open Session(“Support_ConnectionString”), Session(“Support_RuntimeUserName”), Session(“Support_RuntimePassword”) Set cmdTemp = Server.CreateObject(“ADODB.Command”) Set rs1 = Server.CreateObject(“ADODB.Recordset”) cmdTemp.CommandText = “exec sp” [...]

0
Filed under:
Microsoft by Luke Smith