create table messenger

 /*
   Table messenger is a relational abstract of the 
   textreader table. While textreader
   is unindexed and relies on sequential input (i.e, BCP) and
   the semaphore construct, messenger is indexed on 
   the sequential input using an identity construct and
   supports rows from multiple systems processes (SPIDS). 
   Data is transient in both messenger and textreader, yet 
   messenger data may persist without blocking other
   processes. 
 */

 IF EXISTS (SELECT * FROM sysobjects 
            WHERE id = OBJECT_ID('dbo.messenger') 
            AND sysstat & 0xf = 3)
	 DROP TABLE dbo.messenger

 GO

 CREATE TABLE dbo.messenger (
	 id INT IDENTITY (1, 1) NOT NULL ,
	 spid SMALLINT NULL ,
	 info VARCHAR (100) NULL ,
	 CONSTRAINT PK_messenger PRIMARY KEY CLUSTERED 
	 (
          id
	 )
 )
GO