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 / 25418 < prev    next >
Text File  |  2010-06-15  |  376b  |  15 lines
  1. CREATE PROCEDURE [dbo].[ISA_spFlushCommitedInit] 
  2.     @RemoteTableName varchar(100)
  3. AS
  4. BEGIN
  5.     SET NOCOUNT ON;
  6.  
  7.     IF OBJECT_ID (@RemoteTableName, 'u') IS NOT NULL
  8.     BEGIN
  9.         EXECUTE('DROP TABLE [' + @RemoteTableName + ']')
  10.     END
  11.  
  12.     EXECUTE('CREATE TABLE [dbo].[' + @RemoteTableName + '] (TempTableName varchar(300), TableName varchar(300))')
  13.  
  14. END
  15.