-- Stored Procedure: dbo.SrvConfigSelect
-- Bill Wunder

use admin
GO
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SrvConfigSelect]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SrvConfigSelect]
GO

CREATE PROCEDURE dbo.SrvConfigSelect
AS
/******************************************************************************
** File: dbo.SrvConfigSelect.PRC
** Name: dbo.SrvConfigSelect
** Desc: get row to populate ArchWin.daSrvConfig datagrid
**
** Auth: Bill Wunder
** Date: 7-25-2003
*******************************************************************************
** Change History
*******************************************************************************
** Date:  Author:  Description:
** -------- -------- ---------------------------------------
**    
*******************************************************************************/
SET NOCOUNT ON

SELECT IncludeAlerts
 , IncludeBackupDevices
 , IncludeJobs
 , IncludeLocalDTSPackages
 , IncludeLogins
 , IncludeLinkedServers
 , IncludeOperators
 , IncludeRepositoryDTSPackages
 , IncludeServerConfiguration
 , IncludeServerRoles
 , VSSShare
 , VSSRootProject
 , VSSUserName
 , VSSPassword
 , LocalWorkingFolder
 , LicensedCompany
 , LicensedUser
 , LicenseCode
 , SQLServerName 
FROM admin.dbo.ArchUtilSrvConfig 
WHERE SQLServerName = @@SERVERNAME
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON 
GO