Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
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
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 22-Jun-2006 04:31
User is offline View Users Profile Print this message


Duane Hennessy

Posts: 112
Joined: 18-May-2006

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

Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 0 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 0 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.