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 …
Tag Archive: SQL
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” …
Permanent link to this article: http://www.tsls.co.uk/index.php/2008/09/24/asp-nested-loop-doing-the-loop/