Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\scripts
Extract: ReadMe.htm... 100%
Extract: SSEUtil.exe... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\scripts
Extract: TemplateImageServerDatabase.sql... 100%
Extract: TemplateImageServerRemoveDatabase.sql... 100%
Extract: dbgo.js... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\scripts
Extract: ImageServerDatabase.sql... 100%
Extract: ImageServerDefaultData.sql... 100%
Extract: ImageServerStoredProcedures.sql... 100%
Extract: ImageServerTables.sql... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\scripts
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server
Create folder: C:\Documents and Settings\Administrator\Start Menu\Programs\ClearCanvas\ClearCanvas Image Server
Extract: ClearCanvas.ImageServer.ShredHostService.exe... 100%
Extract: ClearCanvas.ImageServer.ShredHostService.exe.config... 100%
Extract: InstallServerCert.bat... 100%
Extract: Logging.config... 100%
Extract: SetupCertificates.Readme.txt... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\plugins
Extract: ClearCanvas.Enterprise.Common.dll... 100%
Extract: ClearCanvas.Enterprise.Core.dll... 100%
Extract: ClearCanvas.ImageServer.Codec.Jpeg.dll... 100%
Extract: ClearCanvas.ImageServer.Codec.Jpeg2000.dll... 100%
Extract: ClearCanvas.ImageServer.Codec.Rle.dll... 100%
Extract: ClearCanvas.ImageServer.Enterprise.SqlServer2005.dll... 100%
Extract: ClearCanvas.ImageServer.Model.SqlServer2005.dll... 100%
Extract: ClearCanvas.ImageServer.Rules.dll... 100%
Extract: ClearCanvas.ImageServer.Services.Dicom.dll... 100%
Extract: ClearCanvas.ImageServer.Services.ServiceLock.dll... 100%
Extract: ClearCanvas.ImageServer.Services.Shreds.dll... 100%
Extract: ClearCanvas.ImageServer.Services.Streaming.dll... 100%
Extract: ClearCanvas.ImageServer.Services.WorkQueue.dll... 100%
Extract: ClearCanvas.ImageServer.Web.Services.Shreds.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\plugins
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\common
Extract: Castle.DynamicProxy.dll... 100%
Extract: ClearCanvas.Common.dll... 100%
Extract: ClearCanvas.Dicom.Codec.Jpeg.dll... 100%
Extract: ClearCanvas.Dicom.Codec.Jpeg2000.dll... 100%
Extract: ClearCanvas.Dicom.Codec.Rle.dll... 100%
Extract: ClearCanvas.Dicom.OffisWrapper.dll... 100%
Extract: ClearCanvas.Dicom.dll... 100%
Extract: ClearCanvas.DicomServices.dll... 100%
Extract: ClearCanvas.ImageServer.Common.dll... 100%
Extract: ClearCanvas.ImageServer.Enterprise.dll... 100%
Extract: ClearCanvas.ImageServer.Model.dll... 100%
Extract: ClearCanvas.Server.ShredHost.dll... 100%
Extract: Iesi.Collections.dll... 100%
Extract: OffisDcm.dll... 100%
Extract: log4net.dll... 100%
Extract: nunit.framework.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\common
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web
Extract: Default.aspx... 100%
Extract: Logging.config... 100%
Extract: MasterPage.master... 100%
Extract: PrecompiledApp.config
Extract: SR.resx... 100%
Extract: Web.sitemap... 100%
Extract: web.config... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\About
Extract: About.aspx... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\Admin
Extract: Default.aspx... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\Admin\Configuration
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\Admin\Configuration\Devices
Extract: AddEditDeviceDialog.ascx... 100%
Extract: DeviceGridView.ascx... 100%
Extract: DevicePage.aspx... 100%
Extract: DevicePanel.ascx... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\Admin\Configuration\FileSystems
Extract: AddEditFileSystemDialog.ascx... 100%
Extract: FileSystemsGridView.ascx... 100%
Extract: FileSystemsPage.aspx... 100%
Extract: FileSystemsPanel.ascx... 100%
Extract: Filesystem.js... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\Admin\Configuration\Preferences
Extract: Default.aspx... 100%
Extract: Theme.aspx... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\Admin\Configuration\ServerPartitions
Extract: AddEditPartitionDialog.ascx... 100%
Extract: ServerPartitionGridPanel.ascx... 100%
Extract: ServerPartitionPage.aspx... 100%
Extract: ServerPartitionPanel.ascx... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\Admin\Configuration\ServerRules
Extract: AddEditServerRuleDialog.ascx... 100%
Extract: ServerRuleGridView.ascx... 100%
Extract: ServerRulePage.aspx... 100%
Extract: ServerRulePanel.ascx... 100%
Extract: ServerRuleSamples.asmx... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\Admin\Configuration\ServiceLocks
Extract: EditServiceLockDialog.ascx... 100%
Extract: ServiceLockGridView.ascx... 100%
Extract: ServiceLockPage.aspx... 100%
Extract: ServiceLockPanel.ascx... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\App_Themes
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\App_Themes\ClearCanvas
Extract: Global.skin... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\App_Themes\ClearCanvas\StyleSheets
Extract: Accordian.css... 100%
Extract: Filter.css... 100%
Extract: Global.css... 100%
Extract: Header.css... 100%
Extract: Section.css... 100%
Extract: SeriesDetails.css... 100%
Extract: StudyDetails.css... 100%
Extract: Toolbar.css... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\App_Themes\ClearCanvas\StyleSheets\Controls
Extract: Calendar.css... 100%
Extract: Dialog.css... 100%
Extract: GridView.css... 100%
Extract: Tabs.css... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\App_Themes\ClearCanvas\images
Extract: MenuBackground.png... 100%
Extract: Thumbs.db... 100%
Extract: icon_warning.gif
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\App_Themes\ClearCanvas\images\Controls
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\App_Themes\ClearCanvas\images\Controls\Calendar
Extract: TitleBackground.gif... 100%
Extract: calendar-arrow-left.gif... 100%
Extract: calendar-arrow-right.gif... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\App_Themes\ClearCanvas\images\Controls\Dialog
Extract: DialogTitleBarBG-left.gif... 100%
Extract: DialogTitleBarBG-left.png... 100%
Extract: DialogTitleBarBG-right.gif... 100%
Extract: DialogTitleBarBG-right.png... 100%
Extract: DialogTitleBarBG.gif... 100%
Extract: DialogTitleBarBG.png... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\App_Themes\ClearCanvas\images\Controls\GridView
Extract: gridheaderbackground.png... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\App_Themes\ClearCanvas\images\Controls\Tabs
Extract: tab-active-left.gif... 100%
Extract: tab-active-right.gif... 100%
Extract: tab-active.gif... 100%
Extract: tab-hover-left.gif... 100%
Extract: tab-hover-right.gif... 100%
Extract: tab-hover.gif... 100%
Extract: tab-left.gif... 100%
Extract: tab-line.gif... 100%
Extract: tab-right.gif... 100%
Extract: tab.gif... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\App_Themes\ClearCanvas\images\Header
Extract: ClearCanvasLogo.png... 100%
Extract: LocationBackground.png... 100%
Extract: LocationEdge.png... 100%
Extract: MenuBackground.png... 100%
Extract: MenuEdge.png
Extract: StaticMenuHoverBackground.png... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\App_Themes\ClearCanvas\images\MainContent
Extract: MainContentBottom.png... 100%
Extract: MainContentBottomLeftCorner.png
Extract: MainContentBottomRightCorner.png
Extract: MainContentLeftEdge.png... 100%
Extract: MainContentRightEdge.png... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\Common
Extract: BarChart.aspx... 100%
Extract: BasePage.aspx... 100%
Extract: ConfirmationDialog.ascx... 100%
Extract: GridPager.ascx... 100%
Extract: InvalidInputIndicator.ascx... 100%
Extract: ModalDialog.ascx... 100%
Extract: SectionPanel.ascx... 100%
Extract: ServerPartitionTabs.ascx... 100%
Extract: TimedDialog.ascx... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\Docs
Extract: About.htm... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\Scripts
Extract: NumberFormat154.js... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\Search
Extract: SearchPage.aspx... 100%
Extract: SearchPanel.ascx... 100%
Extract: SearchPanel.js... 100%
Extract: StudyListGridView.ascx... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\Search\Move
Extract: DeviceGridView.ascx... 100%
Extract: MovePage.aspx... 100%
Extract: MovePanel.ascx... 100%
Extract: StudyGridView.ascx... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\SeriesDetails
Extract: PatientSummaryPanel.ascx... 100%
Extract: SeriesDetailsPage.aspx... 100%
Extract: SeriesDetailsPanel.ascx... 100%
Extract: SeriesDetailsView.ascx... 100%
Extract: StudySummaryPanel.ascx... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\Service References
Extract: FilesystemServiceProxy.map... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\Services
Extract: FilesystemInfoService.asmx... 100%
Extract: ValidationServices.asmx... 100%
Extract: webservice.htc... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\StudyDetails
Extract: PatientSummaryPanel.ascx... 100%
Extract: SeriesGridView.ascx... 100%
Extract: SeriesGridView.js... 100%
Extract: StudyDetailsPage.aspx... 100%
Extract: StudyDetailsPanel.ascx... 100%
Extract: StudyDetailsPanel.js... 100%
Extract: StudyDetailsView.ascx... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\Styles
Extract: Common.css... 100%
Extract: Menu.css... 100%
Extract: Page.css... 100%
Extract: StyleSheet.css... 100%
Extract: visoft__tab_xpie7.css... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\Styles\images
Extract: Thumbs.db... 100%
Extract: icon_warning.gif
Extract: tab-active-left.gif... 100%
Extract: tab-active-right.gif... 100%
Extract: tab-active.gif... 100%
Extract: tab-hover-left.gif... 100%
Extract: tab-hover-right.gif... 100%
Extract: tab-hover.gif... 100%
Extract: tab-left.gif... 100%
Extract: tab-line.gif... 100%
Extract: tab-right.gif... 100%
Extract: tab.gif... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\WorkQueue
Extract: SearchPage.aspx... 100%
Extract: SearchPanel.ascx... 100%
Extract: SearchPanel.js... 100%
Extract: WorkQueueItemListPanel.ascx... 100%
Extract: WorkQueueSettings.settings... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\WorkQueue\Edit
Extract: AutoRouteWorkQueueDetailsView.ascx... 100%
Extract: DeleteWorkQueueDialog.ascx... 100%
Extract: GeneralWorkQueueDetailsView.ascx... 100%
Extract: ResetWorkQueueDialog.ascx... 100%
Extract: ScheduleWorkQueueDialog.ascx... 100%
Extract: ViewEdit.aspx... 100%
Extract: WebMoveStudyWorkQueueDetailsView.ascx... 100%
Extract: WorkQueueItemDetailsPanel.ascx... 100%
Extract: WorkQueueSettingsPanel.ascx... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\bin
Extract: AjaxControlToolkit.dll... 100%
Extract: Castle.DynamicProxy.dll... 100%
Extract: ClearCanvas.Common.dll... 100%
Extract: ClearCanvas.Dicom.OffisWrapper.dll... 100%
Extract: ClearCanvas.Dicom.dll... 100%
Extract: ClearCanvas.DicomServices.dll... 100%
Extract: ClearCanvas.Enterprise.Common.dll... 100%
Extract: ClearCanvas.Enterprise.Core.dll... 100%
Extract: ClearCanvas.ImageServer.Common.dll... 100%
Extract: ClearCanvas.ImageServer.Enterprise.dll... 100%
Extract: ClearCanvas.ImageServer.Model.dll... 100%
Extract: ClearCanvas.ImageServer.Web.Application.Assembly.dll... 100%
Extract: ClearCanvas.ImageServer.Web.Application.Assembly.dll.LOCKED... 100%
Extract: ClearCanvas.ImageServer.Web.Common.dll... 100%
Extract: Validators.dll... 100%
Extract: log4net.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\bin\ar
Extract: AjaxControlToolkit.resources.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\bin\cs
Extract: AjaxControlToolkit.resources.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\bin\de
Extract: AjaxControlToolkit.resources.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\bin\es
Extract: AjaxControlToolkit.resources.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\bin\fr
Extract: AjaxControlToolkit.resources.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\bin\he
Extract: AjaxControlToolkit.resources.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\bin\hi
Extract: AjaxControlToolkit.resources.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\bin\it
Extract: AjaxControlToolkit.resources.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\bin\ja
Extract: AjaxControlToolkit.resources.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\bin\ko
Extract: AjaxControlToolkit.resources.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\bin\nl
Extract: AjaxControlToolkit.resources.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\bin\pt
Extract: AjaxControlToolkit.resources.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\bin\ru
Extract: AjaxControlToolkit.resources.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\bin\tr-TR
Extract: AjaxControlToolkit.resources.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\bin\zh-CHS
Extract: AjaxControlToolkit.resources.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\bin\zh-CHT
Extract: AjaxControlToolkit.resources.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\images
Extract: CCLogo.png
Extract: LogoSmall.png
Extract: Plus.ico... 100%
Extract: Right.gif
Extract: Splash.png... 100%
Extract: Thumbs.db... 100%
Extract: Watermark.gif... 100%
Extract: blank.gif... 100%
Extract: blankfeature.gif... 100%
Extract: checked_small.gif... 100%
Extract: checked_tall.gif... 100%
Extract: dimbackground.gif... 100%
Extract: filter.gif
Extract: filter_disabled.gif... 100%
Extract: filter_on.gif... 100%
Extract: icon_warning.gif... 100%
Extract: icon_warning.png
Extract: icon_warning2.gif... 100%
Extract: left.gif
Extract: next.gif... 100%
Extract: next_disabled.gif... 100%
Extract: noquery.gif... 100%
Extract: noretrieve.gif... 100%
Extract: prev.gif... 100%
Extract: prev_disabled.gif... 100%
Extract: query.gif... 100%
Extract: retrieve.gif... 100%
Extract: storage.gif... 100%
Extract: test.html... 100%
Extract: unchecked_small.gif... 100%
Extract: unchecked_tall.gif... 100%
Extract: usage.png
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\images\icons
Extract: AddDisabled.png
Extract: AddEnabled.png
Extract: AutoRouteSmall.png
Extract: BackDisabled.png
Extract: BackEnabled.png
Extract: ClearDate.png
Extract: DeleteDisabled.png
Extract: DeleteEnabled.png
Extract: EditDisabled.png
Extract: EditEnabled.png
Extract: EraserEnabled.png
Extract: ForwardDisabled.png
Extract: ForwardEnabled.png
Extract: HelpSmall.png
Extract: ImageServerLogo.png
Extract: QueryDisabled.png
Extract: QueryEnabled.png
Extract: QuerySmall.png
Extract: RefreshDisabled.png
Extract: RefreshEnabled.png
Extract: ResetDisabled.png
Extract: ResetEnabled.png
Extract: RetrieveSmall.png
Extract: ScheduleDisabled.png
Extract: ScheduleEnabled.png
Extract: SendDisabled.png
Extract: SendEnabled.png
Extract: StoreSmall.png
Extract: Thumbs.db... 100%
Extract: ViewDetailsDisabled.png
Extract: ViewDetailsEnabled.png
Extract: calendar-arrow-left.png... 100%
Extract: calendar-arrow-right.png... 100%
Extract: close.png... 100%
Extract: eraser.gif... 100%
Extract: icon_warning.png
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\images\logos
Extract: ImageServerLogo.png
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web\plugins
Extract: ClearCanvas.ImageServer.Enterprise.SqlServer2005.dll... 100%
Extract: ClearCanvas.ImageServer.Model.SqlServer2005.dll... 100%
Extract: ClearCanvas.ImageServer.Rules.dll... 100%
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server\web
Configuring Web
Generating App.Config file
Generating database creation script
Generating database removal script for uninstaller
Generating script utility
Creating database...

> USE [master]
> GO

Command completed successfully.

