WEIRD TEMP TABLE/STORED PROCEDURE ERROR

Results 1 to 2 of 2

Thread: WEIRD TEMP TABLE/STORED PROCEDURE ERROR

  1. #1
    Alvin Gee Guest

    Default WEIRD TEMP TABLE/STORED PROCEDURE ERROR

    I&#039m having problems with the below stored procedure statement:<BR><BR>create table #TempItems<BR> (<BR>id int identity, <BR>FirstName varchar(50)<BR>)<BR><BR>I get the following error message when I apply this statement even though the "Check Syntax" comes out correctly:<BR><BR>----<BR>Error 21037: [SQL-DMO] The name specified in the Text property&#039s<BR>&#039Create...&#039 stsatement must be followed by valid TSQL statements<BR><BR>Thanks if anyone can help

  2. #2
    Jairo Guest

    Default RE: WEIRD TEMP TABLE/STORED PROCEDURE ERROR

    I typed in your exact statement and it works fine on MSSQL 6.5 isql.<BR><BR>create table #TempItems<BR>(<BR>id int identity, <BR>FirstName varchar(50)<BR>) <BR><BR>HTH,<BR>Jairo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •