Stored Procedure & User Table

• robmarch

  SSC Rookie

  Points: 44

  More actions

  April 16, 2002 at 4:46 am

  #157702

  I created the following sp as dbo then run it as cmss_user. The table gets created but then the select fails with ('aarobtmp does not exist'). cmss_user has db_owner. Can anyone help?

  CREATE PROCEDURE rob_tmp_1

  AS

  SELECT glt_urn,

  glt_code,

  glt_description

  INTO aarobtmp

  FROM ncm_general_list_type

  SELECT * FROM aarobtmp

  GO

• Eve

  SSCrazy

  Points: 2480

  More actions

  April 16, 2002 at 8:12 am

  #427274

  You have to name your temp.table with prefix '# '

  like #aarobtmp:

  CREATE PROCEDURE rob_tmp_1

  AS

  SELECT glt_urn,

  glt_code,

  glt_description

  INTO #aarobtmp

  FROM ncm_general_list_type

  SELECT * FROM #aarobtmp

  GO