> /****** Object:  Database [ImageServer]    Script Date: 07/23/2007 17:16:02 ******/
> CREATE DATABASE [ImageServer] ON  PRIMARY 
> ( NAME = N'ImageServer', FILENAME = N'd:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ImageServer.mdf' , SIZE = 2240KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
>  FILEGROUP [INDEXES] 
> ( NAME = N'ImageServer_Indexes', FILENAME = N'd:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ImageServer Indexes.ndf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
>  FILEGROUP [QUEUES] 
> ( NAME = N'ImageServer Queues', FILENAME = N'd:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ImageServer Queues.ndf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
>  FILEGROUP [STATIC] 
> ( NAME = N'ImageServer Static Tables', FILENAME = N'd:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ImageServer Static Tables.ndf' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
>  LOG ON 
> ( NAME = N'ImageServer_log', FILENAME = N'd:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ImageServer_log.LDF' , SIZE = 768KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
> GO

Command completed successfully.

> EXEC dbo.sp_dbcmptlevel @dbname=N'ImageServer', @new_cmptlevel=90
> GO

Command completed successfully.

> IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
> begin
> EXEC [ImageServer].[dbo].[sp_fulltext_database] @action = 'enable'
> end
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET ANSI_NULL_DEFAULT OFF 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET ANSI_NULLS OFF 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET ANSI_PADDING OFF 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET ANSI_WARNINGS OFF 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET ARITHABORT OFF 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET AUTO_CLOSE OFF 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET AUTO_CREATE_STATISTICS ON 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET AUTO_SHRINK OFF 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET AUTO_UPDATE_STATISTICS ON 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET CURSOR_CLOSE_ON_COMMIT OFF 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET CURSOR_DEFAULT  GLOBAL 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET CONCAT_NULL_YIELDS_NULL OFF 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET NUMERIC_ROUNDABORT OFF 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET QUOTED_IDENTIFIER OFF 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET RECURSIVE_TRIGGERS OFF 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET  ENABLE_BROKER 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET DATE_CORRELATION_OPTIMIZATION OFF 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET TRUSTWORTHY OFF 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET ALLOW_SNAPSHOT_ISOLATION OFF 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET PARAMETERIZATION SIMPLE 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET  READ_WRITE 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET RECOVERY FULL 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET  MULTI_USER 
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET PAGE_VERIFY CHECKSUM  
> GO

Command completed successfully.

> ALTER DATABASE [ImageServer] SET DB_CHAINING OFF 
Playback completed for command file 'TemplateImageServerDatabase.sql'.
Creating database tables...

> USE [ImageServer]
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[ServerTransferSyntax]    Script Date: 01/09/2008 15:04:01 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ServerTransferSyntax]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[ServerTransferSyntax](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_ServerTransferSyntax_GUID]  DEFAULT (newid()),
>          [Uid] [varchar](64) NOT NULL,
>          [Description] [nvarchar](256) NOT NULL,
>          [Enabled] [bit] NOT NULL,
>          [Lossless] [bit] NOT NULL,
>  CONSTRAINT [PK_ServerTransferSyntax] PRIMARY KEY CLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [STATIC]
> ) ON [STATIC]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[DuplicateSopPolicyEnum]    Script Date: 04/29/2008 14:56:14 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DuplicateSopPolicyEnum]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[DuplicateSopPolicyEnum](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_DuplicateSopPolicyEnum_GUID]  DEFAULT (newid()),
>          [Enum] [smallint] NOT NULL,
>          [Lookup] [varchar](32) NOT NULL,
>          [Description] [nvarchar](32) NOT NULL,
>          [LongDescription] [nvarchar](128) NOT NULL,
>  CONSTRAINT [PK_DuplicateSopPolicyEnum] PRIMARY KEY CLUSTERED 
> (
>          [Enum] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [STATIC]
> ) ON [STATIC]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[ServerPartition]    Script Date: 01/09/2008 15:03:51 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ServerPartition]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[ServerPartition](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_ServerPartition_GUID]  DEFAULT (newid()),
>          [Enabled] [bit] NOT NULL,
>          [Description] [nvarchar](128) NOT NULL,
>          [AeTitle] [varchar](16) NOT NULL,
>          [Port] [int] NOT NULL,
>          [PartitionFolder] [nvarchar](16) NOT NULL,
>          [AcceptAnyDevice] [bit] NOT NULL CONSTRAINT [DF_ServerPartition_AcceptAnyDevice]  DEFAULT ((1)),
>          [AutoInsertDevice] [bit] NOT NULL CONSTRAINT [DF_ServerPartition_AutoInsertDevice]  DEFAULT ((1)),
>          [DefaultRemotePort] [int] NOT NULL CONSTRAINT [DF_ServerPartition_DefaultRemotePort]  DEFAULT ((104)),
>          [StudyCount] [int] NOT NULL CONSTRAINT [DF_ServerPartition_StudyCount]  DEFAULT ((0)),
>          [DuplicateSopPolicyEnum] [smallint] NOT NULL,
>  CONSTRAINT [PK_ServerPartition] PRIMARY KEY CLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
> ) ON [PRIMARY]
> END
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ServerPartition]') AND name = N'IX_ServerPartition')
> CREATE UNIQUE NONCLUSTERED INDEX [IX_ServerPartition] ON [dbo].[ServerPartition] 
> (
>          [AeTitle] ASC
> )WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [INDEXES]
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[WorkQueueStatusEnum]    Script Date: 01/09/2008 15:04:27 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WorkQueueStatusEnum]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[WorkQueueStatusEnum](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_WorkQueueStatusEnum_GUID]  DEFAULT (newid()),
>          [Enum] [smallint] NOT NULL,
>          [Lookup] [varchar](32) NOT NULL,
>          [Description] [nvarchar](32) NOT NULL,
>          [LongDescription] [nvarchar](128) NOT NULL,
>  CONSTRAINT [PK_WorkQueueStatusEnum] PRIMARY KEY CLUSTERED 
> (
>          [Enum] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [STATIC]
> ) ON [STATIC]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> 
> /****** Object:  Table [dbo].[StudyStatusEnum]    Script Date: 01/09/2008 15:04:16 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[StudyStatusEnum]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[StudyStatusEnum](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_StudyStatusEnum_GUID]  DEFAULT (newid()),
>          [Enum] [smallint] NOT NULL,
>          [Lookup] [varchar](32) NOT NULL,
>          [Description] [nvarchar](32) NOT NULL,
>          [LongDescription] [nvarchar](128) NOT NULL,
>  CONSTRAINT [PK_StudyStatusEnum] PRIMARY KEY CLUSTERED 
> (
>          [Enum] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [STATIC]
> ) ON [STATIC]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[WorkQueueTypeEnum]    Script Date: 01/09/2008 15:04:29 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WorkQueueTypeEnum]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[WorkQueueTypeEnum](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_WorkQueueTypeEnum_GUID]  DEFAULT (newid()),
>          [Enum] [smallint] NOT NULL,
>          [Lookup] [varchar](32) NOT NULL,
>          [Description] [nvarchar](32) NOT NULL,
>          [LongDescription] [nvarchar](128) NOT NULL,
>  CONSTRAINT [PK_WorkQueueTypeEnum] PRIMARY KEY CLUSTERED 
> (
>          [Enum] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [STATIC]
> ) ON [STATIC]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[ServerSopClass]    Script Date: 01/09/2008 15:04:00 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ServerSopClass]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[ServerSopClass](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_SopClass_GUID]  DEFAULT (newid()),
>          [SopClassUid] [varchar](64) NOT NULL,
>          [Description] [nvarchar](128) NOT NULL,
>          [NonImage] [bit] NOT NULL,
>  CONSTRAINT [PK_SopClass] PRIMARY KEY CLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [STATIC]
> ) ON [STATIC]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ServerSopClass]') AND name = N'IX_SopClass_SopClassUid')
> CREATE UNIQUE NONCLUSTERED INDEX [IX_SopClass_SopClassUid] ON [dbo].[ServerSopClass] 
> (
>          [SopClassUid] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [STATIC]
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[ServiceLockTypeEnum]    Script Date: 01/09/2008 15:04:05 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ServiceLockTypeEnum]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[ServiceLockTypeEnum](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_ServiceLockTypeEnum_GUID]  DEFAULT (newid()),
>          [Enum] [smallint] NOT NULL,
>          [Lookup] [varchar](32) NOT NULL,
>          [Description] [nvarchar](32) NOT NULL,
>          [LongDescription] [nvarchar](128) NOT NULL,
>  CONSTRAINT [PK_ServiceLockTypeEnum] PRIMARY KEY CLUSTERED 
> (
>          [Enum] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [STATIC]
> ) ON [STATIC]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[ServerRuleTypeEnum]    Script Date: 01/09/2008 15:03:58 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ServerRuleTypeEnum]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[ServerRuleTypeEnum](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_ServerRuleTypeEnum_GUID]  DEFAULT (newid()),
>          [Enum] [smallint] NOT NULL,
>          [Lookup] [varchar](32) NOT NULL,
>          [Description] [nvarchar](32) NOT NULL,
>          [LongDescription] [nvarchar](128) NOT NULL,
>  CONSTRAINT [PK_ServerRuleTypeEnum] PRIMARY KEY CLUSTERED 
> (
>          [Enum] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [STATIC]
> ) ON [STATIC]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[ServerRuleApplyTimeEnum]    Script Date: 01/09/2008 15:03:56 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ServerRuleApplyTimeEnum]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[ServerRuleApplyTimeEnum](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_ServerRuleApplyTimeEnum_GUID]  DEFAULT (newid()),
>          [Enum] [smallint] NOT NULL,
>          [Lookup] [varchar](32) NOT NULL,
>          [Description] [nvarchar](32) NOT NULL,
>          [LongDescription] [nvarchar](128) NOT NULL,
>  CONSTRAINT [PK_ServerRuleApplyTimeEnum] PRIMARY KEY CLUSTERED 
> (
>          [Enum] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [STATIC]
> ) ON [STATIC]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[FilesystemTierEnum]    Script Date: 01/09/2008 15:03:38 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FilesystemTierEnum]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[FilesystemTierEnum](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_FilesystemTierEnum_GUID]  DEFAULT (newid()),
>          [Enum] [smallint] NOT NULL,
>          [Lookup] [varchar](32) NOT NULL,
>          [Description] [nvarchar](32) NOT NULL,
>          [LongDescription] [nvarchar](128) NOT NULL,
>  CONSTRAINT [PK_FilesystemTier] PRIMARY KEY CLUSTERED 
> (
>          [Enum] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [STATIC]
> ) ON [STATIC]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[FilesystemQueueTypeEnum]    Script Date: 01/09/2008 15:03:36 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FilesystemQueueTypeEnum]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[FilesystemQueueTypeEnum](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_FilesystemQueueTypeEnum_GUID]  DEFAULT (newid()),
>          [Enum] [smallint] NOT NULL,
>          [Lookup] [varchar](32) NOT NULL,
>          [Description] [nvarchar](32) NOT NULL,
>          [LongDescription] [nvarchar](128) NOT NULL,
>  CONSTRAINT [PK_FilesystemQueueTypeEnum] PRIMARY KEY CLUSTERED 
> (
>          [Enum] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [STATIC]
> ) ON [STATIC]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> 
> /****** Object:  Table [dbo].[WorkQueuePriorityEnum]    Script Date: 03/12/2008 14:30:42 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[[WorkQueuePriorityEnum]]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[WorkQueuePriorityEnum](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_WorkQueuePriorityEnum_GUID]  DEFAULT (newid()),
>          [Enum] [smallint] NOT NULL,
>          [Lookup] [varchar](32) NOT NULL,
>          [Description] [nvarchar](32) NOT NULL,
>          [LongDescription] [nvarchar](128) NOT NULL,
>  CONSTRAINT [PK_WorkQueuePriorityEnum] PRIMARY KEY CLUSTERED 
> (
>          [Enum] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [STATIC]
> ) ON [STATIC]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> 
> /****** Object:  Table [dbo].[DevicePreferredTransferSyntax]    Script Date: 01/09/2008 15:03:27 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DevicePreferredTransferSyntax]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[DevicePreferredTransferSyntax](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_DevicePreferredTransferSyntax_GUID]  DEFAULT (newid()),
>          [DeviceGUID] [uniqueidentifier] NOT NULL,
>          [ServerSopClassGUID] [uniqueidentifier] NOT NULL,
>          [ServerTransferSyntaxGUID] [uniqueidentifier] NOT NULL,
>  CONSTRAINT [PK_DevicePreferredTransferSyntax] PRIMARY KEY NONCLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> ) ON [PRIMARY]
> END
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[DevicePreferredTransferSyntax]') AND name = N'IX_DevicePreferredTransferSyntax')
> CREATE CLUSTERED INDEX [IX_DevicePreferredTransferSyntax] ON [dbo].[DevicePreferredTransferSyntax] 
> (
>          [DeviceGUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[ServerRule]    Script Date: 01/09/2008 15:03:54 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ServerRule]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[ServerRule](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_ServerRule_GUID]  DEFAULT (newid()),
>          [RuleName] [nvarchar](128) NOT NULL,
>          [ServerPartitionGUID] [uniqueidentifier] NOT NULL,
>          [ServerRuleTypeEnum] [smallint] NOT NULL,
>          [ServerRuleApplyTimeEnum] [smallint] NOT NULL,
>          [Enabled] [bit] NOT NULL,
>          [DefaultRule] [bit] NOT NULL,
>          [RuleXml] [xml] NOT NULL,
>  CONSTRAINT [PK_ServerRule] PRIMARY KEY CLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
> ) ON [PRIMARY]
> END
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[WorkQueue]    Script Date: 01/09/2008 15:04:24 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WorkQueue]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[WorkQueue](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_WorkQueue_GUID]  DEFAULT (newid()),
>          [ServerPartitionGUID] [uniqueidentifier] NOT NULL,
>          [StudyStorageGUID] [uniqueidentifier] NOT NULL,
>          [DeviceGUID] [uniqueidentifier] NULL,
>          [WorkQueueTypeEnum] [smallint] NOT NULL,
>          [WorkQueueStatusEnum] [smallint] NOT NULL, 
>          [WorkQueuePriorityEnum] [smallint] NOT NULL CONSTRAINT [DF_WorkQueue_WorkQueuePriorityEnum]  DEFAULT ((200)),
>          [ProcessorID] [varchar](256) NULL,
>          [ExpirationTime] [datetime] NULL,
>          [ScheduledTime] [datetime] NOT NULL,
>          [InsertTime] [datetime] NOT NULL CONSTRAINT [DF_WorkQueue_InsertTime]  DEFAULT (getdate()),
>          [FailureCount] [int] NOT NULL CONSTRAINT [DF_WorkQueue_FailureCount]  DEFAULT ((0)),
>          [FailureDescription] [nvarchar](256) NULL,
>          [Data] [xml] NULL,
>  CONSTRAINT [PK_WorkQueue] PRIMARY KEY CLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [QUEUES]
> ) ON [QUEUES]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[WorkQueue]') AND name = N'IX_WorkQueue_ScheduledTime')
> CREATE NONCLUSTERED INDEX [IX_WorkQueue_ScheduledTime] ON [dbo].[WorkQueue] 
> (
>          [ScheduledTime] ASC
> )
> INCLUDE ( [WorkQueueStatusEnum]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[WorkQueue]') AND name = N'IX_WorkQueue_StudyStorageGUID')
> CREATE NONCLUSTERED INDEX [IX_WorkQueue_StudyStorageGUID] ON [dbo].[WorkQueue] 
> (
>          [StudyStorageGUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> GO

Command completed successfully.

> 
> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[WorkQueue]') AND name = N'IX_WorkQueue_WorkQueuePriorityEnum')
> CREATE NONCLUSTERED INDEX [IX_WorkQueue_WorkQueuePriorityEnum] ON [dbo].[WorkQueue] 
> (
>          [WorkQueuePriorityEnum] ASC
> )WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [INDEXES]
> GO

Command completed successfully.

> 
> /****** Object:  Table [dbo].[Series]    Script Date: 01/09/2008 15:03:48 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Series]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[Series](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_Series_GUID]  DEFAULT (newid()),
>          [ServerPartitionGUID] [uniqueidentifier] NOT NULL,
>          [StudyGUID] [uniqueidentifier] NOT NULL,
>          [SeriesInstanceUid] [varchar](64) NOT NULL,
>          [Modality] [varchar](16) NOT NULL,
>          [SeriesNumber] [varchar](12) NULL,
>          [SeriesDescription] [nvarchar](64) NULL,
>          [NumberOfSeriesRelatedInstances] [int] NOT NULL,
>          [PerformedProcedureStepStartDate] [varchar](8) NULL,
>          [PerformedProcedureStepStartTime] [varchar](16) NULL,
>          [SourceApplicationEntityTitle] [varchar](16) NULL,
>          [StudyStatusEnum] [smallint] NOT NULL,
>  CONSTRAINT [PK_Series] PRIMARY KEY NONCLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> ) ON [PRIMARY]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Series]') AND name = N'IX_Series_StudyGUID_SeriesInstanceUid')
> CREATE UNIQUE CLUSTERED INDEX [IX_Series_StudyGUID_SeriesInstanceUid] ON [dbo].[Series] 
> (
>          [StudyGUID] ASC,
>          [SeriesInstanceUid] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Series]') AND name = N'IX_Series_Modality')
> CREATE NONCLUSTERED INDEX [IX_Series_Modality] ON [dbo].[Series] 
> (
>          [Modality] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[Study]    Script Date: 01/09/2008 15:04:14 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Study]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[Study](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_Study_GUID]  DEFAULT (newid()),
>          [ServerPartitionGUID] [uniqueidentifier] NOT NULL,
>          [PatientGUID] [uniqueidentifier] NOT NULL,
>          [SpecificCharacterSet] varchar(128) NULL,
>          [StudyInstanceUid] [varchar](64) NOT NULL,
>          [PatientsName] [nvarchar](64) NULL,
>          [PatientId] [nvarchar](64) NULL,
>          [PatientsBirthDate] [varchar](8) NULL,
>          [PatientsSex] [varchar](2) NULL,
>          [StudyDate] [varchar](8) NULL,
>          [StudyTime] [varchar](16) NULL,
>          [AccessionNumber] [nvarchar](16) NULL,
>          [StudyId] [nvarchar](16) NULL,
>          [StudyDescription] [nvarchar](64) NULL,
>          [ReferringPhysiciansName] [nvarchar](64) NULL,
>          [NumberOfStudyRelatedSeries] [int] NOT NULL,
>          [NumberOfStudyRelatedInstances] [int] NOT NULL,
>          [StudyStatusEnum] [smallint] NOT NULL,
>  CONSTRAINT [PK_Study] PRIMARY KEY CLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
> ) ON [PRIMARY]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Study]') AND name = N'IX_Study_AccessionNumber')
> CREATE NONCLUSTERED INDEX [IX_Study_AccessionNumber] ON [dbo].[Study] 
> (
>          [AccessionNumber] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Study]') AND name = N'IX_Study_PatientGUID')
> CREATE NONCLUSTERED INDEX [IX_Study_PatientGUID] ON [dbo].[Study] 
> (
>          [PatientGUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Study]') AND name = N'IX_Study_PatientId')
> CREATE NONCLUSTERED INDEX [IX_Study_PatientId] ON [dbo].[Study] 
> (
>          [PatientId] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Study]') AND name = N'IX_Study_PatientsName')
> CREATE NONCLUSTERED INDEX [IX_Study_PatientsName] ON [dbo].[Study] 
> (
>          [PatientsName] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Study]') AND name = N'IX_Study_StudyDate')
> CREATE NONCLUSTERED INDEX [IX_Study_StudyDate] ON [dbo].[Study] 
> (
>          [StudyDate] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Study]') AND name = N'IX_Study_StudyDescription')
> CREATE NONCLUSTERED INDEX [IX_Study_StudyDescription] ON [dbo].[Study] 
> (
>          [StudyDescription] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Study]') AND name = N'IX_Study_StudyInstanceUid')
> CREATE UNIQUE NONCLUSTERED INDEX [IX_Study_StudyInstanceUid] ON [dbo].[Study] 
> (
>          [StudyInstanceUid] ASC,
>          [ServerPartitionGUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[PartitionSopClass]    Script Date: 01/09/2008 15:03:39 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PartitionSopClass]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[PartitionSopClass](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_PartitionSopClass_GUID]  DEFAULT (newid()),
>          [ServerPartitionGUID] [uniqueidentifier] NOT NULL,
>          [ServerSopClassGUID] [uniqueidentifier] NOT NULL,
>          [Enabled] [bit] NOT NULL,
>  CONSTRAINT [PK_PartitionSopClass] PRIMARY KEY CLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
> ) ON [PRIMARY]
> END
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[StudyStorage]    Script Date: 01/09/2008 15:04:19 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[StudyStorage]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[StudyStorage](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_StudyStorage_GUID]  DEFAULT (newid()),
>          [ServerPartitionGUID] [uniqueidentifier] NOT NULL,
>          [StudyInstanceUid] [varchar](64) NOT NULL,
>          [InsertTime] [datetime] NOT NULL CONSTRAINT [DF_StudyStorage_InsertTime]  DEFAULT (getdate()),
>          [LastAccessedTime] [datetime] NOT NULL CONSTRAINT [DF_StudyStorage_LastAccessedTime]  DEFAULT (getdate()),
>          [Lock] [bit] NOT NULL CONSTRAINT [DF_StudyStorage_Lock]  DEFAULT ((0)),
>          [StudyStatusEnum] [smallint] NOT NULL,
>  CONSTRAINT [PK_StudyStorage] PRIMARY KEY CLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
> ) ON [PRIMARY]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[StudyStorage]') AND name = N'IX_StudyStorage_PartitionGUID_StudyInstanceUid')
> CREATE UNIQUE NONCLUSTERED INDEX [IX_StudyStorage_PartitionGUID_StudyInstanceUid] ON [dbo].[StudyStorage] 
> (
>          [ServerPartitionGUID] ASC,
>          [StudyInstanceUid] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[Patient]    Script Date: 01/09/2008 15:03:42 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Patient]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[Patient](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_Patient_GUID]  DEFAULT (newid()),
>          [ServerPartitionGUID] [uniqueidentifier] NOT NULL,
>          [PatientsName] [nvarchar](64) NULL,
>          [PatientId] [nvarchar](64) NULL,
>          [IssuerOfPatientId] [nvarchar](64) NULL,
>          [NumberOfPatientRelatedStudies] [int] NOT NULL,
>          [NumberOfPatientRelatedSeries] [int] NOT NULL,
>          [NumberOfPatientRelatedInstances] [int] NOT NULL,
>          [SpecificCharacterSet] varchar(128) NULL
>  CONSTRAINT [PK_Patient] PRIMARY KEY CLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
> ) ON [PRIMARY]
> END
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[Device]    Script Date: 04/23/2008 23:48:21 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Device]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[Device](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_Device_GUID]  DEFAULT (newid()),
>          [ServerPartitionGUID] [uniqueidentifier] NOT NULL,
>          [AeTitle] [varchar](16) NOT NULL,
>          [IpAddress] [varchar](16) NULL,
>          [Port] [int] NOT NULL,
>          [Description] [nvarchar](256) NULL,
>          [Dhcp] [bit] NOT NULL,
>          [Enabled] [bit] NOT NULL,
>          [AllowStorage] [bit] NOT NULL CONSTRAINT [DF_Device_StorageFlag]  DEFAULT ((0)),
>          [AllowRetrieve] [bit] NOT NULL CONSTRAINT [DF_Device_AllowRetrieve]  DEFAULT ((0)),
>          [AllowQuery] [bit] NOT NULL CONSTRAINT [DF_Device_AllowQuery]  DEFAULT ((0)),
>          [AllowAutoRoute] [bit] NOT NULL CONSTRAINT [DF_Device_AllowAutoRoute]  DEFAULT ((1)),
>  CONSTRAINT [PK_Device] PRIMARY KEY NONCLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
> ) ON [PRIMARY]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[FilesystemQueue]    Script Date: 01/09/2008 15:03:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FilesystemQueue]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[FilesystemQueue](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_FilesystemQueue_GUID]  DEFAULT (newid()),
>          [FilesystemQueueTypeEnum] [smallint] NOT NULL,
>          [StudyStorageGUID] [uniqueidentifier] NOT NULL,
>          [FilesystemGUID] [uniqueidentifier] NOT NULL,
>          [ScheduledTime] [datetime] NOT NULL,
>          [SeriesInstanceUid] [varchar](64) NULL,
>  CONSTRAINT [PK_FilesystemQueue] PRIMARY KEY NONCLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> ) ON [QUEUES]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[FilesystemQueue]') AND name = N'IXC_FilesystemQueue')
> CREATE CLUSTERED INDEX [IXC_FilesystemQueue] ON [dbo].[FilesystemQueue] 
> (
>          [FilesystemGUID] ASC,
>          [ScheduledTime] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [QUEUES]
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[FilesystemQueue]') AND name = N'IX_FilesystemQueue_StudyStorageGUID')
> CREATE UNIQUE NONCLUSTERED INDEX [IX_FilesystemQueue_StudyStorageGUID] ON [dbo].[FilesystemQueue] 
> (
>          [StudyStorageGUID] ASC,
>          [FilesystemQueueTypeEnum] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[ServiceLock]    Script Date: 01/09/2008 15:04:03 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ServiceLock]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[ServiceLock](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_ServiceLock_GUID]  DEFAULT (newid()),
>          [ServiceLockTypeEnum] [smallint] NOT NULL,
>          [ProcessorId] [varchar](256) NULL,
>          [Lock] [bit] NOT NULL,
>          [ScheduledTime] [datetime] NOT NULL,
>          [FilesystemGUID] [uniqueidentifier] NULL,
>          [Enabled] [bit] NOT NULL CONSTRAINT [DF_ServiceLock_Enabled]  DEFAULT ((1)),
>  CONSTRAINT [PK_ServiceLock] PRIMARY KEY CLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
> ) ON [PRIMARY]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[StorageFilesystem]    Script Date: 01/09/2008 15:04:07 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[StorageFilesystem]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[StorageFilesystem](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_StorageFilesystem_GUID]  DEFAULT (newid()),
>          [StudyStorageGUID] [uniqueidentifier] NOT NULL,
>          [FilesystemGUID] [uniqueidentifier] NOT NULL,
>          [StudyFolder] [varchar](8) NOT NULL,
>  CONSTRAINT [PK_StorageFilesystem] PRIMARY KEY NONCLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> ) ON [PRIMARY]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[StorageFilesystem]') AND name = N'IX_StorageFilesystem_StudyStorageGUID')
> CREATE CLUSTERED INDEX [IX_StorageFilesystem_StudyStorageGUID] ON [dbo].[StorageFilesystem] 
> (
>          [StudyStorageGUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[StorageFilesystem]') AND name = N'IX_StorageFilesystem_FilesystemGUID')
> CREATE NONCLUSTERED INDEX [IX_StorageFilesystem_FilesystemGUID] ON [dbo].[StorageFilesystem] 
> (
>          [FilesystemGUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[WorkQueueUid]    Script Date: 01/09/2008 15:04:30 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> SET ANSI_PADDING ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WorkQueueUid]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[WorkQueueUid](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_WorkQueueInstance_GUID]  DEFAULT (newid()),
>          [WorkQueueGUID] [uniqueidentifier] NOT NULL,
>          [SeriesInstanceUid] [varchar](64) NULL,
>          [SopInstanceUid] [varchar](64) NULL,
>          [Failed] [bit] NOT NULL CONSTRAINT [DF_WorkQueueUid_Failed]  DEFAULT ((0)),
>          [Duplicate] [bit] NOT NULL CONSTRAINT [DF_WorkQueueUid_Duplicate]  DEFAULT ((0)),
>          [Extension] [varchar](10) NULL,
>          [FailureCount] [smallint] NOT NULL CONSTRAINT [DF_WorkQueueUid_FailureCount]  DEFAULT ((0)),
>  CONSTRAINT [PK_WorkQueueUid] PRIMARY KEY NONCLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [QUEUES]
> ) ON [QUEUES]
> END
> GO

Command completed successfully.

> SET ANSI_PADDING OFF
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[WorkQueueUid]') AND name = N'IX_WorkQueueUid')
> CREATE CLUSTERED INDEX [IX_WorkQueueUid] ON [dbo].[WorkQueueUid] 
> (
>          [WorkQueueGUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 65) ON [QUEUES]
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[RequestAttributes]    Script Date: 01/09/2008 15:03:44 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RequestAttributes]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[RequestAttributes](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_RequestAttribute_GUID]  DEFAULT (newid()),
>          [SeriesGUID] [uniqueidentifier] NOT NULL,
>          [RequestedProcedureId] [nvarchar](16) NULL,
>          [ScheduledProcedureStepId] [nvarchar](16) NULL,
>  CONSTRAINT [PK_RequestAttribute] PRIMARY KEY NONCLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [INDEXES]
> ) ON [PRIMARY]
> END
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[RequestAttributes]') AND name = N'IX_RequestAttribute_SeriesGUID')
> CREATE CLUSTERED INDEX [IX_RequestAttribute_SeriesGUID] ON [dbo].[RequestAttributes] 
> (
>          [SeriesGUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
> GO

Command completed successfully.

> /****** Object:  Table [dbo].[Filesystem]    Script Date: 01/09/2008 15:03:31 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Filesystem]') AND type in (N'U'))
> BEGIN
> CREATE TABLE [dbo].[Filesystem](
>          [GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_Filesystem_GUID]  DEFAULT (newid()),
>          [FilesystemPath] [nvarchar](256) NOT NULL,
>          [Enabled] [bit] NOT NULL,
>          [ReadOnly] [bit] NOT NULL,
>          [WriteOnly] [bit] NOT NULL,
>          [Description] [nvarchar](128) NULL,
>          [FilesystemTierEnum] [smallint] NOT NULL,
>          [LowWatermark] [decimal](8, 4) NOT NULL CONSTRAINT [DF_Filesystem_LowWatermark]  DEFAULT ((80.00)),
>          [HighWatermark] [decimal](8, 4) NOT NULL CONSTRAINT [DF_Filesystem_HighWatermark]  DEFAULT ((90.00)),
>  CONSTRAINT [PK_Filesystem] PRIMARY KEY CLUSTERED 
> (
>          [GUID] ASC
> )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [STATIC]
> ) ON [STATIC]
> END
> GO

Command completed successfully.

> 
> 
> /****** Object:  ForeignKey [FK_Device_ServerPartition]    Script Date: 01/09/2008 15:03:26 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Device_ServerPartition]') AND parent_object_id = OBJECT_ID(N'[dbo].[Device]'))
> ALTER TABLE [dbo].[Device]  WITH CHECK ADD  CONSTRAINT [FK_Device_ServerPartition] FOREIGN KEY([ServerPartitionGUID])
> REFERENCES [dbo].[ServerPartition] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[Device] CHECK CONSTRAINT [FK_Device_ServerPartition]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_DevicePreferredTransferSyntax_Device]    Script Date: 01/09/2008 15:03:27 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_DevicePreferredTransferSyntax_Device]') AND parent_object_id = OBJECT_ID(N'[dbo].[DevicePreferredTransferSyntax]'))
> ALTER TABLE [dbo].[DevicePreferredTransferSyntax]  WITH CHECK ADD  CONSTRAINT [FK_DevicePreferredTransferSyntax_Device] FOREIGN KEY([DeviceGUID])
> REFERENCES [dbo].[Device] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[DevicePreferredTransferSyntax] CHECK CONSTRAINT [FK_DevicePreferredTransferSyntax_Device]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_DevicePreferredTransferSyntax_ServerSopClass]    Script Date: 01/09/2008 15:03:28 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_DevicePreferredTransferSyntax_ServerSopClass]') AND parent_object_id = OBJECT_ID(N'[dbo].[DevicePreferredTransferSyntax]'))
> ALTER TABLE [dbo].[DevicePreferredTransferSyntax]  WITH CHECK ADD  CONSTRAINT [FK_DevicePreferredTransferSyntax_ServerSopClass] FOREIGN KEY([ServerSopClassGUID])
> REFERENCES [dbo].[ServerSopClass] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[DevicePreferredTransferSyntax] CHECK CONSTRAINT [FK_DevicePreferredTransferSyntax_ServerSopClass]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_DevicePreferredTransferSyntax_ServerTransferSyntax]    Script Date: 01/09/2008 15:03:28 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_DevicePreferredTransferSyntax_ServerTransferSyntax]') AND parent_object_id = OBJECT_ID(N'[dbo].[DevicePreferredTransferSyntax]'))
> ALTER TABLE [dbo].[DevicePreferredTransferSyntax]  WITH CHECK ADD  CONSTRAINT [FK_DevicePreferredTransferSyntax_ServerTransferSyntax] FOREIGN KEY([ServerTransferSyntaxGUID])
> REFERENCES [dbo].[ServerTransferSyntax] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[DevicePreferredTransferSyntax] CHECK CONSTRAINT [FK_DevicePreferredTransferSyntax_ServerTransferSyntax]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_Filesystem_FilesystemTierEnum]    Script Date: 01/09/2008 15:03:31 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Filesystem_FilesystemTierEnum]') AND parent_object_id = OBJECT_ID(N'[dbo].[Filesystem]'))
> ALTER TABLE [dbo].[Filesystem]  WITH CHECK ADD  CONSTRAINT [FK_Filesystem_FilesystemTierEnum] FOREIGN KEY([FilesystemTierEnum])
> REFERENCES [dbo].[FilesystemTierEnum] ([Enum])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[Filesystem] CHECK CONSTRAINT [FK_Filesystem_FilesystemTierEnum]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_FilesystemQueue_Filesystem]    Script Date: 01/09/2008 15:03:34 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_FilesystemQueue_Filesystem]') AND parent_object_id = OBJECT_ID(N'[dbo].[FilesystemQueue]'))
> ALTER TABLE [dbo].[FilesystemQueue]  WITH CHECK ADD  CONSTRAINT [FK_FilesystemQueue_Filesystem] FOREIGN KEY([FilesystemGUID])
> REFERENCES [dbo].[Filesystem] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[FilesystemQueue] CHECK CONSTRAINT [FK_FilesystemQueue_Filesystem]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_FilesystemQueue_FilesystemQueueTypeEnum]    Script Date: 01/09/2008 15:03:34 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_FilesystemQueue_FilesystemQueueTypeEnum]') AND parent_object_id = OBJECT_ID(N'[dbo].[FilesystemQueue]'))
> ALTER TABLE [dbo].[FilesystemQueue]  WITH CHECK ADD  CONSTRAINT [FK_FilesystemQueue_FilesystemQueueTypeEnum] FOREIGN KEY([FilesystemQueueTypeEnum])
> REFERENCES [dbo].[FilesystemQueueTypeEnum] ([Enum])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[FilesystemQueue] CHECK CONSTRAINT [FK_FilesystemQueue_FilesystemQueueTypeEnum]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_FilesystemQueue_StudyStorage]    Script Date: 01/09/2008 15:03:34 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_FilesystemQueue_StudyStorage]') AND parent_object_id = OBJECT_ID(N'[dbo].[FilesystemQueue]'))
> ALTER TABLE [dbo].[FilesystemQueue]  WITH CHECK ADD  CONSTRAINT [FK_FilesystemQueue_StudyStorage] FOREIGN KEY([StudyStorageGUID])
> REFERENCES [dbo].[StudyStorage] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[FilesystemQueue] CHECK CONSTRAINT [FK_FilesystemQueue_StudyStorage]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_PartitionSopClass_ServerPartition]    Script Date: 01/09/2008 15:03:39 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_PartitionSopClass_ServerPartition]') AND parent_object_id = OBJECT_ID(N'[dbo].[PartitionSopClass]'))
> ALTER TABLE [dbo].[PartitionSopClass]  WITH CHECK ADD  CONSTRAINT [FK_PartitionSopClass_ServerPartition] FOREIGN KEY([ServerPartitionGUID])
> REFERENCES [dbo].[ServerPartition] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[PartitionSopClass] CHECK CONSTRAINT [FK_PartitionSopClass_ServerPartition]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_PartitionSopClass_ServerSopClass]    Script Date: 01/09/2008 15:03:39 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_PartitionSopClass_ServerSopClass]') AND parent_object_id = OBJECT_ID(N'[dbo].[PartitionSopClass]'))
> ALTER TABLE [dbo].[PartitionSopClass]  WITH CHECK ADD  CONSTRAINT [FK_PartitionSopClass_ServerSopClass] FOREIGN KEY([ServerSopClassGUID])
> REFERENCES [dbo].[ServerSopClass] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[PartitionSopClass] CHECK CONSTRAINT [FK_PartitionSopClass_ServerSopClass]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_Patient_ServerPartition]    Script Date: 01/09/2008 15:03:42 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Patient_ServerPartition]') AND parent_object_id = OBJECT_ID(N'[dbo].[Patient]'))
> ALTER TABLE [dbo].[Patient]  WITH CHECK ADD  CONSTRAINT [FK_Patient_ServerPartition] FOREIGN KEY([ServerPartitionGUID])
> REFERENCES [dbo].[ServerPartition] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[Patient] CHECK CONSTRAINT [FK_Patient_ServerPartition]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_RequestAttribute_Series]    Script Date: 01/09/2008 15:03:44 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RequestAttribute_Series]') AND parent_object_id = OBJECT_ID(N'[dbo].[RequestAttributes]'))
> ALTER TABLE [dbo].[RequestAttributes]  WITH CHECK ADD  CONSTRAINT [FK_RequestAttribute_Series] FOREIGN KEY([SeriesGUID])
> REFERENCES [dbo].[Series] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[RequestAttributes] CHECK CONSTRAINT [FK_RequestAttribute_Series]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_Series_ServerPartition]    Script Date: 01/09/2008 15:03:48 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Series_ServerPartition]') AND parent_object_id = OBJECT_ID(N'[dbo].[Series]'))
> ALTER TABLE [dbo].[Series]  WITH CHECK ADD  CONSTRAINT [FK_Series_ServerPartition] FOREIGN KEY([ServerPartitionGUID])
> REFERENCES [dbo].[ServerPartition] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[Series] CHECK CONSTRAINT [FK_Series_ServerPartition]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_Series_StatusEnum]    Script Date: 01/09/2008 15:03:48 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Series_StatusEnum]') AND parent_object_id = OBJECT_ID(N'[dbo].[Series]'))
> ALTER TABLE [dbo].[Series]  WITH CHECK ADD  CONSTRAINT [FK_Series_StatusEnum] FOREIGN KEY([StudyStatusEnum])
> REFERENCES [dbo].[StudyStatusEnum] ([Enum])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[Series] CHECK CONSTRAINT [FK_Series_StatusEnum]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_Series_Study]    Script Date: 01/09/2008 15:03:48 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Series_Study]') AND parent_object_id = OBJECT_ID(N'[dbo].[Series]'))
> ALTER TABLE [dbo].[Series]  WITH CHECK ADD  CONSTRAINT [FK_Series_Study] FOREIGN KEY([StudyGUID])
> REFERENCES [dbo].[Study] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[Series] CHECK CONSTRAINT [FK_Series_Study]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_ServerRule_ServerPartition]    Script Date: 01/09/2008 15:03:54 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ServerRule_ServerPartition]') AND parent_object_id = OBJECT_ID(N'[dbo].[ServerRule]'))
> ALTER TABLE [dbo].[ServerRule]  WITH CHECK ADD  CONSTRAINT [FK_ServerRule_ServerPartition] FOREIGN KEY([ServerPartitionGUID])
> REFERENCES [dbo].[ServerPartition] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[ServerRule] CHECK CONSTRAINT [FK_ServerRule_ServerPartition]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_ServerRule_ServerRuleApplyTimeEnum]    Script Date: 01/09/2008 15:03:54 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ServerRule_ServerRuleApplyTimeEnum]') AND parent_object_id = OBJECT_ID(N'[dbo].[ServerRule]'))
> ALTER TABLE [dbo].[ServerRule]  WITH CHECK ADD  CONSTRAINT [FK_ServerRule_ServerRuleApplyTimeEnum] FOREIGN KEY([ServerRuleApplyTimeEnum])
> REFERENCES [dbo].[ServerRuleApplyTimeEnum] ([Enum])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[ServerRule] CHECK CONSTRAINT [FK_ServerRule_ServerRuleApplyTimeEnum]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_ServerRule_ServerRuleTypeEnum]    Script Date: 01/09/2008 15:03:54 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ServerRule_ServerRuleTypeEnum]') AND parent_object_id = OBJECT_ID(N'[dbo].[ServerRule]'))
> ALTER TABLE [dbo].[ServerRule]  WITH CHECK ADD  CONSTRAINT [FK_ServerRule_ServerRuleTypeEnum] FOREIGN KEY([ServerRuleTypeEnum])
> REFERENCES [dbo].[ServerRuleTypeEnum] ([Enum])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[ServerRule] CHECK CONSTRAINT [FK_ServerRule_ServerRuleTypeEnum]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_ServiceLock_Filesystem]    Script Date: 01/09/2008 15:04:04 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ServiceLock_Filesystem]') AND parent_object_id = OBJECT_ID(N'[dbo].[ServiceLock]'))
> ALTER TABLE [dbo].[ServiceLock]  WITH CHECK ADD  CONSTRAINT [FK_ServiceLock_Filesystem] FOREIGN KEY([FilesystemGUID])
> REFERENCES [dbo].[Filesystem] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[ServiceLock] CHECK CONSTRAINT [FK_ServiceLock_Filesystem]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_ServiceLock_ServiceLockTypeEnum]    Script Date: 01/09/2008 15:04:04 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ServiceLock_ServiceLockTypeEnum]') AND parent_object_id = OBJECT_ID(N'[dbo].[ServiceLock]'))
> ALTER TABLE [dbo].[ServiceLock]  WITH CHECK ADD  CONSTRAINT [FK_ServiceLock_ServiceLockTypeEnum] FOREIGN KEY([ServiceLockTypeEnum])
> REFERENCES [dbo].[ServiceLockTypeEnum] ([Enum])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[ServiceLock] CHECK CONSTRAINT [FK_ServiceLock_ServiceLockTypeEnum]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_StorageFilesystem_Filesystem]    Script Date: 01/09/2008 15:04:07 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_StorageFilesystem_Filesystem]') AND parent_object_id = OBJECT_ID(N'[dbo].[StorageFilesystem]'))
> ALTER TABLE [dbo].[StorageFilesystem]  WITH CHECK ADD  CONSTRAINT [FK_StorageFilesystem_Filesystem] FOREIGN KEY([FilesystemGUID])
> REFERENCES [dbo].[Filesystem] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[StorageFilesystem] CHECK CONSTRAINT [FK_StorageFilesystem_Filesystem]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_StorageFilesystem_StudyStorage]    Script Date: 01/09/2008 15:04:07 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_StorageFilesystem_StudyStorage]') AND parent_object_id = OBJECT_ID(N'[dbo].[StorageFilesystem]'))
> ALTER TABLE [dbo].[StorageFilesystem]  WITH CHECK ADD  CONSTRAINT [FK_StorageFilesystem_StudyStorage] FOREIGN KEY([StudyStorageGUID])
> REFERENCES [dbo].[StudyStorage] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[StorageFilesystem] CHECK CONSTRAINT [FK_StorageFilesystem_StudyStorage]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_Study_Patient]    Script Date: 01/09/2008 15:04:14 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Study_Patient]') AND parent_object_id = OBJECT_ID(N'[dbo].[Study]'))
> ALTER TABLE [dbo].[Study]  WITH CHECK ADD  CONSTRAINT [FK_Study_Patient] FOREIGN KEY([PatientGUID])
> REFERENCES [dbo].[Patient] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[Study] CHECK CONSTRAINT [FK_Study_Patient]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_Study_ServerPartition]    Script Date: 01/09/2008 15:04:14 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Study_ServerPartition]') AND parent_object_id = OBJECT_ID(N'[dbo].[Study]'))
> ALTER TABLE [dbo].[Study]  WITH CHECK ADD  CONSTRAINT [FK_Study_ServerPartition] FOREIGN KEY([ServerPartitionGUID])
> REFERENCES [dbo].[ServerPartition] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[Study] CHECK CONSTRAINT [FK_Study_ServerPartition]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_Study_StatusEnum]    Script Date: 01/09/2008 15:04:14 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Study_StatusEnum]') AND parent_object_id = OBJECT_ID(N'[dbo].[Study]'))
> ALTER TABLE [dbo].[Study]  WITH CHECK ADD  CONSTRAINT [FK_Study_StatusEnum] FOREIGN KEY([StudyStatusEnum])
> REFERENCES [dbo].[StudyStatusEnum] ([Enum])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[Study] CHECK CONSTRAINT [FK_Study_StatusEnum]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_StudyStorage_ServerPartition]    Script Date: 01/09/2008 15:04:19 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_StudyStorage_ServerPartition]') AND parent_object_id = OBJECT_ID(N'[dbo].[StudyStorage]'))
> ALTER TABLE [dbo].[StudyStorage]  WITH CHECK ADD  CONSTRAINT [FK_StudyStorage_ServerPartition] FOREIGN KEY([ServerPartitionGUID])
> REFERENCES [dbo].[ServerPartition] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[StudyStorage] CHECK CONSTRAINT [FK_StudyStorage_ServerPartition]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_StudyStorage_StudyStatusEnum]    Script Date: 01/09/2008 15:04:20 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_StudyStorage_StudyStatusEnum]') AND parent_object_id = OBJECT_ID(N'[dbo].[StudyStorage]'))
> ALTER TABLE [dbo].[StudyStorage]  WITH CHECK ADD  CONSTRAINT [FK_StudyStorage_StudyStatusEnum] FOREIGN KEY([StudyStatusEnum])
> REFERENCES [dbo].[StudyStatusEnum] ([Enum])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[StudyStorage] CHECK CONSTRAINT [FK_StudyStorage_StudyStatusEnum]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_WorkQueue_Device]    Script Date: 01/09/2008 15:04:24 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_WorkQueue_Device]') AND parent_object_id = OBJECT_ID(N'[dbo].[WorkQueue]'))
> ALTER TABLE [dbo].[WorkQueue]  WITH CHECK ADD  CONSTRAINT [FK_WorkQueue_Device] FOREIGN KEY([DeviceGUID])
> REFERENCES [dbo].[Device] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[WorkQueue] CHECK CONSTRAINT [FK_WorkQueue_Device]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_WorkQueue_ServerPartition]    Script Date: 01/09/2008 15:04:25 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_WorkQueue_ServerPartition]') AND parent_object_id = OBJECT_ID(N'[dbo].[WorkQueue]'))
> ALTER TABLE [dbo].[WorkQueue]  WITH CHECK ADD  CONSTRAINT [FK_WorkQueue_ServerPartition] FOREIGN KEY([ServerPartitionGUID])
> REFERENCES [dbo].[ServerPartition] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[WorkQueue] CHECK CONSTRAINT [FK_WorkQueue_ServerPartition]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_WorkQueue_StudyStorage]    Script Date: 01/09/2008 15:04:25 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_WorkQueue_StudyStorage]') AND parent_object_id = OBJECT_ID(N'[dbo].[WorkQueue]'))
> ALTER TABLE [dbo].[WorkQueue]  WITH CHECK ADD  CONSTRAINT [FK_WorkQueue_StudyStorage] FOREIGN KEY([StudyStorageGUID])
> REFERENCES [dbo].[StudyStorage] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[WorkQueue] CHECK CONSTRAINT [FK_WorkQueue_StudyStorage]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_WorkQueue_WorkQueueStatusEnum]    Script Date: 01/09/2008 15:04:25 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_WorkQueue_WorkQueueStatusEnum]') AND parent_object_id = OBJECT_ID(N'[dbo].[WorkQueue]'))
> ALTER TABLE [dbo].[WorkQueue]  WITH CHECK ADD  CONSTRAINT [FK_WorkQueue_WorkQueueStatusEnum] FOREIGN KEY([WorkQueueStatusEnum])
> REFERENCES [dbo].[WorkQueueStatusEnum] ([Enum])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[WorkQueue] CHECK CONSTRAINT [FK_WorkQueue_WorkQueueStatusEnum]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_WorkQueue_WorkQueueTypeEnum]    Script Date: 01/09/2008 15:04:25 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_WorkQueue_WorkQueueTypeEnum]') AND parent_object_id = OBJECT_ID(N'[dbo].[WorkQueue]'))
> ALTER TABLE [dbo].[WorkQueue]  WITH CHECK ADD  CONSTRAINT [FK_WorkQueue_WorkQueueTypeEnum] FOREIGN KEY([WorkQueueTypeEnum])
> REFERENCES [dbo].[WorkQueueTypeEnum] ([Enum])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[WorkQueue] CHECK CONSTRAINT [FK_WorkQueue_WorkQueueTypeEnum]
> GO

Command completed successfully.

> /****** Object:  ForeignKey [FK_WorkQueue_WorkQueuePriorityEnum]    Script Date: 01/09/2008 15:04:30 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_WorkQueue_WorkQueuePriorityEnum]') AND parent_object_id = OBJECT_ID(N'[dbo].[WorkQueue]'))
> ALTER TABLE [dbo].[WorkQueue]  WITH CHECK ADD  CONSTRAINT [FK_WorkQueue_WorkQueuePriorityEnum] FOREIGN KEY([WorkQueuePriorityEnum])
> REFERENCES [dbo].[WorkQueuePriorityEnum] ([Enum])
> GO

Command completed successfully.

> 
> /****** Object:  ForeignKey [FK_WorkQueueUid_WorkQueue]    Script Date: 01/09/2008 15:04:30 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_WorkQueueUid_WorkQueue]') AND parent_object_id = OBJECT_ID(N'[dbo].[WorkQueueUid]'))
> ALTER TABLE [dbo].[WorkQueueUid]  WITH CHECK ADD  CONSTRAINT [FK_WorkQueueUid_WorkQueue] FOREIGN KEY([WorkQueueGUID])
> REFERENCES [dbo].[WorkQueue] ([GUID])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[WorkQueueUid] CHECK CONSTRAINT [FK_WorkQueueUid_WorkQueue]
> GO

Command completed successfully.

> 
> /****** Object:  ForeignKey [FK_ServerPartition_DuplicateSopPolicyEnum]    Script Date: 04/29/2008 14:56:18 ******/
> IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ServerPartition_DuplicateSopPolicyEnum]') AND parent_object_id = OBJECT_ID(N'[dbo].[ServerPartition]'))
> ALTER TABLE [dbo].[ServerPartition]  WITH CHECK ADD  CONSTRAINT [FK_ServerPartition_DuplicateSopPolicyEnum] FOREIGN KEY([DuplicateSopPolicyEnum])
> REFERENCES [dbo].[DuplicateSopPolicyEnum] ([Enum])
> GO

