Loading

Tag Archive: SQL

Jul
21

MOSS Moving Database Server

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 …

Continue reading »

Permanent link to this article: http://www.tsls.co.uk/index.php/2009/07/21/moss-moving-database-server/

Sep
24

ASP SQL Nested Loop doing the Loop

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” …

Continue reading »

Permanent link to this article: http://www.tsls.co.uk/index.php/2008/09/24/asp-nested-loop-doing-the-loop/