ColumnID is getting as Null

• prashant bujone

  SSC Veteran

  Points: 216

  More actions

  May 30, 2008 at 6:14 am

  #380831

  hi

  I am trying to write a trigger (after update) in which i am using COLUMNS_UPDATED( ) function.

  For this i was trying to get ColumnID value for the columns of the table.

  I am trying following query but getting Null as ColumnID value

  Is it a permission related issue or any configuration needs to set?

  SELECT TABLE_NAME, COLUMN_NAME,

  COLUMNPROPERTY(OBJECT_ID(TABLE_SCHEMA + '.' + TABLE_NAME),

  COLUMN_NAME, 'ColumnID') AS COLUMN_ID

  FROM sample1.INFORMATION_SCHEMA.COLUMNS

  WHERE TABLE_NAME = 'emp';

  Thanks

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  May 30, 2008 at 7:15 am

  #822291

  Are you working with two different databases? I could see that the select is querying in sample1 database.

  --Ramesh
  

  ---

• prashant bujone

  SSC Veteran

  Points: 216

  More actions

  May 30, 2008 at 7:50 am

  #822322

  No i am working on single database i.e. sample1

  The table emp is in sample1 database