Command completed successfully.

> ALTER TABLE [dbo].[ServerPartition] CHECK CONSTRAINT [FK_ServerPartition_DuplicateSopPolicyEnum]
> GO

Command completed successfully.

Playback completed for command file 'ImageServerTables.sql'.
Inserting default data...

> -- WorkQueueTypeEnum inserts
> INSERT INTO [ImageServer].[dbo].[WorkQueueTypeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),100,'StudyProcess','Process Study','Processing of a new incoming study.')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[WorkQueueTypeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),101,'AutoRoute','Auto Route','DICOM Auto-route request.')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[WorkQueueTypeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),102,'DeleteStudy','Delete Study','Automatic deletion of a Study.')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[WorkQueueTypeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),103,'WebDeleteStudy','Web Delete Study','Manual study delete via the Web UI.')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[WorkQueueTypeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),104,'WebMoveStudy','Web Move Study','Manual DICOM move of a study via the Web UI.')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[WorkQueueTypeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),105,'WebEditStudy','Web Edit Study','Manual study edit via the Web UI.')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[WorkQueueTypeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),106,'CleanupStudy','Cleanup Study','Cleanup all unprocessed or failed instances within a study.')
> GO

1 row(s) affected.

> 
> 
> -- WorkQueueStatusEnum inserts
> INSERT INTO [ImageServer].[dbo].[WorkQueueStatusEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),100,'Idle','Idle','Waiting to expire or for more images')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[WorkQueueStatusEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),200,'Pending','Pending','Pending')
> GO

