create table scripts

 /*
   Table scripts is used to create scripts that 
   must be run a remote SQL Server. Basically, a
   script is sucked out of scripts into a text file
   on a remote drive, then an isql call is invoked
   to execute the script on the desired server.
 */

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

 GO

 CREATE TABLE dbo.scripts (
	 id INT IDENTITY (1, 1) NOT NULL ,
	 name VARCHAR(30) NOT NULL ,
	 line CARCHAR(100) NOT NULL ,
	 CONSTRAINT PK_scripts PRIMARY KEY CLUSTERED 
	 (
		name,
		id
	 )
 )
 GO