Home Forums SQL Server 2008 SQL Server 2008 Administration How to fix Logon trigger issue RE: How to fix Logon trigger issue

  • September 5, 2013 at 3:09 pm

    #1647855

    this is the schema and this table is created I the user database

    [SPID] [int] NULL,

    [LoginName] [varchar](512) NULL,

    [HostName] [varchar](512) NULL,

    [HostID] [int] NULL,

    [LoginTime] [datetime] NULL,

    [ApplicationName] [varchar](512) NULL,

    [DatabaseName] [varchar] (10)

    which login should I give insert permission to this table and why it is blocking all user's to log into the database