1 row(s) affected.

> 
> 
> INSERT INTO [ImageServer].[dbo].[WorkQueueStatusEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),201,'In Progress','In Progress','In Progress')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[WorkQueueStatusEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),202,'Completed','Completed','The Queue entry is completed.')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[WorkQueueStatusEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),203,'Failed','Failed','The Queue entry has failed.')
> GO

1 row(s) affected.

> 
> -- FilesystemTierEnum
> INSERT INTO [ImageServer].[dbo].[FilesystemTierEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),101,'Tier1','Tier 1','Filesystem Tier 1')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[FilesystemTierEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),102,'Tier2','Tier 2','Filesystem Tier 2')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[FilesystemTierEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),103,'Tier3','Tier 3','Filesystem Tier 3')
> GO

1 row(s) affected.

> 
> -- ServerRuleTypeEnum inserts
> INSERT INTO [ImageServer].[dbo].[ServerRuleTypeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),100,'AutoRoute','Auto Routing','A DICOM auto-routing rule')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerRuleTypeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),101,'StudyDelete','Study Delete','A rule to specify when to delete a study')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerRuleTypeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),102,'Tier1Retention','Tier1 Retention','A rule to specify how long a study will be retained on Tier1')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerRuleTypeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),103,'OnlineRetention','Online Retention','A rule to specify how long a study will be retained online')
> GO

1 row(s) affected.

> 
> 
> --  WorkQueuePriorityEnum inserts
> INSERT INTO [ImageServer].[dbo].WorkQueuePriorityEnum
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),100,'Low','Low','Low priority')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].WorkQueuePriorityEnum
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),200,'Medium','Medium','Medium priority')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].WorkQueuePriorityEnum
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),300,'High','High','High priority')
> GO

1 row(s) affected.

> 
> 
> 
> -- ServerRuleApplyTimeEnum inserts
> INSERT INTO [ImageServer].[dbo].[ServerRuleApplyTimeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),100,'SopReceived','SOP Received','Apply rule when a SOP Instance has been received')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerRuleApplyTimeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),101,'SopProcessed','SOP Processed','Apply rule when a SOP Instance has been processed')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerRuleApplyTimeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),102,'SeriesProcessed','Series Processed','Apply rule when a Series is initially processed')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerRuleApplyTimeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),103,'StudyProcessed','Study Processed','Apply rule when a Study is initially processed')
> GO

1 row(s) affected.

> 
> -- FilesystemQueueTypeEnum inserts
> INSERT INTO [ImageServer].[dbo].[FilesystemQueueTypeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),100,'DeleteStudy','Delete Study','Delete a Study')
> GO

1 row(s) affected.

>            
> INSERT INTO [ImageServer].[dbo].[FilesystemQueueTypeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),101,'PurgeStudy','Purge Study','Purge an Online Study')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[FilesystemQueueTypeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),102,'TierMigrate','Tier Migrate','Migrate a Study to a Lower Tier')
> GO

1 row(s) affected.

> 
> -- ServiceLockTypeEnum inserts
> INSERT INTO [ImageServer].[dbo].[ServiceLockTypeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),100,'FilesystemDelete','Filesystem Delete','Purge Data from a Filesystem')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServiceLockTypeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),101,'FilesystemReinventory','Filesystem Reinventory','Re-inventory Data within a Filesystem')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServiceLockTypeEnum]
>            ([GUID],[Enum],[Lookup],[Description],[LongDescription])
>      VALUES
>            (newid(),102,'FilesystemStudyProcess','Filesystem Reprocess Studies','Reapply Study Processing rules within a Filesystem')
> GO

1 row(s) affected.

> 
> 
> -- ServerSopClass inserts
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.9.1.1', '12-lead ECG Waveform Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.9.1.3', 'Ambulatory ECG Waveform Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.88.11', 'Basic Text SR', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.9.4.1', 'Basic Voice Audio Waveform Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.11.4', 'Blending Softcopy Presentation State Storage SOP Class', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.9.3.1', 'Cardiac Electrophysiology Waveform Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.88.65', 'Chest CAD SR', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.11.2', 'Color Softcopy Presentation State Storage SOP Class', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.88.33', 'Comprehensive SR', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.1', 'Computed Radiography Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.2', 'CT Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.66.3', 'Deformable Spatial Registration Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.1.3', 'Digital Intra-oral X-Ray Image Storage ? For Presentation', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.1.3.1', 'Digital Intra-oral X-Ray Image Storage ? For Processing', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.1.2', 'Digital Mammography X-Ray Image Storage ? For Presentation', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.1.2.1', 'Digital Mammography X-Ray Image Storage ? For Processing', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.1.1', 'Digital X-Ray Image Storage ? For Presentation', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.1.1.1', 'Digital X-Ray Image Storage ? For Processing', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.104.1', 'Encapsulated PDF Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.2.1', 'Enhanced CT Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.4.1', 'Enhanced MR Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.88.22', 'Enhanced SR', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.12.1.1', 'Enhanced XA Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.12.2.1', 'Enhanced XRF Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.9.1.2', 'General ECG Waveform Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.11.1', 'Grayscale Softcopy Presentation State Storage SOP Class', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.1.29', 'Hardcopy  Grayscale Image Storage SOP Class (Retired)', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.1.30', 'Hardcopy Color Image Storage SOP Class (Retired)', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.9.2.1', 'Hemodynamic Waveform Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.88.59', 'Key Object Selection Document', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.88.50', 'Mammography CAD SR', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.4', 'MR Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.4.2', 'MR Spectroscopy Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.7.2', 'Multi-frame Grayscale Byte Secondary Capture Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.7.3', 'Multi-frame Grayscale Word Secondary Capture Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.7.1', 'Multi-frame Single Bit Secondary Capture Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.7.4', 'Multi-frame 1 Color Secondary Capture Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.5', 'Nuclear Medicine Image  Storage (Retired)', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.20', 'Nuclear Medicine Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.77.1.5.2', 'Ophthalmic Photography 16 Bit Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.77.1.5.1', 'Ophthalmic Photography 8 Bit Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.128', 'Positron Emission Tomography Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.88.40', 'Procedure Log Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.11.3', 'Pseudo-Color Softcopy Presentation State Storage SOP Class', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.66', 'Raw Data Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.67', 'Real World Value Mapping Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.481.4', 'RT Beams Treatment Record Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.481.6', 'RT Brachy Treatment Record Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.481.2', 'RT Dose Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.481.1', 'RT Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.481.9', 'RT Ion Beams Treatment Record Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.481.8', 'RT Ion Plan Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.481.5', 'RT Plan Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.481.3', 'RT Structure Set Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.481.7', 'RT Treatment Summary Record Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.7', 'Secondary Capture Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.66.4', 'Segmentation Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.66.2', 'Spatial Fiducials Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.66.1', 'Spatial Registration Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.9', 'Standalone Curve Storage (Retired)', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.10', 'Standalone Modality LUT Storage (Retired)', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.8', 'Standalone Overlay Storage (Retired)', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.129', 'Standalone PET Curve Storage (Retired)', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.11', 'Standalone VOI LUT Storage (Retired)', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.77.1.5.3', 'Stereometric Relationship Storage', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.1.27', 'Stored Print Storage SOP Class (Retired)', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.6.1', 'Ultrasound Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.6', 'Ultrasound Image Storage (Retired)', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.3.1', 'Ultrasound Multi-frame Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.3', 'Ultrasound Multi-frame Image Storage (Retired)', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.77.1.1.1', 'Video Endoscopic Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.77.1.2.1', 'Video Microscopic Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.77.1.4.1', 'Video Photographic Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.77.1.1', 'VL Endoscopic Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.77.1.2', 'VL Microscopic Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.77.1.4', 'VL Photographic Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.77.1.3', 'VL Slide-Coordinates Microscopic Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.12.3', 'X-Ray Angiographic Bi-Plane Image Storage (Retired)', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.12.1', 'X-Ray Angiographic Image Storage', 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.88.67', 'X-Ray Radiation Dose SR', 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.12.2', 'X-Ray Radiofluoroscopic Image Storage', 0)
> GO

1 row(s) affected.

>      
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.13.1.1', 'X-Ray 3D Angiographic Image Storage', 0);
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.13.1.2', 'X-Ray 3D Craniofacial Image Storage', 0);
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.77.1.5.4', 'Ophthalmic Tomography Image Storage', 0);
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerSopClass] ([GUID],[SopClassUid],[Description],[NonImage])
> VALUES (newid(), '1.2.840.10008.5.1.4.1.1.104.2', 'Encapsulated CDA Storage', 1);
> GO

1 row(s) affected.

> 
> 
> -- ServerTransferSyntax inserts
> INSERT INTO [ImageServer].[dbo].[ServerTransferSyntax] ([GUID],[Uid],[Description],[Enabled],[Lossless])
> VALUES (newid(), '1.2.840.10008.1.2.2', 'Explicit VR Big Endian', 0, 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerTransferSyntax] ([GUID],[Uid],[Description],[Enabled],[Lossless])
> VALUES (newid(), '1.2.840.10008.1.2.1', 'Explicit VR Little Endian', 1, 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerTransferSyntax] ([GUID],[Uid],[Description],[Enabled],[Lossless])
> VALUES (newid(), '1.2.840.10008.1.2', 'Implicit VR Little Endian: Default Transfer Syntax for DICOM', 1, 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerTransferSyntax] ([GUID],[Uid],[Description],[Enabled],[Lossless])
> VALUES (newid(), '1.2.840.10008.1.2.4.91', 'JPEG 2000 Image Compression', 1, 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerTransferSyntax] ([GUID],[Uid],[Description],[Enabled],[Lossless])
> VALUES (newid(), '1.2.840.10008.1.2.4.90', 'JPEG 2000 Image Compression (Lossless Only)', 1, 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerTransferSyntax] ([GUID],[Uid],[Description],[Enabled],[Lossless])
> VALUES (newid(), '1.2.840.10008.1.2.4.50', 'JPEG Baseline (Process 1)', 1, 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerTransferSyntax] ([GUID],[Uid],[Description],[Enabled],[Lossless])
> VALUES (newid(), '1.2.840.10008.1.2.4.51', 'JPEG Extended (Process 2 & 4)', 1, 0)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerTransferSyntax] ([GUID],[Uid],[Description],[Enabled],[Lossless])
> VALUES (newid(), '1.2.840.10008.1.2.4.70', 'JPEG Lossless, non-Hierarchical, First-Order Prediction (Process 14 [Selection Value 1])', 1, 1)
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[ServerTransferSyntax] ([GUID],[Uid],[Description],[Enabled],[Lossless])
> VALUES (newid(), '1.2.840.10008.1.2.5', 'RLE Lossless', 1, 1)
> GO

