• The /inc folder simply contained my connections to my SQL server.  Seeing as this is a SQL server specific site, I assumed that people would know how to create databases, tables, and connections to the database.  For those that need help in this area, here is the script to create the table and stored proc.

    USE [MyDatabase]

    GO

    /****** Object:  Table [dbo].[Servers]    Script Date: 08/02/2006 09:06:16 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    SET ANSI_PADDING ON

    GO

    CREATE TABLE [dbo].[Servers](

     [MyDatabase_ID] [int] IDENTITY(1,1) NOT NULL,

     [Name] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

     [Active] [bit] NULL,

     [Location] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

     [Description] [varchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

    ) ON [PRIMARY]

    GO

    SET ANSI_PADDING OFF

    /**************************Stored Procedure**************************/

    USE [MyDatabase]

    GO

    /****** Object:  StoredProcedure [dbo].[spTSWeb]    Script Date: 08/02/2006 09:16:21 ******/

    SET ANSI_NULLS OFF

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    CREATE PROCEDURE [dbo].[spTSWeb] AS

    Select [Name]

     ,Location AS Loc

     ,Description AS Desc

    From Servers

    Where Active = 1

    Order By Location,Servers_Name