LISTING A: Example That Uses sp_procoption to Create
 a Global Temporary Table

USE master
GO

CREATE PROC sp_Create_Globals
AS

CREATE TABLE ##Globals
(
  var_name sysname     NOT NULL PRIMARY KEY,
  value    sql_variant NULL
)
GO

EXEC sp_procoption 'sp_Create_Globals', 'startup', 'true'
GO