1 row(s) affected.

> 
> 
> -- [StudyStatusEnum] inserts
> INSERT INTO [ImageServer].[dbo].[StudyStatusEnum]([GUID],[Enum],[Lookup],[Description],[LongDescription])
> VALUES(newid(),100,'Online','Online','Study is online')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].[StudyStatusEnum]([GUID],[Enum],[Lookup],[Description],[LongDescription])
> VALUES(newid(),200,'Pending','Pending','Pending')
> GO

1 row(s) affected.

> 
> 
> -- DuplicateSopPolicyEnum inserts
> INSERT INTO [ImageServer].[dbo].DuplicateSopPolicyEnum([GUID],[Enum],[Lookup],[Description],[LongDescription])
> VALUES(newid(),100,'SendSuccess','Send Success','Send a DICOM C-STORE-RSP success status when receiving a duplicate, but ignore the file.')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].DuplicateSopPolicyEnum([GUID],[Enum],[Lookup],[Description],[LongDescription])
> VALUES(newid(),101,'RejectDuplicates','Reject Duplicates','Send a DICOM C-STORE-RSP reject status when receiving a duplicate.')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].DuplicateSopPolicyEnum([GUID],[Enum],[Lookup],[Description],[LongDescription])
> VALUES(newid(),102,'AcceptLatest','Accept Latest','Keep the latest object received.')
> GO

1 row(s) affected.

> 
> INSERT INTO [ImageServer].[dbo].DuplicateSopPolicyEnum([GUID],[Enum],[Lookup],[Description],[LongDescription])
> VALUES(newid(),103,'CompareDuplicates','Compare Duplicates','Process duplicate objects received and compare them to originals flagging any differences as a failure.')
> GO

1 row(s) affected.

Playback completed for command file 'ImageServerDefaultData.sql'.
Creating stored procedures...

