![]() |
Telelogic System Architect (steve huntington) | ![]() |
Topic Title: List of all System Architect Encyclopedias Topic Summary: How to list all SA Encyclopedias within a SQL Server. Created On: 22-Jun-2006 04:31 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
For those wanting a list of System Architect Encyclopedias within a SQL Server that has other databases within it, I built this Procedure that returns a recordset of SA Databases.
-- Author: Duane Hennessy -- 'Company: CorpTech, Non-SAP Support / SSS Infrastructure, 07-3008-8842 -- 'Date: 22/06/2006, 12:10 PM -- Description: Return a recordset of database names that have the table 'SAProperties' within them. -- 'Dependencies: Assumption: That only SA Database (Encyclopedias) have an SAProperties table within them. -- 'Updates: updates_here -- 'Notes: notes_here
CREATE PROCEDURE SA_Database_Names AS if Object_Id('tempdb..#SA') is not null drop table #SA create table #SA (table_name varchar(20)) exec sp_MSforeachdb 'insert into #SA select distinct table_catalog from ?.information_schema.tables where table_name=''SAProperties''' select * from #SA GO |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.