-- Stored Procedure: dbo.DBConfigSelect
-- 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].[DBConfigSelect]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DBConfigSelect]
GO

CREATE Procedure dbo.DBConfigSelect
AS

/******************************************************************************
** File: dbo.DBConfigSelect.PRC
** Name: dbo.DBConfigSelect
** Desc: get rows to populate ArchWin.daDBConfig datagrid
**
** Auth: Bill Wunder
** Date: 7-25-2003
*******************************************************************************
** Change History
*******************************************************************************
** Date:  Author:  Description:
** -------- -------- ---------------------------------------
**    
*******************************************************************************/
SET NOCOUNT ON
     
-- make sure there is a row for every existing database
exec admin.dbo.DBConfigSetDefault

select DatabaseName
 , IncludeDBScript
 , IncludeDataTypes
 , IncludeDefaults
 , IncludeFunctions
 , IncludeProcedures
 , IncludeRoles
 , IncludeRules
 , IncludeTables
 , IncludeTriggers
 , IncludeUsers
 , IncludeViews
from admin.dbo.ArchUtilDBConfig 
where SQLServerName = @@SERVERNAME
order by DatabaseName
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON 
GO