• How would I tie back a table such as the one below to the trigger?

    USE GK50LIVE;

    GO

    SET NOCOUNT ON;

    USE GK50LIVE

    go

    -- Create LIMITEDLOGINS Table

    CREATE TABLE dbo.LimitedLogins

    (

    Id INT IDENTITY(100,1) PRIMARY KEY

    ,Login_Name VARCHAR (50) NOT NULL

    ,LOGIN_ID VARCHAR (50) NOT NULL

    ,NUM_ALLOWED TINYINT NOT NULL

    ,Date_Added Date NULL

    );

    --Add values to the LimitedLogins Table

    USE GK50LIVE

    go

    INSERT INTO LimitedLogins

    (Login_Name , LOGIN_ID, NUM_ALLOWED)

    VALUES

    ('James Smith', 'jsmith','1')

    ,('Joe Kim', 'jkim','1')

    ,('Gary Harpogian', 'gharpogian','1');