home *** CD-ROM | disk | FTP | other *** search
/ moodle.waes.ac.uk / moodle.waes.ac.uk.zip / moodle.waes.ac.uk / TMG / SP1-TMG-KB981324-AMD64-ENU.msp / PCW_CAB_SHFx2 / F2143_msfpcui.dll / BINARY / 25125 < prev    next >
Text File  |  2010-06-15  |  538b  |  13 lines
  1. IF OBJECT_ID ('tblServerParticipationSummary', 'u') IS NULL
  2. BEGIN
  3.     CREATE TABLE [dbo].[tblServerParticipationSummary](
  4.         [FromDate] [datetime] NULL,
  5.         [ToDate] [datetime] NULL,
  6.         [RunDate] [datetime] NULL,
  7.         [ServerName] [nvarchar](32) NULL
  8.     ) ON [PRIMARY]
  9.  
  10.     EXECUTE dbo.ISA_spDuplicateEmptyTable 'tblServerParticipationSummary', 'tblServerParticipationSummary_Daily', 0
  11.     EXECUTE dbo.ISA_spDuplicateEmptyTable 'tblServerParticipationSummary', 'tblServerParticipationSummary_Monthly', 0
  12. END
  13.