insert into temp table doesn't work

[amit.barkai]

Hi All

im trying to creat an ad-hoc report with a procedure that has insert into temp table and the execution is failed

it seems the problem is with the insert into temp table becaouse event a simple procedure didnt worked

 

ALTER PROCEDURE [dbo].[ER_GetScanStatistics]

AS

      declare @aa as table  (ID int)

      

      --insert into aa values(2)

      insert into  @aa (ID) values(2)

      

      select * from @aa

get an error  nullcheck username as password , is DBMS active ?

i am using JDBC connection

thanks