Metadata Collection - SQL Server Integration Services Design Patterns - page 7

Figure 1-2 . SQL Server Management Studio 2012

Next, you need a list of SQL Server instances to monitor. The easiest way to ac-
complish this is to store a list of database instance names in a file or table. You will use
the latter method. Using the code in Listing 1-2 , create that table now inside your
newly created database.

Listing 1-2 . Example of T-SQL Code to Create a Table for Monitoring SQL Server In-
stances

USE dbaCentralLogging;
GO

CREATE TABLE dbo.dba_monitor_SQLServerInstances
(

SQLServerInstance NVARCHAR(128)

, LastMonitored SMALLDATETIME NULL

CONSTRAINT PK_dba_monitor_SQLServerInstances