mylifeinaminute.com

The following are the web templates for MOSS 2007:

To configure connection specific alias, to aid in the installation of databases driven products (such as SharePoint/WSS), you can configure clients connections through the SQL Server Client Network Utility located at C:\WINDOWS\system32\cliconfg.exe.

Daniel Larson has a posting on his blog that explains running your SharePoint code in an elevated privileged environment. Here is a quick helper class.

using System;
using System.Collections.Generic;
using System.Text;

using Microsoft.SharePoint;

namespace SPLibrary
{
    /// <summary>A class for working with elevated privilege</summary>
    [CLSCompliant(false)]
    public static class SpSecurityHelper
    {
        /// <summary>Returns an elevated site</summary>
        /// <param name="theSite">
        /// The site that you want an elevated instance of.
        /// You must dispose of this object unless it is part of SPContext.Current.
        /// </param>
        /// <returns>An elevated site context.</returns>
        /// <remarks>Be sure to dispose of objects created from this method.</remarks>
        public static SPSite GetElevatedSite(SPSite theSite)
        {
            SPUserToken sysToken = GetSystemToken(theSite);
            return new SPSite(theSite.ID, sysToken);
        }

        /// <summary>Gets a UserToken for the system account.</summary>
        /// <param name="site"></param>
        /// <returns>A usertoken for the system account user./returns>
        /// <remarks>Use this token to impersonate the system account</remarks>
        public static SPUserToken GetSystemToken(SPSite site)
        {
            site.CatchAccessDeniedException = false;
            try {
                return site.SystemAccount.UserToken;
            }
            catch (UnauthorizedAccessException) {
                SPUserToken sysToken = null;

                // Only use runwithelevated to grab the system user token.
                SPSecurity.RunWithElevatedPrivileges(
                    delegate()
                    {
                        using (SPSite lolcatKiller = new SPSite(site.ID)) {
                            sysToken = lolcatKiller.SystemAccount.UserToken;
                        }
                    }
                );
                return sysToken;
            }
        }
    }
}

Here is a quick method to aid in transformations of strings (XML and XSL) in C# (.NET 2.0).

        public string Transform(string xml, string xsl, bool useresolver)
        {
            System.IO.StringWriter writer = new System.IO.StringWriter();
            System.Xml.Xsl.XslCompiledTransform t = new System.Xml.Xsl.XslCompiledTransform();
            System.Xml.XmlReaderSettings settings = new System.Xml.XmlReaderSettings();
            System.Xml.XmlUrlResolver resolver = new System.Xml.XmlUrlResolver();
            resolver.Credentials = System.Net.CredentialCache.DefaultCredentials;
            System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create(new System.IO.StringReader(xml));
            System.Xml.XmlReader xslReader = System.Xml.XmlReader.Create(new System.IO.StringReader(xsl));
            if (useresolver)
            {
                t.Load(xslReader, System.Xml.Xsl.XsltSettings.Default, resolver);
            }
            else
            {
                t.Load(xslReader);
            }
            t.Transform(xmlReader, null, writer);
            return writer.ToString();
        }