INSERT Error?

• Tara-1044200

  SSCoach

  Points: 15951

  More actions

  May 14, 2009 at 10:53 am

  #155706

  select * into dbo.Revmulti from Stage_Revmulti.dbo.doubleRev where 1=0

  when i run the aboe query i get this error

  Msg 262, Level 14, State 4, Line 1

  SHOWPLAN permission denied in database Stage_Revmulti'.

  I am not sure what SHOWPLAN has to do with my insert?

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  May 14, 2009 at 10:56 am

  #994715

  You must have show exectution plan option turned on, turn this off and this query should run fine.

  its also worth noting that

  where 1=0

  means that your query will never return any rows since 1 will never equal 0