zippy1981

Add-Type -AssemblyName "System.Web"

# Powershell function to iterate through all the branches of a
# Visual Studio Solution in SVN, and return the file names in particular subfolders of the database project
# Assumes the command line svn client is in the system path
function Get-ReleaseScripts (
		[string] $branchRoot, 
		[string] $subProject, 
		[string[]] $scriptFolders = ('Ad Hoc Scripts', 'Release Scripts')
	) {

zippy1981

-- Created a simple table for storing state names and postal abbreviations.
SET NOCOUNT ON;

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[States]') AND type in (N'U'))
DROP TABLE [dbo].[States]
GO


CREATE TABLE States (
	Name varchar(30) NOT NULL, --The largest "state" name is 'FEDERATED STATES OF MICRONESIA' which is exactly 30 characters long

zippy1981

--- First we create a login from our user
CREATE LOGIN [domain\justin.dearing] FROM WINDOWS;
GO

-- Now we make him sysadmin
EXEC sp_addsrvrolemember
    @rolename='sysadmin',
    @loginame='domain\justin.dearing'
GO

zippy1981

/*
*
* Copyright (c) 2011 Justin Dearing (zippy1981@gmail.com)
* Dual licensed under the MIT (http://www.opensource.org/licenses/mit-license.php)
* and GPL (http://www.opensource.org/licenses/gpl-license.php) version 2 licenses.
* This software is not distributed under version 3 or later of the GPL.
*
* Version 1.0.0-RC1
*
*/

zippy1981

--
-- Ad Hoc IIS Log analysis
-- Based on code from http://support.microsoft.com/kb/296085
-- Updated to work with the IIS log column config from my 
-- particular inherited Windows 2008 server.
--

DROP TABLE #IISLogs
GO