Msg 207, Level 16, State 3, Line 1

• Vivek Shukla

  SSCrazy

  Points: 2146

  More actions

  April 28, 2009 at 3:42 am

  #133332

  Hi there

  I am trying to run folllowing code in a stored procedure and i am getting 'Invalid column name 'u'' error message. Can anyone help please?

  DECLARE @cmd varchar(255)

  select @cmd = 'SELECT min(ID) FROM sysobjects WHERE xtype = convert(varchar(1),u)'

  exec(@cmd)[

  Thanks in advance.

  PS: I am using sql server 2000

  Vivek Shukla - MCTS SQL Server 2008

• Vivek Shukla

  SSCrazy

  Points: 2146

  More actions

  April 28, 2009 at 3:51 am

  #984942

  No worries. I have found the solution.

  Vivek Shukla - MCTS SQL Server 2008