> USE [ImageServer]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[QueryFilesystemQueue]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QueryFilesystemQueue]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[QueryFilesystemQueue]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertWorkQueueDeleteStudy]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertWorkQueueDeleteStudy]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[InsertWorkQueueDeleteStudy]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertFilesystemQueue]    Script Date: 01/08/2008 16:04:33 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertFilesystemQueue]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[InsertFilesystemQueue]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[DeleteStudyStorage]    Script Date: 01/08/2008 16:04:33 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DeleteStudyStorage]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[DeleteStudyStorage]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertFilesystem]    Script Date: 01/08/2008 16:04:33 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertFilesystem]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[InsertFilesystem]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[QueryServiceLock]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QueryServiceLock]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[QueryServiceLock]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[ResetServiceLock]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ResetServiceLock]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[ResetServiceLock]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[UpdateServiceLock]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UpdateServiceLock]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[UpdateServiceLock]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertServerPartition]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertServerPartition]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[InsertServerPartition]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[UpdateWorkQueue]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UpdateWorkQueue]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[UpdateWorkQueue]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[QueryWorkQueue]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QueryWorkQueue]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[QueryWorkQueue]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertWorkQueueAutoRoute]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertWorkQueueAutoRoute]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[InsertWorkQueueAutoRoute]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertWorkQueueStudyProcess]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertWorkQueueStudyProcess]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[InsertWorkQueueStudyProcess]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[ResetWorkQueue]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ResetWorkQueue]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[ResetWorkQueue]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[QueryServerPartitionSopClasses]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QueryServerPartitionSopClasses]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[QueryServerPartitionSopClasses]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[QueryModalitiesInStudy]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QueryModalitiesInStudy]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[QueryModalitiesInStudy]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertInstance]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertInstance]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[InsertInstance]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[QueryWorkQueueUids]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QueryWorkQueueUids]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[QueryWorkQueueUids]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertRequestAttributes]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertRequestAttributes]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[InsertRequestAttributes]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[QueryRequestAttributes]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QueryRequestAttributes]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[QueryRequestAttributes]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertStudyStorage]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertStudyStorage]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[InsertStudyStorage]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[WebQueryWorkQueue]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WebQueryWorkQueue]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[WebQueryWorkQueue]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[QueryStudyStorageLocation]    Script Date: 01/08/2008 16:04:34 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QueryStudyStorageLocation]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[QueryStudyStorageLocation]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[DeleteWorkQueue]    Script Date: 04/26/2008 00:28:22 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DeleteWorkQueue]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[DeleteWorkQueue]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[DeleteServerPartition]    Script Date: 04/26/2008 00:28:22 ******/
> IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DeleteServerPartition]') AND type in (N'P', N'PC'))
> DROP PROCEDURE [dbo].[DeleteServerPartition]
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[WebQueryWorkQueue]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WebQueryWorkQueue]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Thanh Huynh
> -- Create date: December 16, 2007
> -- Description:         Query WorkQueue entries based on criteria
> --                                    
> -- =============================================
> CREATE PROCEDURE [dbo].[WebQueryWorkQueue] 
>          @ServerPartitionGUID uniqueidentifier = null,
>          @PatientID nvarchar(64) = null,
>          @Accession nvarchar(16) = null,
>          @StudyDescription nvarchar(64) = null,
>          @ScheduledTime datetime = null,
>          @Type smallint = null,
>          @Status smallint = null,
>          @Priority smallint = null
> AS
> BEGIN
>          Declare @stmt nvarchar(1024);
>          Declare @where nvarchar(1024);
> 
>          -- Build SELECT statement based on the paramters
>          
>          SET @stmt =                           ''SELECT WorkQueue.* FROM WorkQueue ''
>          SET @stmt = @stmt + ''LEFT JOIN StudyStorage on StudyStorage.GUID = WorkQueue.StudyStorageGUID ''
>          SET @stmt = @stmt + ''LEFT JOIN Study on Study.ServerPartitionGUID=StudyStorage.ServerPartitionGUID and Study.StudyInstanceUid=StudyStorage.StudyInstanceUid ''
>          
>          SET @where = ''''
> 
>          IF (@ServerPartitionGUID IS NOT NULL)
>          BEGIN
>                   IF (@where<>'''')
>                            SET @where = @where + '' AND ''
> 
>                   SET @where = @where + ''WorkQueue.ServerPartitionGUID = '''''' +  CONVERT(varchar(250),@ServerPartitionGUID) +''''''''
>          END
> 
> 
> 
>          IF (@Type IS NOT NULL)
>          BEGIN
>                   IF (@where<>'''')
>                            SET @where = @where + '' AND ''
>                   
>                   SET @where = @where + ''WorkQueue.WorkQueueTypeEnum = '' + CONVERT(varchar(10), @Type)
>          END
>          
>          IF (@Status IS NOT NULL)
>          BEGIN
>                   IF (@where<>'''')
>                            SET @where = @where + '' AND ''
> 
>                   SET @where = @where + ''WorkQueue.WorkQueueStatusEnum = '' +  CONVERT(varchar(10),@Status)
>          END
> 
>          IF (@Priority IS NOT NULL)
>          BEGIN
>                   IF (@where<>'''')
>                            SET @where = @where + '' AND ''
> 
>                   SET @where = @where + ''WorkQueue.WorkQueuePriorityEnum = '' +  CONVERT(varchar(10),@Priority)
>          END
> 
>          IF (@ScheduledTime IS NOT NULL)
>          BEGIN
>                   IF (@where<>'''')
>                            SET @where = @where + '' AND ''
> 
>                   SET @where = @where + ''WorkQueue.ScheduledTime between '''''' +  CONVERT(varchar(30), @ScheduledTime, 101 ) +'''''' and '''''' + CONVERT(varchar(30), DATEADD(DAY, 1, @ScheduledTime), 101 ) + ''''''''
>          END
> 
> 
>          IF (@PatientID IS NOT NULL and @PatientID<>'''')
>          BEGIN
>                   IF (@where<>'''')
>                            SET @where = @where + '' AND ''
> 
>                   SET @where = @where + ''Study.PatientID Like ''''%'' + @PatientID + ''%'''' ''
>          END
> 
>          IF (@Accession IS NOT NULL and @Accession<>'''')
>          BEGIN
>                   IF (@where<>'''')
>                            SET @where = @where + '' AND ''
> 
>                   SET @where = @where + ''Study.AccessionNumber Like ''''%'' + @Accession + ''%'''' ''
>          END
> 
>          IF (@StudyDescription IS NOT NULL and @StudyDescription<>'''')
>          BEGIN
>                   IF (@where<>'''')
>                            SET @where = @where + '' AND ''
> 
>                   SET @where = @where + ''Study.StudyDescription Like ''''%'' + @StudyDescription + ''%'''' ''
>          END
> 
> 
>          if (@where<>'''')
>                   SET @stmt = @stmt + '' WHERE '' + @where
> 
>          SET @stmt = @stmt + '' ORDER BY WorkQueue.ScheduledTime ASC''
> 
>          --PRINT @stmt
> 
>          EXEC(@stmt)
> 
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[QueryStudyStorageLocation]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QueryStudyStorageLocation]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: 7/30/2007
> -- Description:         
> -- =============================================
> CREATE PROCEDURE [dbo].[QueryStudyStorageLocation] 
>          -- Add the parameters for the stored procedure here
>          @StudyStorageGUID uniqueidentifier = null,
>          @ServerPartitionGUID uniqueidentifier = null, 
>          @StudyInstanceUid varchar(64) = null 
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
>          if @StudyStorageGUID is null
>          BEGIN
>              SELECT  StudyStorage.GUID, StudyStorage.StudyInstanceUid, StudyStorage.ServerPartitionGUID, StudyStorage.LastAccessedTime, StudyStorage.StudyStatusEnum,
>                                     Filesystem.FilesystemPath, ServerPartition.PartitionFolder, StorageFilesystem.StudyFolder, StorageFilesystem.FilesystemGUID, Filesystem.Enabled, Filesystem.ReadOnly, Filesystem.WriteOnly,
>                                     Filesystem.FilesystemTierEnum
>                   FROM StudyStorage
>                            JOIN ServerPartition on StudyStorage.ServerPartitionGUID = ServerPartition.GUID
>                            JOIN StorageFilesystem on StudyStorage.GUID = StorageFilesystem.StudyStorageGUID
>                            JOIN Filesystem on StorageFilesystem.FilesystemGUID = Filesystem.GUID
>                   WHERE StudyStorage.ServerPartitionGuid = @ServerPartitionGUID and StudyStorage.StudyInstanceUid = @StudyInstanceUid
>          END
>          ELSE
>          BEGIN
>                   SELECT  StudyStorage.GUID, StudyStorage.StudyInstanceUid, StudyStorage.ServerPartitionGUID, StudyStorage.LastAccessedTime, StudyStorage.StudyStatusEnum,
>                                     Filesystem.FilesystemPath, ServerPartition.PartitionFolder, StorageFilesystem.StudyFolder, StorageFilesystem.FilesystemGUID, Filesystem.Enabled, Filesystem.ReadOnly, Filesystem.WriteOnly,
>                                     Filesystem.FilesystemTierEnum
>                   FROM StudyStorage
>                            JOIN ServerPartition on StudyStorage.ServerPartitionGUID = ServerPartition.GUID
>                            JOIN StorageFilesystem on StudyStorage.GUID = StorageFilesystem.StudyStorageGUID
>                            JOIN Filesystem on StorageFilesystem.FilesystemGUID = Filesystem.GUID
>                   WHERE StudyStorage.GUID = @StudyStorageGUID
>          END
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertServerPartition]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertServerPartition]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: August 13, 2007
> -- Modify date: April 29, 2008
> -- Description:         Insert a ServerPartition row
> -- =============================================
> CREATE PROCEDURE [dbo].[InsertServerPartition] 
>          -- Add the parameters for the stored procedure here
>          @Enabled bit, 
>          @Description nvarchar(128),
>          @AeTitle varchar(16),
>          @Port int,
>          @PartitionFolder nvarchar(16),
>          @DuplicateSopPolicyEnum smallint,
>          @AcceptAnyDevice bit = 1,
>          @AutoInsertDevice bit = 1,
>          @DefaultRemotePort int = 104
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>          DECLARE @SopClassGUID uniqueidentifier
>          DECLARE @ServerPartitionGUID uniqueidentifier
> 
>          SET @ServerPartitionGUID = newid()
> 
>     -- Insert statements for procedure here
> 
>          -- Wrap in a transaction
>          BEGIN TRANSACTION
> 
>          INSERT INTO [ImageServer].[dbo].[ServerPartition] 
>                   ([GUID],[Enabled],[Description],[AeTitle],[Port],[PartitionFolder],[AcceptAnyDevice],[AutoInsertDevice],[DefaultRemotePort],[DuplicateSopPolicyEnum])
>          VALUES (@ServerPartitionGUID, @Enabled, @Description, @AeTitle, @Port, @PartitionFolder, @AcceptAnyDevice, @AutoInsertDevice, @DefaultRemotePort, @DuplicateSopPolicyEnum)
> 
> 
>          DECLARE cur_sopclass CURSOR FOR 
>                   SELECT GUID FROM ServerSopClass;
> 
>          OPEN cur_sopclass;
> 
>          FETCH NEXT FROM cur_sopclass INTO @SopClassGUID;
>          WHILE @@FETCH_STATUS = 0
>          BEGIN
>                   INSERT INTO [ImageServer].[dbo].[PartitionSopClass]
>                            ([GUID],[ServerPartitionGUID],[ServerSopClassGUID],[Enabled])
>                   VALUES (newid(), @ServerPartitionGUID, @SopClassGUID, 1)
> 
>                   FETCH NEXT FROM cur_sopclass INTO @SopClassGUID;         
>          END 
> 
>          CLOSE cur_sopclass;
>          DEALLOCATE cur_sopclass;
> 
>          -- Now, put in default rules for the partition
>          DECLARE  @StudyServerRuleApplyTimeEnum smallint
>          DECLARE  @StudyDeleteServerRuleTypeEnum smallint
>          DECLARE  @Tier1RetentionServerRuleTypeEnum smallint
>          DECLARE  @OnlineRetentionServerRuleTypeEnum smallint
> 
>          -- Get the Study Processed Rule Apply Time
>          SELECT @StudyServerRuleApplyTimeEnum = Enum FROM ServerRuleApplyTimeEnum WHERE Lookup = ''StudyProcessed''
> 
>          -- Get all 3 types of Retention Rules
>          SELECT @StudyDeleteServerRuleTypeEnum = Enum FROM ServerRuleTypeEnum WHERE Lookup = ''StudyDelete''
>          SELECT @Tier1RetentionServerRuleTypeEnum = Enum FROM ServerRuleTypeEnum WHERE Lookup = ''Tier1Retention''
>          SELECT @OnlineRetentionServerRuleTypeEnum = Enum FROM ServerRuleTypeEnum WHERE Lookup = ''OnlineRetention''
> 
>          -- Insert a default StudyDelete rule
>          INSERT INTO [ImageServer].[dbo].[ServerRule]
>                               ([GUID],[RuleName],[ServerPartitionGUID],[ServerRuleApplyTimeEnum],[ServerRuleTypeEnum],[Enabled],[DefaultRule],[RuleXml])
>                    VALUES
>                               (newid(),''Default Delete'',@ServerPartitionGUID, @StudyServerRuleApplyTimeEnum, @StudyDeleteServerRuleTypeEnum, 1, 1,
>                                     ''<rule id="Default Delete">
>                                              <condition>
>                                              </condition>
>                                              <action><study-delete time="10" timeUnits="days"/></action>
>                                     </rule>'' )
> 
>          -- Insert a default Tier1Retention rule
>          INSERT INTO [ImageServer].[dbo].[ServerRule]
>                               ([GUID],[RuleName],[ServerPartitionGUID],[ServerRuleApplyTimeEnum],[ServerRuleTypeEnum],[Enabled],[DefaultRule],[RuleXml])
>                    VALUES
>                               (newid(),''Default Tier1 Retention'',@ServerPartitionGUID, @StudyServerRuleApplyTimeEnum, @Tier1RetentionServerRuleTypeEnum, 1, 1,
>                                     ''<rule id="Default Tier1 Retention">
>                                              <condition>
>                                              </condition>
>                                              <action><tier1-retention time="3" timeUnits="weeks"/></action>
>                                     </rule>'' )
> 
>          -- Insert a default Online Retention Rule
>          INSERT INTO [ImageServer].[dbo].[ServerRule]
>                               ([GUID],[RuleName],[ServerPartitionGUID],[ServerRuleApplyTimeEnum],[ServerRuleTypeEnum],[Enabled],[DefaultRule],[RuleXml])
>                    VALUES
>                               (newid(),''Default Online Retention'',@ServerPartitionGUID, @StudyServerRuleApplyTimeEnum, @OnlineRetentionServerRuleTypeEnum, 1, 1,
>                                     ''<rule id="Default Online Retention">
>                                              <condition>
>                                              </condition>
>                                              <action><online-retention time="4" timeUnits="weeks"/></action>
>                                     </rule>'' )
> 
>          COMMIT TRANSACTION
> 
>          SELECT * from ServerPartition
> 
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertWorkQueueDeleteStudy]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertWorkQueueDeleteStudy]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: November 14, 2007
> -- Description:         Stored procedure for inserting DeleteStudy WorkQueue entries
> -- =============================================
> CREATE PROCEDURE [dbo].[InsertWorkQueueDeleteStudy] 
>          -- Add the parameters for the stored procedure here
>          @StudyStorageGUID uniqueidentifier, 
>          @ServerPartitionGUID uniqueidentifier,
>          @ExpirationTime datetime,
>          @ScheduledTime datetime,
>          @DeleteFilesystemQueue bit 
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>          declare @WorkQueueGUID as uniqueidentifier
> 
>          declare @PendingStatusEnum as smallint
>          declare @IdleStatusEnum as smallint
>          declare @DeleteStudyTypeEnum as smallint
>          declare @DeleteStudyFilesystemQueueTypeEnum smallint
> 
>          select @PendingStatusEnum = Enum from WorkQueueStatusEnum where Lookup = ''Pending''
>          select @IdleStatusEnum = Enum from WorkQueueStatusEnum where Lookup = ''Idle''
>          select @DeleteStudyTypeEnum = Enum from WorkQueueTypeEnum where Lookup = ''DeleteStudy''
>          select @DeleteStudyFilesystemQueueTypeEnum = Enum from FilesystemQueueTypeEnum where Lookup = ''DeleteStudy''
> 
>          BEGIN TRANSACTION
> 
>     -- Insert statements for procedure here
>          SELECT @WorkQueueGUID = GUID from WorkQueue 
>                   where StudyStorageGUID = @StudyStorageGUID
>                   AND WorkQueueTypeEnum = @DeleteStudyTypeEnum
>          if @@ROWCOUNT = 0
>          BEGIN
>                   set @WorkQueueGUID = NEWID();
> 
>                   INSERT into WorkQueue (GUID, ServerPartitionGUID, StudyStorageGUID, WorkQueueTypeEnum, WorkQueueStatusEnum, ExpirationTime, ScheduledTime)
>                            values  (@WorkQueueGUID, @ServerPartitionGUID, @StudyStorageGUID, @DeleteStudyTypeEnum, @PendingStatusEnum, @ExpirationTime, @ScheduledTime)
>                   IF @DeleteFilesystemQueue = 1
>                   BEGIN
>                            DELETE FROM FilesystemQueue
>                            WHERE StudyStorageGUID = @StudyStorageGUID AND FilesystemQueueTypeEnum = @DeleteStudyFilesystemQueueTypeEnum
>                   END
>          END
>          ELSE
>          BEGIN
>                   UPDATE WorkQueue 
>                            set ExpirationTime = @ExpirationTime
>                            where GUID = @WorkQueueGUID
>          END
> 
>          COMMIT TRANSACTION
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[UpdateWorkQueue]    Script Date: 04/26/2008 00:28:23 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UpdateWorkQueue]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'
> -- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: August 20, 2007
> -- Description:         Procedure for updating WorkQueue entries
> -- History
> --         Oct 29, 2007: Add @ProcessorID
> -- =============================================
> CREATE PROCEDURE [dbo].[UpdateWorkQueue] 
>          -- Add the parameters for the stored procedure here
>          @ProcessorID varchar(256),
>          @WorkQueueGUID uniqueidentifier, 
>          @StudyStorageGUID uniqueidentifier,
>          @WorkQueueStatusEnum smallint,
>          @FailureCount int,
>          @ExpirationTime datetime = null,
>          @ScheduledTime datetime = null,
>          @FailureDescription nvarchar(256) = null
> AS
> BEGIN
> 
>          if (@ProcessorID is NULL)
>          begin
>                   RAISERROR (N''Calling [dbo.[UpdateWorkQueue]] with @ProcessorID = NULL'', 18 /* severity.. >=20 means fatal but needs sysadmin role*/, 1 /*state*/)
>                   RETURN 50000
>          end
> 
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>          declare @CompletedStatusEnum as int
>          declare @PendingStatusEnum as int
>          declare @FailedStatusEnum as int
>          declare @IdleStatusEnum as int
> 
>          select @CompletedStatusEnum = Enum from WorkQueueStatusEnum where Lookup = ''Completed''
>          select @PendingStatusEnum = Enum from WorkQueueStatusEnum where Lookup = ''Pending''
>          select @FailedStatusEnum = Enum from WorkQueueStatusEnum where Lookup = ''Failed''
>          select @IdleStatusEnum = Enum from WorkQueueStatusEnum where Lookup = ''Idle''
>          
>          BEGIN TRANSACTION
> 
>          if @WorkQueueStatusEnum = @CompletedStatusEnum 
>          BEGIN
>                   -- Completed
>                   UPDATE StudyStorage set Lock = 0, LastAccessedTime = getdate() 
>                   WHERE GUID = @StudyStorageGUID AND Lock = 1
> 
>                   DELETE FROM WorkQueue where GUID = @WorkQueueGUID
>          END
>          ELSE if  @WorkQueueStatusEnum = @FailedStatusEnum
>          BEGIN
>                   -- Failed
>                   UPDATE StudyStorage set Lock = 0, LastAccessedTime = getdate() 
>                   WHERE GUID = @StudyStorageGUID AND Lock = 1
> 
>                   IF @FailureDescription is NULL
>                   BEGIN
>                            UPDATE WorkQueue
>                            SET WorkQueueStatusEnum = @WorkQueueStatusEnum, ExpirationTime = @ExpirationTime, ScheduledTime = @ScheduledTime,
>                                     FailureCount = @FailureCount,
>                                     ProcessorID = @ProcessorID
>                            WHERE GUID = @WorkQueueGUID
>                   END
>                   ELSE
>                   BEGIN
>                            UPDATE WorkQueue
>                            SET WorkQueueStatusEnum = @WorkQueueStatusEnum, ExpirationTime = @ExpirationTime, ScheduledTime = @ScheduledTime,
>                                     FailureCount = @FailureCount,
>                                     ProcessorID = @ProcessorID,
>                                     FailureDescription = @FailureDescription
>                            WHERE GUID = @WorkQueueGUID
>                   END
>          END
>          ELSE if @WorkQueueStatusEnum = @PendingStatusEnum
>          BEGIN
>                   -- Pending
>                   UPDATE StudyStorage set Lock = 0, LastAccessedTime = getdate() 
>                   WHERE GUID = @StudyStorageGUID AND Lock = 1
>                   IF @FailureDescription is NULL
>                   BEGIN
>                            UPDATE WorkQueue
>                            SET WorkQueueStatusEnum = @WorkQueueStatusEnum, ExpirationTime = @ExpirationTime, ScheduledTime = @ScheduledTime,
>                                     FailureCount = @FailureCount, ProcessorID = @ProcessorID
>                            WHERE GUID = @WorkQueueGUID
>                   END
>                   ELSE
>                   BEGIN
>                            UPDATE WorkQueue
>                            SET WorkQueueStatusEnum = @WorkQueueStatusEnum, ExpirationTime = @ExpirationTime, ScheduledTime = @ScheduledTime,
>                                     FailureCount = @FailureCount, ProcessorID = @ProcessorID, FailureDescription = @FailureDescription
>                            WHERE GUID = @WorkQueueGUID
>                   END
>          END
>          ELSE
>          BEGIN
>                   -- Idle
>                   if @WorkQueueStatusEnum = @IdleStatusEnum
>                   BEGIN
>                            UPDATE StudyStorage set Lock = 0, LastAccessedTime = getdate() 
>                            WHERE GUID = @StudyStorageGUID AND Lock = 1
>                   END
> 
>                   UPDATE WorkQueue
>                   SET WorkQueueStatusEnum = @WorkQueueStatusEnum, ExpirationTime = @ExpirationTime, ScheduledTime = @ScheduledTime,
>                            FailureCount = @FailureCount, ProcessorID = @ProcessorID
>                   WHERE GUID = @WorkQueueGUID
>          END
> 
>          COMMIT TRANSACTION
> 
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertWorkQueueAutoRoute]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertWorkQueueAutoRoute]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: October 30, 2007
> -- Description:         Stored procedure for inserting AutoRoute WorkQueue entries
> -- =============================================
> CREATE PROCEDURE [dbo].[InsertWorkQueueAutoRoute] 
>          -- Add the parameters for the stored procedure here
>          @StudyStorageGUID uniqueidentifier, 
>          @ServerPartitionGUID uniqueidentifier,
>          @DeviceGUID uniqueidentifier,
>          @SeriesInstanceUid varchar(64),
>          @SopInstanceUid varchar(64),
>          @ExpirationTime datetime,
>          @ScheduledTime datetime 
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>          declare @WorkQueueGUID as uniqueidentifier
> 
>          declare @PendingStatusEnum as int
>          declare @IdleStatusEnum as int
>          declare @AutoRouteTypeEnum as int
> 
>          select @PendingStatusEnum = Enum from WorkQueueStatusEnum where Lookup = ''Pending''
>          select @IdleStatusEnum = Enum from WorkQueueStatusEnum where Lookup = ''Idle''
>          select @AutoRouteTypeEnum = Enum from WorkQueueTypeEnum where Lookup = ''AutoRoute''
> 
>          BEGIN TRANSACTION
> 
>     -- Insert statements for procedure here
>          SELECT @WorkQueueGUID = GUID from WorkQueue 
>                   where StudyStorageGUID = @StudyStorageGUID
>                   AND WorkQueueTypeEnum = @AutoRouteTypeEnum
>                   AND DeviceGUID = @DeviceGUID
>          if @@ROWCOUNT = 0
>          BEGIN
>                   set @WorkQueueGUID = NEWID();
> 
>                   INSERT into WorkQueue (GUID, ServerPartitionGUID, StudyStorageGUID, DeviceGUID, WorkQueueTypeEnum, WorkQueueStatusEnum, ExpirationTime, ScheduledTime)
>                            values  (@WorkQueueGUID, @ServerPartitionGUID, @StudyStorageGUID, @DeviceGUID, @AutoRouteTypeEnum, @PendingStatusEnum, @ExpirationTime, @ScheduledTime)
>          END
>          ELSE
>          BEGIN
>                   UPDATE WorkQueue 
>                            set ExpirationTime = @ExpirationTime,
>                            ScheduledTime = @ScheduledTime
>                   WHERE GUID = @WorkQueueGUID
>          END
> 
>          INSERT into WorkQueueUid(GUID, WorkQueueGUID, SeriesInstanceUid, SopInstanceUid)
>                   values         (newid(), @WorkQueueGUID, @SeriesInstanceUid, @SopInstanceUid)
> 
>          COMMIT TRANSACTION
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertWorkQueueStudyProcess]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertWorkQueueStudyProcess]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'
> -- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: August 14, 2007
> -- Description:         
> -- =============================================
> CREATE PROCEDURE [dbo].[InsertWorkQueueStudyProcess] 
>          -- Add the parameters for the stored procedure here
>          @ServerPartitionGUID uniqueidentifier,
>          @StudyStorageGUID uniqueidentifier,
>          @SeriesInstanceUid varchar(64),
>          @SopInstanceUid varchar(64),
>          @ExpirationTime datetime,
>          @ScheduledTime datetime,
>          @Duplicate bit = 0,
>          @Extension varchar(10) = null 
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>          declare @WorkQueueGUID as uniqueidentifier
> 
>          declare @PendingStatusEnum as int
>          declare @IdleStatusEnum as int
>          declare @StudyProcessTypeEnum as int
> 
>          select @PendingStatusEnum = Enum from WorkQueueStatusEnum where Lookup = ''Pending''
>          select @IdleStatusEnum = Enum from WorkQueueStatusEnum where Lookup = ''Idle''
>          select @StudyProcessTypeEnum = Enum from WorkQueueTypeEnum where Lookup = ''StudyProcess''
> 
>          BEGIN TRANSACTION
> 
>     -- Insert statements for procedure here
>          SELECT @WorkQueueGUID = GUID from WorkQueue 
>                   where StudyStorageGUID = @StudyStorageGUID
>                   AND WorkQueueTypeEnum = @StudyProcessTypeEnum
>          if @@ROWCOUNT = 0
>          BEGIN
>                   set @WorkQueueGUID = NEWID();
> 
>                   INSERT into WorkQueue (GUID, ServerPartitionGUID, StudyStorageGUID, WorkQueueTypeEnum, WorkQueueStatusEnum, ExpirationTime, ScheduledTime)
>                            values  (@WorkQueueGUID, @ServerPartitionGUID, @StudyStorageGUID, @StudyProcessTypeEnum, @PendingStatusEnum, @ExpirationTime, @ScheduledTime)
>          END
>          ELSE
>          BEGIN
>                   UPDATE WorkQueue 
>                            set ExpirationTime = @ExpirationTime
>                            where GUID = @WorkQueueGUID
>          END
> 
>          IF @Duplicate = 1
>          BEGIN
>                   INSERT into WorkQueueUid(GUID, WorkQueueGUID, SeriesInstanceUid, SopInstanceUid, Duplicate, Extension)
>                            values         (newid(), @WorkQueueGUID, @SeriesInstanceUid, @SopInstanceUid, @Duplicate, @Extension)
>          END
>          ELSE
>          BEGIN
>                   INSERT into WorkQueueUid(GUID, WorkQueueGUID, SeriesInstanceUid, SopInstanceUid)
>                            values         (newid(), @WorkQueueGUID, @SeriesInstanceUid, @SopInstanceUid)
>          END
> 
>          COMMIT TRANSACTION
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[ResetWorkQueue]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ResetWorkQueue]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'
> 
> -- =============================================
> -- Author:                  Thanh Huynh
> -- Create date: Oct 29, 2007
> -- Description:         Cleanup work queue. 
> --                                    Reset all "in progress" items to "Pending" or "Failed" depending on their retry counts
> --
> -- =============================================
> CREATE PROCEDURE [dbo].[ResetWorkQueue]
>          @ProcessorID varchar(256),
>          @MaxFailureCount int,
>          @RescheduleTime datetime,
>          @FailedExpirationTime datetime,
>          @RetryExpirationTime datetime
>          
> AS
> BEGIN
>          
>          if (@ProcessorID is NULL)
>          begin
>                   RAISERROR (N''Calling [dbo.ResetWorkQueueItems] with @ProcessorID = NULL'', 18 /* severity.. >=20 means fatal but needs sysadmin role*/, 1 /*state*/)
>                   RETURN 50000
>          end
> 
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>          BEGIN TRANSACTION
> 
>                   declare @PendingStatusEnum as int
>                   declare @InProgressStatusEnum as int
>                   declare @FailedStatusEnum as int
>                   declare @WorkQueueGUID uniqueidentifier
>                   
> 
>                   select @PendingStatusEnum = Enum from WorkQueueStatusEnum where Lookup = ''Pending''
>                   select @InProgressStatusEnum = Enum from WorkQueueStatusEnum where Lookup = ''In Progress''
>                   select @FailedStatusEnum = Enum from WorkQueueStatusEnum where Lookup = ''Failed''
> 
> 
>                   /* All entries that are in progress and failure count = MaxFailureCount should be failed */
> 
>                   /* Temporary tables to hold all items that will be reset */
>                   CREATE TABLE #FailedList(WorkQueueGuid uniqueidentifier, StudyStorageGUID uniqueidentifier)
>                   CREATE TABLE #RetryList(WorkQueueGuid uniqueidentifier, StudyStorageGUID uniqueidentifier)
>                   
>                   /* fill the tables */
>                   INSERT INTO #FailedList (WorkQueueGuid, StudyStorageGUID)
>                   SELECT dbo.WorkQueue.GUID, dbo.StudyStorage.GUID
>                   FROM dbo.WorkQueue 
>                   LEFT JOIN         dbo.StudyStorage ON dbo.WorkQueue.StudyStorageGUID=dbo.StudyStorage.GUID
>                   WHERE ProcessorID=@ProcessorID 
>                                     AND WorkQueue.WorkQueueStatusEnum=@InProgressStatusEnum 
>                                     AND WorkQueue.FailureCount+1 >= @MaxFailureCount 
> 
> 
>                   INSERT INTO #RetryList (WorkQueueGuid, StudyStorageGUID)
>                   SELECT dbo.WorkQueue.GUID, dbo.StudyStorage.GUID
>                   FROM dbo.WorkQueue 
>                   LEFT JOIN         dbo.StudyStorage ON dbo.WorkQueue.StudyStorageGUID=dbo.StudyStorage.GUID
>                   WHERE ProcessorID=@ProcessorID 
>                                     AND WorkQueue.WorkQueueStatusEnum=@InProgressStatusEnum 
>                                     AND WorkQueue.FailureCount+1 < @MaxFailureCount
> 
>                   /* unlock all studies in the "failed" list */
>                   /* and then fail those entries */
>                   UPDATE dbo.StudyStorage
>                   SET Lock = 0
>                   WHERE GUID IN (SELECT StudyStorageGUID FROM #FailedList)
>                   
>                   UPDATE dbo.WorkQueue
>                   SET WorkQueueStatusEnum = @FailedStatusEnum,         /* Status=FAILED */
>                            FailureCount = FailureCount+1,
>                            ExpirationTime = @FailedExpirationTime
>                   WHERE         GUID IN (SELECT WorkQueueGuid FROM #FailedList)
> 
>                   /* unlock all studies in the "retry" list */
>                   /* and then reschedule those entries */
>                   UPDATE dbo.StudyStorage
>                   SET Lock = 0
>                   WHERE GUID IN (SELECT StudyStorageGUID FROM #RetryList)
>                            
>                   UPDATE dbo.WorkQueue 
>                   SET WorkQueueStatusEnum = @PendingStatusEnum,         /* Status=PENDING */
>                            ProcessorID=NULL,                                             /* may be picked up by another processor */
>                            FailureCount = FailureCount+1,                  /* has failed once. This is needed to prevent endless reset later on*/
>                            ScheduledTime = @RescheduleTime,
>                            ExpirationTime = @RetryExpirationTime
>                   WHERE         GUID IN (SELECT WorkQueueGuid FROM #RetryList)
> 
> 
>          COMMIT TRANSACTION
> 
>          /* Return the list of modified entries */
>          SELECT * 
>          FROM WorkQueue
>          WHERE ( GUID IN (SELECT WorkQueueGuid FROM #RetryList) OR 
>                            GUID IN (SELECT WorkQueueGuid FROM #FailedList))
> 
> 
>          DROP TABLE #RetryList
>          DROP TABLE #FailedList
> 
> END
> 
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[QueryWorkQueue]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QueryWorkQueue]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'
> -- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: August 16, 2007
> -- Update date: January 9, 2008
> -- Description:         Select WorkQueue entries
> -- History:
> --                  Oct 29, 2007:         Add @ProcessorID
> --                  Jan 9, 2008:         Fixed clustering bug
> -- =============================================
> CREATE PROCEDURE [dbo].[QueryWorkQueue] 
>          -- Add the parameters for the stored procedure here
>          @ProcessorID varchar(256), 
>          @WorkQueueTypeEnum smallint = 0
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          
>          if (@ProcessorID is NULL)
>          begin
>                   RAISERROR (N''Calling [dbo.QueryWorkQueue] with @ProcessorID = NULL'', 18 /* severity.. >=20 means fatal but needs sysadmin role*/, 1 /*state*/)
>                   RETURN 50000
>          end
> 
> 
>          SET NOCOUNT ON;
> 
> 
>          declare @StudyStorageGUID uniqueidentifier
>          declare @WorkQueueGUID uniqueidentifier
>          declare @PendingStatusEnum as int
>          declare @IdleStatusEnum as int
>          declare @InProgressStatusEnum as int
> 
>          select @PendingStatusEnum = Enum from WorkQueueStatusEnum where Lookup = ''Pending''
>          select @IdleStatusEnum = Enum from WorkQueueStatusEnum where Lookup = ''Idle''
>          select @InProgressStatusEnum = Enum from WorkQueueStatusEnum where Lookup = ''In Progress''
>          
>     IF @WorkQueueTypeEnum = 0
>          BEGIN
>                   SELECT TOP (1) @StudyStorageGUID = WorkQueue.StudyStorageGUID,
>                            @WorkQueueGUID = WorkQueue.GUID 
>                   FROM WorkQueue
>                   JOIN
>                            StudyStorage ON StudyStorage.GUID = WorkQueue.StudyStorageGUID AND StudyStorage.Lock = 0
>                   WHERE
>                            ScheduledTime < getdate() 
>                            AND (  WorkQueue.WorkQueueStatusEnum in (@PendingStatusEnum,@IdleStatusEnum)  )
>                   ORDER BY WorkQueue.ScheduledTime
>          END
>          ELSE
>          BEGIN
>                   SELECT TOP (1) @StudyStorageGUID = WorkQueue.StudyStorageGUID,
>                            @WorkQueueGUID = WorkQueue.GUID 
>                   FROM WorkQueue
>                   JOIN
>                            StudyStorage ON StudyStorage.GUID = WorkQueue.StudyStorageGUID AND StudyStorage.Lock = 0
>                   WHERE
>                            ScheduledTime < getdate() 
>                            AND WorkQueue.WorkQueueStatusEnum in (@PendingStatusEnum,@IdleStatusEnum)
>                            AND WorkQueue.WorkQueueTypeEnum = @WorkQueueTypeEnum
>                   ORDER BY WorkQueue.ScheduledTime
>          END
> 
>          -- We have a record, now do the updates
>          BEGIN TRANSACTION
> 
>          UPDATE StudyStorage
>                   SET Lock = 1, LastAccessedTime = getdate()
>          WHERE 
>                   Lock = 0 
>                   AND GUID = @StudyStorageGUID
> 
>          if (@@ROWCOUNT = 1)
>          BEGIN
>                   UPDATE WorkQueue
>                            SET WorkQueueStatusEnum  = @InProgressStatusEnum,
>                                     ProcessorID = @ProcessorID
>                   WHERE 
>                            GUID = @WorkQueueGUID
>                            
>                   COMMIT TRANSACTION
>          END
>          ELSE
>          BEGIN
>                   -- In case the lock failed, reset GUID
>                   SET @WorkQueueGUID = newid()
>                   
>                   ROLLBACK TRANSACTION
>          END
>          
> 
>          -- If the first update failed, this should select 0 records
>          SELECT * 
>          FROM WorkQueue
>          WHERE WorkQueueStatusEnum = @InProgressStatusEnum
>                   AND GUID = @WorkQueueGUID
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[QueryServerPartitionSopClasses]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QueryServerPartitionSopClasses]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: August 13, 2007
> -- Description:         Select all the SOP Classes for a Partition
> -- =============================================
> CREATE PROCEDURE [dbo].[QueryServerPartitionSopClasses] 
>          -- Add the parameters for the stored procedure here
>          @ServerPartitionGUID uniqueidentifier 
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>     -- Insert statements for procedure here
>          SELECT         PartitionSopClass.GUID,
>                            PartitionSopClass.ServerPartitionGUID, 
>                            PartitionSopClass.ServerSopClassGUID,
>                            PartitionSopClass.Enabled,
>                            ServerSopClass.SopClassUid,
>                            ServerSopClass.Description,
>                            ServerSopClass.NonImage
>          FROM PartitionSopClass
>          JOIN ServerSopClass on PartitionSopClass.ServerSopClassGUID = ServerSopClass.GUID
>          WHERE PartitionSopClass.ServerPartitionGUID = @ServerPartitionGUID
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertFilesystem]    Script Date: 01/08/2008 16:04:33 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertFilesystem]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: September 17, 2007
> -- Description:         
> -- =============================================
> CREATE PROCEDURE [dbo].[InsertFilesystem] 
>          -- Add the parameters for the stored procedure here
>          @FilesystemTierEnum smallint, 
>          @FilesystemPath nvarchar(256),
>          @Enabled bit = 1,
>          @ReadOnly bit = 0,
>          @WriteOnly bit = 0,
>          @Description nvarchar(128),
>          @HighWatermark decimal(6,2) = 90.00,
>          @LowWatermark decimal(6,2) = 80.00
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>     -- Variables
>          DECLARE @GUID uniqueidentifier
>          DECLARE @FilesystemDeleteServiceLockTypeEnum smallint
>          DECLARE @FilesystemReinventoryServiceLockTypeEnum smallint
>          DECLARE @FilesystemStudyProcessServiceLockTypeEnum smallint
> 
>          SET @GUID = newid()
>          SELECT @FilesystemDeleteServiceLockTypeEnum = Enum FROM ServiceLockTypeEnum WHERE [Lookup] = ''FilesystemDelete''
>          SELECT @FilesystemReinventoryServiceLockTypeEnum = Enum FROM ServiceLockTypeEnum WHERE [Lookup] = ''FilesystemReinventory''
>          SELECT @FilesystemStudyProcessServiceLockTypeEnum = Enum FROM ServiceLockTypeEnum WHERE [Lookup] = ''FilesystemStudyProcess''
> 
>     -- Insert statements
>          BEGIN TRANSACTION
> 
>          INSERT INTO [ImageServer].[dbo].Filesystem 
>                   ([GUID],[FilesystemTierEnum],[FilesystemPath],[Enabled],[ReadOnly],[WriteOnly],[Description], [HighWatermark], [LowWatermark])
>          VALUES (@GUID, @FilesystemTierEnum, @FilesystemPath, @Enabled, @ReadOnly, @WriteOnly, @Description, @HighWatermark, @LowWatermark)
> 
>          INSERT INTO [ImageServer].[dbo].ServiceLock
>                   ([GUID],[ServiceLockTypeEnum],[Lock],[ScheduledTime],[FilesystemGUID],[Enabled])
>          VALUES (newid(),@FilesystemDeleteServiceLockTypeEnum,0,getdate(),@GUID,1)
> 
>          INSERT INTO [ImageServer].[dbo].ServiceLock
>                   ([GUID],[ServiceLockTypeEnum],[Lock],[ScheduledTime],[FilesystemGUID],[Enabled])
>          VALUES (newid(),@FilesystemReinventoryServiceLockTypeEnum,0,getdate(),@GUID,0)
> 
>          INSERT INTO [ImageServer].[dbo].ServiceLock
>                   ([GUID],[ServiceLockTypeEnum],[Lock],[ScheduledTime],[FilesystemGUID],[Enabled])
>          VALUES (newid(),@FilesystemStudyProcessServiceLockTypeEnum,0,getdate(),@GUID,0)
> 
>          COMMIT TRANSACTION
> 
>          SELECT * FROM Filesystem where GUID = @GUID         
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[QueryServiceLock]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QueryServiceLock]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: November 14, 2007
> -- Description:         Query for ServiceLock rows
> -- =============================================
> CREATE PROCEDURE [dbo].[QueryServiceLock] 
>          -- Add the parameters for the stored procedure here
>          @ProcessorId varchar(256), 
>          @ServiceLockTypeEnum smallint = 0
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>          if (@ProcessorID is NULL)
>          begin
>                   RAISERROR (N''Calling [dbo.QueryServiceLock] with @ProcessorID = NULL'', 18 /* severity.. >=20 means fatal but needs sysadmin role*/, 1 /*state*/)
>                   RETURN 50000
>          end
> 
>     -- Insert statements for procedure here
>          declare @ServiceLockGUID uniqueidentifier
>          
>     IF @ServiceLockTypeEnum = 0
>          BEGIN
>                   SELECT TOP (1) @ServiceLockGUID = ServiceLock.GUID 
>                   FROM ServiceLock
>                   WHERE
>                            Enabled = 1
>                            AND ScheduledTime < getdate() 
>                            AND ( ServiceLock.Lock = 0 )
>                   ORDER BY ServiceLock.ScheduledTime
>          END
>          ELSE
>          BEGIN
>                   SELECT TOP (1) @ServiceLockGUID = ServiceLock.GUID 
>                   FROM ServiceLock
>                   WHERE
>                            Enabled = 1
>                            AND ScheduledTime < getdate() 
>                            AND ServiceLock.ServiceLockTypeEnum = @ServiceLockTypeEnum
>                            AND ( ServiceLock.Lock = 0 )
>                   ORDER BY ServiceLock.ScheduledTime
>          END
> 
>          -- We have a record, now do the updates
> 
>          UPDATE ServiceLock
>                   SET Lock = 1, ProcessorId = @ProcessorId
>          WHERE 
>                   Lock = 0 
>                   AND GUID = @ServiceLockGUID
> 
>          if (@@ROWCOUNT = 0)
>          BEGIN
>                   set @ServiceLockGUID = newid()
>          END
> 
> 
>          -- If the first update failed, this should select 0 records
>          SELECT * 
>          FROM ServiceLock
>          WHERE 
>                   GUID = @ServiceLockGUID
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[ResetServiceLock]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ResetServiceLock]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: November 19, 2007
> -- Description:         
> -- =============================================
> CREATE PROCEDURE [dbo].[ResetServiceLock] 
>          -- Add the parameters for the stored procedure here
>          @ProcessorId varchar(256), 
>          @ServiceLockTypeEnum smallint = 0
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
> 
>     -- Insert statements for procedure here
> 
>          BEGIN TRANSACTION
> 
>          declare @ServiceLockGUID uniqueidentifier
>          declare @Lock bit
> 
>          DECLARE cur_servicelock CURSOR FOR 
>                   SELECT GUID, Lock FROM ServiceLock WHERE ProcessorId = @ProcessorId;
> 
>          OPEN cur_servicelock;
> 
>          FETCH NEXT FROM cur_servicelock INTO @ServiceLockGUID, @Lock;
>          WHILE @@FETCH_STATUS = 0
>          BEGIN
>                   IF @Lock = 0
>                   BEGIN
>                            UPDATE ServiceLock SET ProcessorId = null, ScheduledTime = getdate() 
>                            WHERE GUID = @ServiceLockGUID
>                   END
>                   ELSE
>                   BEGIN
>                            UPDATE ServiceLock SET Lock = 0, ScheduledTime = getdate()
>                            WHERE GUID = @ServiceLockGUID
>                   END
> 
>                   FETCH NEXT FROM cur_servicelock INTO @ServiceLockGUID, @Lock;         
>          END 
> 
>          CLOSE cur_servicelock;
>          DEALLOCATE cur_servicelock;
> 
>          COMMIT TRANSACTION
> 
>          SELECT * 
>          FROM ServiceLock 
>          WHERE ProcessorId = @ProcessorId
> 
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[UpdateServiceLock]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UpdateServiceLock]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: November 14, 2007
> -- Description:         Update the ServiceLock table
> -- =============================================
> CREATE PROCEDURE [dbo].[UpdateServiceLock] 
>          -- Add the parameters for the stored procedure here
>          @ProcessorId varchar(256), 
>          @ServiceLockGUID uniqueidentifier,
>          @Lock bit,
>          @ScheduledTime datetime,
>          @Enabled bit = 1
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>     -- Insert statements for procedure here
>                   UPDATE ServiceLock
>                   SET Lock = @Lock, ScheduledTime = @ScheduledTime,
>                            ProcessorID = @ProcessorID, Enabled = @Enabled
>                   WHERE GUID = @ServiceLockGUID
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertFilesystemQueue]    Script Date: 01/08/2008 16:04:33 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertFilesystemQueue]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: November 14, 2007
> -- Description:         
> -- =============================================
> CREATE PROCEDURE [dbo].[InsertFilesystemQueue] 
>          -- Add the parameters for the stored procedure here
>          @FilesystemQueueTypeEnum smallint, 
>          @StudyStorageGUID uniqueidentifier,
>          @FilesystemGUID uniqueidentifier,
>          @ScheduledTime datetime,
>          @SeriesInstanceUid varchar(64) = null
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>          DECLARE @FilesystemQueueGUID uniqueidentifier
>          DECLARE @ScheduledTimeInDb datetime
> 
>          SELECT @FilesystemQueueGUID = GUID, @ScheduledTimeInDb = ScheduledTime
>          FROM FilesystemQueue
>          WHERE StudyStorageGUID = @StudyStorageGUID AND FilesystemQueueTypeEnum = @FilesystemQueueTypeEnum
> 
>          IF @@ROWCOUNT > 0
>          BEGIN
>                   IF @ScheduledTime > @ScheduledTimeInDb
>                   BEGIN
>                            UPDATE FilesystemQueue
>                            SET ScheduledTime = @ScheduledTime
>                            WHERE GUID = @FilesystemQueueGUID
>                   END
>          END
>          ELSE
>          BEGIN
>          -- Insert statements         
>                   INSERT INTO [ImageServer].[dbo].[FilesystemQueue]
>                               ([GUID],[FilesystemQueueTypeEnum],[StudyStorageGUID],[FilesystemGUID],[ScheduledTime],[SeriesInstanceUid])
>                    VALUES
>                               (newid(), @FilesystemQueueTypeEnum, @StudyStorageGUID, @FilesystemGUID, @ScheduledTime, @SeriesInstanceUid)                  
>          END
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[DeleteStudyStorage]    Script Date: 01/08/2008 16:04:33 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DeleteStudyStorage]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: November 19, 2007
> -- Update date: April 18, 2008
> -- Description:         Completely delete a Study from the database
> -- =============================================
> CREATE PROCEDURE [dbo].[DeleteStudyStorage] 
>          -- Add the parameters for the stored procedure here
>          @ServerPartitionGUID uniqueidentifier, 
>          @StudyStorageGUID uniqueidentifier
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>          declare @StudyInstanceUid varchar(64)
>          declare @StudyGUID uniqueidentifier
>          declare @PatientGUID uniqueidentifier
>          declare @NumberOfStudyRelatedSeries int
>          declare @NumberOfStudyRelatedInstances int
>          declare @NumberOfPatientRelatedStudies int
> 
>          -- Select key values
>          SELECT @StudyInstanceUid = StudyInstanceUid FROM StudyStorage WHERE GUID = @StudyStorageGUID
> 
>          SELECT @StudyGUID = GUID, 
>                   @PatientGUID = PatientGUID, 
>                   @NumberOfStudyRelatedSeries = NumberOfStudyRelatedSeries, 
>                   @NumberOfStudyRelatedInstances = NumberOfStudyRelatedInstances 
>          FROM Study 
>          WHERE StudyInstanceUid = @StudyInstanceUid and ServerPartitionGUID = @ServerPartitionGUID
> 
>          -- Begin the transaction, keep all the deletes in a single transaction
>          BEGIN TRANSACTION
> 
>          -- Delete the Study / Series / RequestAttributes tables, reduce counts or delete from Patient table
>          DELETE FROM RequestAttributes 
>          WHERE SeriesGUID IN (select SeriesGUID from Series where StudyGUID = @StudyGUID)
> 
>          DELETE FROM Series
>          WHERE StudyGUID = @StudyGUID
> 
>          DELETE FROM Study
>          WHERE GUID = @StudyGUID
> 
>          UPDATE Patient
>          SET         NumberOfPatientRelatedStudies = NumberOfPatientRelatedStudies -1,
>                   NumberOfPatientRelatedSeries = NumberOfPatientRelatedSeries - @NumberOfStudyRelatedSeries,
>                   NumberOfPatientRelatedInstances = NumberOfPatientRelatedInstances - @NumberOfStudyRelatedInstances
>          WHERE GUID = @PatientGUID
>          
>     -- Now cleanup the more management related tables.
>          DELETE FROM FilesystemQueue 
>          WHERE StudyStorageGUID = @StudyStorageGUID
> 
>          DELETE FROM StorageFilesystem
>          WHERE StudyStorageGUID = @StudyStorageGUID
> 
>          DELETE FROM WorkQueueUid
>          WHERE WorkQueueGUID IN (SELECT GUID from WorkQueue WHERE StudyStorageGUID = @StudyStorageGUID)
> 
>          DELETE FROM WorkQueue 
>          WHERE StudyStorageGUID = @StudyStorageGUID
> 
>          DELETE FROM StudyStorage
>          WHERE GUID = @StudyStorageGUID
> 
>          UPDATE dbo.ServerPartition SET StudyCount=StudyCount-1
>          WHERE GUID=@ServerPartitionGUID
> 
>          COMMIT TRANSACTION
> 
>          -- Do afterwards, in case multiple studies for the same patient are being deleted at once.
>          SELECT @NumberOfPatientRelatedStudies = NumberOfPatientRelatedStudies 
>          FROM Patient
>          WHERE GUID = @PatientGUID
> 
>          if @NumberOfPatientRelatedStudies = 0
>          BEGIN
>                   DELETE FROM Patient
>                   WHERE GUID = @PatientGUID
>          END
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[QueryFilesystemQueue]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QueryFilesystemQueue]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: November 14, 2007
> -- Description:         Query for candidates from FilesystemQueue
> -- =============================================
> CREATE PROCEDURE [dbo].[QueryFilesystemQueue] 
>          -- Add the parameters for the stored procedure here
>          @FilesystemGUID uniqueidentifier, 
>          @FilesystemQueueTypeEnum smallint,
>          @ScheduledTime datetime,
>          @Results int                  
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>     -- Insert statements for procedure here
>          SELECT TOP (@Results) * 
>          FROM FilesystemQueue
>          WHERE
>                   FilesystemGUID = @FilesystemGUID
>                   AND FilesystemQueueTypeEnum = @FilesystemQueueTypeEnum
>                   AND ScheduledTime < @ScheduledTime
>          ORDER BY ScheduledTime
> 
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[QueryWorkQueueUids]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QueryWorkQueueUids]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: August 17, 2007
> -- Description:         Seleect WorkQueueUid rows related to a WorkQueue instance
> -- =============================================
> CREATE PROCEDURE [dbo].[QueryWorkQueueUids] 
>          -- Add the parameters for the stored procedure here
>          @WorkQueueGUID uniqueidentifier
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>          SELECT *
>          FROM WorkQueueUid
>          WHERE WorkQueueGUID = @WorkQueueGUID
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertRequestAttributes]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertRequestAttributes]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: August 22, 2007
> -- Description:         Insert RequestAttribute table entries
> -- =============================================
> CREATE PROCEDURE [dbo].[InsertRequestAttributes] 
>          -- Add the parameters for the stored procedure here
>          @SeriesGUID uniqueidentifier, 
>          @RequestedProcedureId nvarchar(16) = null,
>          @ScheduledProcedureStepId nvarchar(16) = null
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>     -- Insert statements for procedure here
>          SELECT GUID from RequestAttributes 
>          WHERE
>                   SeriesGUID = @SeriesGUID
>                   AND RequestedProcedureId = @RequestedProcedureId
>                   AND ScheduledProcedureStepId = @ScheduledProcedureStepId
> 
>          if @@ROWCOUNT = 0
>          BEGIN
>                   INSERT into RequestAttributes
>                            (GUID, SeriesGUID, RequestedProcedureId, ScheduledProcedureStepId)
>                   VALUES
>                            (newid(), @SeriesGUID, @RequestedProcedureId, @ScheduledProcedureStepId)
>          END
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[QueryRequestAttributes]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QueryRequestAttributes]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: August 22, 2007
> -- Description:         Select Requested attributes for a series
> -- =============================================
> CREATE PROCEDURE [dbo].[QueryRequestAttributes] 
>          -- Add the parameters for the stored procedure here
>          @SeriesGUID uniqueidentifier
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>     -- Insert statements for procedure here
>          SELECT * 
>          FROM RequestAttributes
>          WHERE SeriesGUID = @SeriesGUID
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[QueryModalitiesInStudy]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[QueryModalitiesInStudy]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: August 29, 2007
> -- Description:         Select modalties associated with a study
> -- =============================================
> CREATE PROCEDURE [dbo].[QueryModalitiesInStudy] 
>          -- Add the parameters for the stored procedure here
>          @StudyGUID uniqueidentifier
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>     -- Insert statements for procedure here
>          SELECT DISTINCT Modality from Series where StudyGUID = @StudyGUID
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertInstance]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertInstance]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: August 17, 2007
> -- Modified:    April 24, 2008
> -- Description:         
> -- =============================================
> CREATE PROCEDURE [dbo].[InsertInstance] 
>          -- Add the parameters for the stored procedure here
>          @ServerPartitionGUID uniqueidentifier, 
>          @StudyStatusEnum smallint,
>          @PatientId nvarchar(64) = null,
>          @PatientsName nvarchar(64) = null,
>          @IssuerOfPatientId nvarchar(64) = null,
>          @StudyInstanceUid varchar(64),
>          @PatientsBirthDate varchar(8) = null,
>          @PatientsSex varchar(2) = null,
>          @StudyDate varchar(8) = null,
>          @StudyTime varchar(16) = null,
>          @AccessionNumber nvarchar(16) = null,
>          @StudyId nvarchar(16) = null,
>          @StudyDescription nvarchar(64) = null,
>          @ReferringPhysiciansName nvarchar(64) = null,
>          @SeriesInstanceUid varchar(64),
>          @Modality varchar(16),
>          @SeriesNumber varchar(12) = null,
>          @SeriesDescription nvarchar(64) = null,
>          @PerformedProcedureStepStartDate varchar(8) = null,
>          @PerformedProcedureStepStartTime varchar(16) = null,
>          @SourceApplicationEntityTitle varchar(16) = null,
>          @SpecificCharacterSet varchar(128) = null
>          
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
>          
>          declare @SeriesGUID uniqueidentifier
>          declare @StudyGUID uniqueidentifier
>          declare @PatientGUID uniqueidentifier
>          declare @InsertPatient bit
>          declare @InsertStudy bit
>          declare @InsertSeries bit
> 
>          set @InsertPatient = 0
>          set @InsertStudy = 0
>          set @InsertSeries = 0
> 
>          BEGIN TRANSACTION
> 
>          -- First, check for the existance of the Study
>          SELECT @StudyGUID = GUID,
>                      @PatientGUID = PatientGUID
>          FROM Study
>          WHERE ServerPartitionGUID = @ServerPartitionGUID
>                   AND StudyInstanceUid = @StudyInstanceUid
> 
>          IF @@ROWCOUNT = 0
>          BEGIN
>                   -- No Study, Check for the Patient table
>                   if @IssuerOfPatientId is null
>                   BEGIN
>                            SELECT @PatientGUID = GUID 
>                            FROM Patient
>                            WHERE ServerPartitionGUID = @ServerPartitionGUID
>                                     AND PatientsName = @PatientsName
>                                     AND PatientId = @PatientId
>                   END
>                   ELSE
>                   BEGIN
>                            SELECT @PatientGUID = GUID 
>                            FROM Patient
>                            WHERE ServerPartitionGUID = @ServerPartitionGUID
>                                     AND PatientsName = @PatientsName
>                                     AND PatientId = @PatientId
>                                     AND IssuerOfPatientId = @IssuerOfPatientId
>                   END
> 
>                   IF @@ROWCOUNT = 0
>                   BEGIN
>                            set @PatientGUID = newid()
>                            set @InsertPatient = 1
> 
>                            INSERT into Patient (GUID, ServerPartitionGUID, PatientsName, PatientId, IssuerOfPatientId, NumberOfPatientRelatedStudies, NumberOfPatientRelatedSeries, NumberOfPatientRelatedInstances,SpecificCharacterSet)
>                            VALUES
>                                     (@PatientGUID, @ServerPartitionGUID, @PatientsName, @PatientId, @IssuerOfPatientId, 0,0,1,@SpecificCharacterSet)
>                   END
>                   ELSE
>                   BEGIN
>                            UPDATE Patient 
>                            SET NumberOfPatientRelatedInstances = NumberOfPatientRelatedInstances + 1
>                            WHERE GUID = @PatientGUID
>                   END
> 
>                   set @StudyGUID = newid()
>                   set @InsertStudy = 1
> 
>                   INSERT into Study (GUID, ServerPartitionGUID, PatientGUID,
>                                     StudyInstanceUid, PatientsName, PatientId, PatientsBirthDate,
>                                     PatientsSex, StudyDate, StudyTime, AccessionNumber, StudyId,
>                                     StudyDescription, ReferringPhysiciansName, NumberOfStudyRelatedSeries,
>                                     NumberOfStudyRelatedInstances, StudyStatusEnum,SpecificCharacterSet)
>                   VALUES
>                                     (@StudyGUID, @ServerPartitionGUID, @PatientGUID, 
>                                     @StudyInstanceUid, @PatientsName, @PatientId, @PatientsBirthDate,
>                                     @PatientsSex, @StudyDate, @StudyTime, @AccessionNumber, @StudyId,
>                                     @StudyDescription, @ReferringPhysiciansName, 0, 1, @StudyStatusEnum,@SpecificCharacterSet)
> 
>                   UPDATE dbo.ServerPartition SET StudyCount=StudyCount+1
>                   WHERE GUID=@ServerPartitionGUID
>          
> 
>                   UPDATE Patient 
>                   SET NumberOfPatientRelatedStudies = NumberOfPatientRelatedStudies + 1
>                   WHERE GUID = @PatientGUID
> 
>          END
>          ELSE
>          BEGIN
>                   UPDATE Patient 
>                            SET NumberOfPatientRelatedInstances = NumberOfPatientRelatedInstances + 1
>                            WHERE GUID = @PatientGUID
> 
>                   -- Update Study, Patient TablesNext, the Study Table
>                   UPDATE Study 
>                   SET NumberOfStudyRelatedInstances = NumberOfStudyRelatedInstances + 1
>                   WHERE GUID = @StudyGUID
> 
>          END
> 
>          -- Finally, the Series Table
>          SELECT @SeriesGUID = GUID
>          FROM Series
>          WHERE 
>                   ServerPartitionGUID = @ServerPartitionGUID
>                   AND StudyGUID = @StudyGUID
>                   AND SeriesInstanceUid = @SeriesInstanceUid
> 
>          IF @@ROWCOUNT = 0
>          BEGIN
>                   set @SeriesGUID = newid()
>                   set @InsertSeries = 1
> 
>                   INSERT into Series (GUID, ServerPartitionGUID, StudyGUID,
>                                     SeriesInstanceUid, Modality, SeriesNumber, SeriesDescription,
>                                     NumberOfSeriesRelatedInstances, PerformedProcedureStepStartDate,
>                                     PerformedProcedureStepStartTime, SourceApplicationEntityTitle, StudyStatusEnum)
>                   VALUES
>                                     (@SeriesGUID, @ServerPartitionGUID, @StudyGUID, 
>                                     @SeriesInstanceUid, @Modality, @SeriesNumber, @SeriesDescription,
>                                     1,@PerformedProcedureStepStartDate, @PerformedProcedureStepStartTime, 
>                                     @SourceApplicationEntityTitle,         @StudyStatusEnum)
> 
>                   UPDATE Study
>                            SET NumberOfStudyRelatedSeries = NumberOfStudyRelatedSeries + 1
>                   WHERE GUID = @StudyGUID
> 
>                   UPDATE Patient
>                            SET NumberOfPatientRelatedSeries = NumberOfPatientRelatedSeries + 1
>                   WHERE GUID = @PatientGUID
>          END
>          ELSE
>          BEGIN
>                   UPDATE Series
>                            SET NumberOfSeriesRelatedInstances = NumberOfSeriesRelatedInstances + 1
>                   WHERE GUID = @SeriesGUID
>          END
> 
>          
>          COMMIT TRANSACTION
> 
>          -- Return the resultant keys
>          SELECT @ServerPartitionGUID as ServerPartitionGUID, 
>                            @PatientGUID as PatientGUID,
>                            @StudyGUID as StudyGUID,
>                            @SeriesGUID as SeriesGUID,
>                            @InsertPatient as InsertPatient,
>                            @InsertStudy as InsertStudy,
>                            @InsertSeries as InsertSeries
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[InsertStudyStorage]    Script Date: 01/08/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertStudyStorage]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: 7/30/2007
> -- Description:         Called when a new study is received.
> -- =============================================
> CREATE PROCEDURE [dbo].[InsertStudyStorage] 
>          -- Add the parameters for the stored procedure here
>          @ServerPartitionGUID uniqueidentifier, 
>          @StudyInstanceUid varchar(64),
>          @Folder varchar(8),
>          @FilesystemGUID uniqueidentifier
>          
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>          declare @StudyStorageGUID as uniqueidentifier
>          declare @PendingStatusEnum as int
> 
>          set @StudyStorageGUID = NEWID()
>          select @PendingStatusEnum = Enum from StudyStatusEnum where Lookup = ''Pending''
> 
>          INSERT into StudyStorage(GUID, ServerPartitionGUID, StudyInstanceUid, Lock, StudyStatusEnum) 
>                   values (@StudyStorageGUID, @ServerPartitionGUID, @StudyInstanceUid, 0, @PendingStatusEnum)
> 
>          INSERT into StorageFilesystem(GUID, StudyStorageGUID, FilesystemGUID, StudyFolder)
>                   values (NEWID(), @StudyStorageGUID, @FilesystemGUID, @Folder)
> 
> 
>          -- Return the study location
>          declare @RC int
> 
>          -- Have to include all parameters!
>          EXECUTE @RC = [ImageServer].[dbo].[QueryStudyStorageLocation] 
>                   @StudyStorageGUID
>                   ,@ServerPartitionGUID
>                   ,@StudyInstanceUid
> END
> ' 
> END
> GO

Command completed successfully.

> 
> 
> set ANSI_NULLS ON
> set QUOTED_IDENTIFIER ON
> go

Command completed successfully.

> 
> /****** Object:  StoredProcedure [dbo].[DeleteServerPartition]    Script Date: 04/24/2008 16:04:34 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DeleteServerPartition]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Thanh Huynh
> -- Create date: April 24, 2008
> -- Update date: April 24, 2008
> -- Description:         Completely delete a Server Partition from the database.
> --                                    This involves deleting devies, rules, 
> -- =============================================
> CREATE PROCEDURE [dbo].[DeleteServerPartition] 
>          -- Add the parameters for the stored procedure here
>          @ServerPartitionGUID uniqueidentifier,
>          @DeleteStudies bit = 0
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>          Declare @DeviceGUID uniqueidentifier
>          Declare @StudyStorageGUID uniqueidentifier
> 
>          /* DELETE DEVICE AND RELATED TABLES */
>          DECLARE DeviceCursor Cursor For Select GUID from dbo.Device where ServerPartitionGUID=@ServerPartitionGUID
>          Open DeviceCursor
>          Fetch NEXT FROM DeviceCursor INTO @DeviceGUID
>          While (@@FETCH_STATUS <> -1)
>          BEGIN
>                   -- PRINT ''Deleting DevicePreferredTransferSyntax''
>                   delete dbo.DevicePreferredTransferSyntax where DeviceGUID=@DeviceGUID
>                   --PRINT ''Deleting WorkQueueUid''
>                   delete dbo.WorkQueueUid where WorkQueueGUID in (select GUID from dbo.WorkQueue where DeviceGUID=@DeviceGUID)
>                   --PRINT ''Deleting WorkQueue''
>                   delete dbo.WorkQueue where DeviceGUID=@DeviceGUID
>                   Fetch NEXT FROM DeviceCursor INTO @DeviceGUID
>          END
>          CLOSE DeviceCursor
>          DEALLOCATE DeviceCursor         
>          --PRINT ''Deleting Device''
>          delete dbo.Device where ServerPartitionGUID=@ServerPartitionGUID
> 
>          /* DELETE STUDYSTORAGE AND RELATED TABLES  */
>          DECLARE StudyStorageCursor Cursor For Select GUID from dbo.StudyStorage where ServerPartitionGUID=@ServerPartitionGUID
>          Open StudyStorageCursor
>          Fetch NEXT FROM StudyStorageCursor INTO @StudyStorageGUID
>          While (@@FETCH_STATUS <> -1)
>          BEGIN
>                   --PRINT ''Deleting FilesystemQueue''
>                   delete dbo.FilesystemQueue where StudyStorageGUID=@StudyStorageGUID
>                   --PRINT ''Deleting StorageFilesystem''
>                   delete dbo.StorageFilesystem where StudyStorageGUID=@StudyStorageGUID
>                   --PRINT ''Deleting WorkQueueUid''
>                   delete dbo.WorkQueueUid where WorkQueueGUID in (select GUID from dbo.WorkQueue where StudyStorageGUID=@StudyStorageGUID)
>                   --PRINT ''Deleting WorkQueue''
>                   delete dbo.WorkQueue where StudyStorageGUID=@StudyStorageGUID
>                   Fetch NEXT FROM StudyStorageCursor INTO @StudyStorageGUID
>          END
>          CLOSE StudyStorageCursor
>          DEALLOCATE StudyStorageCursor         
>          --PRINT ''Deleting StudyStorage''
>          delete dbo.StudyStorage where ServerPartitionGUID=@ServerPartitionGUID
>          
>          /* DELETE WORKQUEUE AND RELATED TABLES */
>          --PRINT ''Deleting WorkQueueUid''
>          delete dbo.WorkQueueUid where WorkQueueGUID in (select GUID from dbo.WorkQueue where StudyStorageGUID=@StudyStorageGUID)
>          --PRINT ''Deleting WorkQueue''
>          delete dbo.WorkQueue where ServerPartitionGUID=@ServerPartitionGUID
>          --PRINT ''Deleting PartitionSopClass''
>          delete dbo.PartitionSopClass where ServerPartitionGUID=@ServerPartitionGUID
>          --PRINT ''Deleting ServerRule''
>          delete dbo.ServerRule where ServerPartitionGUID=@ServerPartitionGUID
> 
>          IF @DeleteStudies=1
>          BEGIN
>                   /* DELETE STUDY, PATIENT AND RELATED TABLES */
>                   delete dbo.RequestAttributes where SeriesGUID in (Select GUID from dbo.Series where ServerPartitionGUID=@ServerPartitionGUID)
>                   delete dbo.Series where ServerPartitionGUID=@ServerPartitionGUID
>                   delete dbo.Study where ServerPartitionGUID=@ServerPartitionGUID
>                   delete dbo.Patient where ServerPartitionGUID=@ServerPartitionGUID                  
>          END
> 
>          --PRINT ''Deleting ServerPartition''
>          delete dbo.ServerPartition where GUID=@ServerPartitionGUID
>          
> END
> ' 
> END
> GO

Command completed successfully.

> /****** Object:  StoredProcedure [dbo].[DeleteWorkQueue]    Script Date: 04/26/2008 00:28:22 ******/
> SET ANSI_NULLS ON
> GO

Command completed successfully.

> SET QUOTED_IDENTIFIER ON
> GO

Command completed successfully.

> IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DeleteWorkQueue]') AND type in (N'P', N'PC'))
> BEGIN
> EXEC dbo.sp_executesql @statement = N'-- =============================================
> -- Author:                  Steve Wranovsky
> -- Create date: April 24, 2008
> -- Description:         Stored procedure for deleting WorkQueue entries
> -- =============================================
> CREATE PROCEDURE [dbo].[DeleteWorkQueue] 
>          -- Add the parameters for the stored procedure here
>          @WorkQueueGUID uniqueidentifier,
>          @ServerPartitionGUID uniqueidentifier,
>          @WorkQueueTypeEnum smallint,
>          @StudyStorageGUID uniqueidentifier
> AS
> BEGIN
>          -- SET NOCOUNT ON added to prevent extra result sets from
>          -- interfering with SELECT statements.
>          SET NOCOUNT ON;
> 
>          declare @StudyProcessTypeEnum as smallint
>          select @StudyProcessTypeEnum = Enum from WorkQueueTypeEnum where Lookup = ''StudyProcess''
>          declare @CleanupStudyTypeEnum as smallint
>          select @CleanupStudyTypeEnum = Enum from WorkQueueTypeEnum where Lookup = ''CleanupStudy''
>          
>          declare @PendingStatusEnum as smallint
>          select @PendingStatusEnum = Enum from WorkQueueStatusEnum where Lookup = ''Pending''
>          
>          BEGIN TRANSACTION
> 
>          UPDATE StudyStorage
>                   SET Lock = 1, LastAccessedTime = getdate()
>          WHERE 
>                   Lock = 0 
>                   AND GUID = @StudyStorageGUID
> 
>          if (@@ROWCOUNT = 1)
>          BEGIN
>                   -- Make sure we lock the study, so no one else can get it
>                   COMMIT TRANSACTION
> 
>                   BEGIN TRANSACTION
> 
>                   IF (@workQueueTypeEnum != @StudyProcessTypeEnum)
>                   BEGIN
>                            DELETE FROM WorkQueueUid WHERE WorkQueueGUID = @WorkQueueGUID
>                            DELETE FROM WorkQueue WHERE GUID = @WorkQueueGUID;
>                   END
>                   ELSE
>                   BEGIN
>                            declare @NewWorkQueueGUID uniqueidentifier
>                            set @NewWorkQueueGUID = NEWID();
> 
>                            INSERT into WorkQueue (GUID, ServerPartitionGUID, StudyStorageGUID, WorkQueueTypeEnum, WorkQueueStatusEnum, ExpirationTime, ScheduledTime)
>                                     values  (@NewWorkQueueGUID, @ServerPartitionGUID, @StudyStorageGUID, @CleanupStudyTypeEnum, @PendingStatusEnum, getdate(), getdate())
> 
>                            UPDATE WorkQueueUid set WorkQueueGUID = @NewWorkQueueGUID WHERE WorkQueueGUID = @WorkQueueGUID
> 
>                            DELETE FROM WorkQueue where GUID = @WorkQueueGUID
>                   END                           
> 
>                   UPDATE StudyStorage
>                            SET Lock = 0, LastAccessedTime = getdate()
>                   WHERE 
>                            Lock = 1 
>                            AND GUID = @StudyStorageGUID
> 
>                   COMMIT TRANSACTION
>          END
>          ELSE
>          BEGIN
>                   ROLLBACK TRANSACTION
>                   RAISERROR (N''Study could not be locked for deletion of WorkQueue entry.'', 18 /* severity.. >=20 means fatal but needs sysadmin role*/, 1 /*state*/)
>                   RETURN 50000
>          END
> 
> END
> ' 
> END
> GO

Command completed successfully.

> 
Playback completed for command file 'ImageServerStoredProcedures.sql'.
Creating filesystem...

> DECLARE @FilesystemTierEnum smallint
> SET @FilesystemTierEnum = (SELECT [Enum] FROM [ImageServer].[dbo].[FilesystemTierEnum] WHERE Lookup = 'Tier1')
> EXECUTE [ImageServer].[dbo].[InsertFilesystem]
> @FilesystemTierEnum
> ,'d:\FS'
> ,1
> ,0
> ,0
> ,'Primary Filesystem'
> ,90
> ,80
> GO

GUID                                   FilesystemPath   Enabled   ReadOnly   WriteOnly   Description          FilesystemTierEnum   LowWatermark   HighWatermark   

------------------------------------------------------------------------------------------------------------------------------------------------------------------
567e606c-bc4a-4e01-ae95-61985649e282   d:\FS            True      False      False       Primary Filesystem   101                  80.0000        90.0000         

1 row(s) affected.

Playback completed for command file 'FileSystem.sql'.
Delete file: C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\FileSystem.sql
Creating partition...

> DECLARE @DuplicateSopPolicyEnum smallint
> SELECT @DuplicateSopPolicyEnum=Enum FROM [ImageServer].[dbo].[DuplicateSopPolicyEnum] WHERE [Lookup]='SendSuccess'
> EXECUTE [ImageServer].[dbo].[InsertServerPartition]
> 1
> ,'Primary Partition'
> ,'SERVERAE'
> ,'104'
> ,'Primary'
> ,@DuplicateSopPolicyEnum
> GO

GUID                                   Enabled   Description         AeTitle    Port   PartitionFolder   AcceptAnyDevice   AutoInsertDevice   DefaultRemotePort   StudyCount   DuplicateSopPolicyEnum   

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
e73dff82-3252-470b-b46c-7a513a767c88   True      Primary Partition   SERVERAE   104    Primary           True              True               104                 0            100                      

1 row(s) affected.

Playback completed for command file 'Partition.sql'.
Delete file: C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\Partition.sql
Starting Service...
Creating virtual directory...
Creating C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\createVDir.vbs
Executing C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\createVDir.vbs
Error timeout in CreateVDir.vbs - Failed to create IIS Virtual Directory
Output folder: d:\Program Files\ClearCanvas\ClearCanvas Image Server
Create shortcut: C:\Documents and Settings\Administrator\Start Menu\Programs\ClearCanvas\ClearCanvas Image Server\ClearCanvas Website.lnk
Create shortcut: C:\Documents and Settings\Administrator\Start Menu\Programs\ClearCanvas\ClearCanvas Image Server\Uninstall ClearCanvas Image Server.lnk
Created uninstaller: d:\Program Files\ClearCanvas\ClearCanvas Image Server\uninst.exe